Viewing 15 posts - 11,566 through 11,580 (of 22,219 total)
nico van niekerk (12/5/2011)
Grant Fritchey (12/5/2011)
nico van niekerk (12/4/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 5, 2011 at 11:46 am
nico van niekerk (12/2/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 5, 2011 at 11:41 am
Oldman@ds9 (6/22/2010)
I've the similar Problem on by new SQL-Sever, having a lot of freee memory. I still not found a resolution.
I realize this thread is 18 months old, but I'm...
"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 5, 2011 at 7:42 am
nico van niekerk (12/4/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 5, 2011 at 5:41 am
The chapter I wrote for the MVP Deep Dives 2 book is all on parameter sniffing "Parameter Sniffing, Your Best Friend in the World, Except When It Isn't." I lay...
"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 4, 2011 at 4:43 am
If you look at sys.dm_exec_requests you can see what the process is currently waiting on. You can also get a link to what locks are being held by the...
"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 4, 2011 at 4:40 am
It's hard to know for sure in these situations without a lot more detail. In general, I'd assume an issue with statistics and/or blocking. You say no other processes were...
"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 4, 2011 at 4:37 am
Let me try:
Hadoop
Ellison
Database Tuning Advisor
Nope. It's broke.
"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 9:04 am
Ninja's_RGR'us (12/2/2011)
Grant Fritchey (12/2/2011)
Ninja's_RGR'us (12/2/2011)
kyle.doouss (12/2/2011)
Some times I use the design mode which then screws up the layout.Is there no way apart from reformatting manually then?
http://www.red-gate.com/products/sql-development/sql-prompt/
I'm glad you brought it...
"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 6:03 am
Ninja's_RGR'us (12/2/2011)
kyle.doouss (12/2/2011)
Some times I use the design mode which then screws up the layout.Is there no way apart from reformatting manually then?
http://www.red-gate.com/products/sql-development/sql-prompt/
I'm glad you brought it up. I've been...
"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:36 am
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
Viewing 15 posts - 11,566 through 11,580 (of 22,219 total)