Viewing 15 posts - 12,841 through 12,855 (of 22,224 total)
Grubb (4/4/2011)
Grant Fritchey (4/4/2011) since "slow" in this case is 300ms
Tell me about it. Not a good one to really cut my teeth on.
The Tuning Advisor recommended my covered...
"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
April 4, 2011 at 11:20 am
It absolutely could be parameter sniffing, yes, but it also could be contention on resources. Does the table have inserts, updates or deletes that occur? If so, you might be...
"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
April 4, 2011 at 10:16 am
Reinforcing what Gianluca said, Red Gate's SQL Monitor really is an excellent choice for monitoring servers and the price is very reasonable. If you want to, you can actually play...
"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
April 4, 2011 at 10:11 am
Even if you place it in single user mode, if you're connected to that database or another connection is there, it might still be active when you try to run...
"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
April 4, 2011 at 6:33 am
Abrar Ahmad_ (4/4/2011)
Do DMV/Fs provide "Actual Execution Plan" or "Estimated Execution plan" specially Sys.DM_exec_Query_Plan?
Logically it should be "Actual Execution Plan" rather than "Estimated...
"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
April 4, 2011 at 6:09 am
SQLkiwi (4/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
April 4, 2011 at 6:06 am
WayneS (4/3/2011)
Grant Fritchey (4/3/2011)
I'm just glad it's over. All that crap is out of my basement. Yay!So, whose more glad about that... you or your family?
Oh, the wife is pretty...
"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
April 4, 2011 at 6:04 am
WayneS (4/1/2011)
I'm specifically interested in the use of stored procedures.
1. Should ORM tools...
"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
April 4, 2011 at 4:57 am
Jeff Moden (4/3/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
April 4, 2011 at 4:54 am
SQLkiwi (4/2/2011)
Got to meet heaps of great people including Grant and Stefan K!
If anyone would like to see the slides...
"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
April 3, 2011 at 5:04 am
SQLkiwi (4/1/2011)
Hi everyone. Just to confirm it officially: I am now a SQL Server MVP (yay!)Thanks to everyone for their kinds words and encouragement.
Paul
Congratulations again Paul. Extremely well deserved.
And...
"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
April 3, 2011 at 5:02 am
Roy Ernest (4/1/2011)
Shaken and hurts. Other wise I am Ok. Thx
Sorry to hear it. Take it easy and feel better.
"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
April 3, 2011 at 4:59 am
Fixed it. Sorry about that.
"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
April 1, 2011 at 9:11 am
David Benoit (4/1/2011)
Grant Fritchey (4/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
April 1, 2011 at 8:56 am
On a guess, the optimizer timed out trying to unpack the views and the "best" plan at the time of the timeout was missing the predicate because the optimizer hadn't...
"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
April 1, 2011 at 8:03 am
Viewing 15 posts - 12,841 through 12,855 (of 22,224 total)