Viewing 15 posts - 6,106 through 6,120 (of 22,219 total)
There are a couple of small ways you can manipulate plan cache though. You can drop an individual plan from cache by passing the plan handle. You can also avoid...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:06 am
I would probably look to Extended Events to track this. You'd probably need to capture individual statements. If you use Causality Tracking, you should be able to see the chain...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:02 am
It is possible for the backup itself to become corrupted. I'm with Eirikur, test it on the client side first to see if they get the same issue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 5:59 am
GilaMonster (5/14/2015)
Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 4:22 am
Vyper426 (5/14/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 4:10 am
jasona.work (5/13/2015)
:hehe:
On an unrelated note, does anyone here have any experience with Barracudda Networks backup appliance, both...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2015 at 1:01 am
Paul Randal (5/13/2015)
If you're offloading DBCC...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2015 at 1:00 am
Jeff Moden (5/13/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2015 at 12:56 am
SQLRNNR (5/13/2015)
Grant Fritchey (5/13/2015)
One point. i said that BLOB storage was outside the database. That's not right. Not sure where my head was. Gail spotted it and corrected me.
Maybe in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2015 at 12:52 am
For a point lookup (one row) against a clustered index, there really isn't a major performance hit.
But, some of the places where there are issues. First, pages in memory. By...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2015 at 10:07 am
Also, I need a new head, FILESTREAM data is stored apart from the database, but is backed up and restored through the backup process.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2015 at 9:57 am
One point. i said that BLOB storage was outside the database. That's not right. Not sure where my head was. Gail spotted it and corrected me.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2015 at 7:38 am
GilaMonster (5/13/2015)
Grant Fritchey (5/13/2015)
Because you can have physical corruption that doesn't get backed up or restored.
How?
I keep hearing this advice, but the problem is it doesn't bear out. Backups are...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2015 at 7:32 am
Because you can have physical corruption that doesn't get backed up or restored.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2015 at 7:10 am
A database is the definition of the structures and other objects that make up a database (tables, views, procedures, users, roles, etc.). The data is stored within the structures of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2015 at 7:09 am
Viewing 15 posts - 6,106 through 6,120 (of 22,219 total)