Viewing 15 posts - 11,581 through 11,595 (of 22,224 total)
vultar (12/2/2011)
Thanks for your response Grant.. What would you say is reasonable amount of time to measure over ?Cheers
Vultar
Personally? A week. I like to be able to see the rise...
"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
December 2, 2011 at 5:35 am
First suggestion I have, bump up your cost threshold for parallelism to 40 or 50. You're getting parallel execution on this plan with an estimated cost of 25, and 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
December 2, 2011 at 5:26 am
The optimization on the plan is Full, so this is a good plan. That suggests that that principal problem is with your statistics, not the structure of the query (to...
"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
December 2, 2011 at 5:20 am
That is a particularly hairy execution plan.
There a few issues. First, it looks like your statistics might be off. Down in the really nasty part of the plan estimated row...
"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
December 2, 2011 at 5:14 am
With bare metal all you can measure is potential. SQLIO is the way to go.
However, if you're consolidating, measure the other servers before you start moving stuff onto the new...
"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
December 2, 2011 at 4:54 am
Full backups don't affect log backups in that way. They only affect differential backups. If that's not part of your restore strategy, then you're fine.
"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
December 2, 2011 at 4:49 am
Second vote for PowerShell. I'm pretty sure Allen White has a script over here somewhere.
"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
December 2, 2011 at 4:47 am
Although, you can see an aggregate history of the executions in cache. If you look at sys.dm_exec_query_stats you can find an aggregation of performance metrics for any query still 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
December 2, 2011 at 4:45 am
Kiara (12/1/2011)
Brandie Tarvin (12/1/2011)
GSquared (12/1/2011)
"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
December 1, 2011 at 1:23 pm
GSquared (12/1/2011)
"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
December 1, 2011 at 9:32 am
Just a side note, if you don't have backups of this database, are you running backups of your other databases? If not, in addition to worrying about getting this one...
"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
December 1, 2011 at 7:51 am
I'm sorry to say, there's no easy way to explain this. I've written two different books, one on query tuning and one on reading execution plans. There's that much material...
"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
December 1, 2011 at 5:11 am
Lexa (11/30/2011)
1. UPDLOCK [what happens when used in "insert table1 select * from...
"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
December 1, 2011 at 5:07 am
If you're using Transparent Data Encryption, and the key is properly installed on the server, you should just be able to query the data. If not, I think this is...
"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
December 1, 2011 at 5:02 am
Most of the software out there allows you to download it and try it out. Each one offers different sets of details and has some different monitoring mechanisms. I'd suggest...
"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
December 1, 2011 at 4:52 am
Viewing 15 posts - 11,581 through 11,595 (of 22,224 total)