Viewing 15 posts - 10,576 through 10,590 (of 22,219 total)
If the massive slowdown was just for the first few hours, I would assume it had something to do with caching. But since you get slow behavior for up 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
August 13, 2012 at 8:22 am
In addition to setting the Max Degree of Parallelism, make sure you change the Threshold for Parallelism setting too. The default value of 5 is way too low. I'm not...
"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
August 13, 2012 at 8:20 am
GilaMonster (8/13/2012)
The plan cache will give...
"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
August 13, 2012 at 5:14 am
It sounds like a case of bad parameter sniffing. This occurs when a particular parameter value is used and the statistics are different for it than for the hard-coded value....
"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
August 13, 2012 at 4:44 am
It's a less than perfect approach, but you could simply query sys.dm_exec_query_stats (or if you really are only interested in procedures, then sys.dm_exec_procedure_stats) and order by the last execution date...
"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
August 13, 2012 at 4:36 am
naga.rohitkumar (8/11/2012)
THANKS AND MAY IKNOW UR PERSONEL MAIL ID AND UR DESIGNATION WHERE U WORK
Just curious, but that's a really odd question. Why do you need that in order 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
August 13, 2012 at 4:29 am
I'm with you. If you can get a quick, full backup (copy only of course), or better still, like Gail says, a snapshot, then that's the way to go. Absolutely,...
"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
August 13, 2012 at 4:27 am
I'm maxed out for the rest of the year. I'll be in Oklahoma City in a couple of weeks and Rhode Island in September, but after that, it's all SQL...
"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
August 4, 2012 at 6:19 am
WayneS (8/2/2012)
"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
August 3, 2012 at 5:06 am
GSquared (8/1/2012)
Ooohhh! I bet that made you popular!Not that the consultant did anything wrong, but I bet a few people took his comment as a kick to the ego-groin.
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
August 2, 2012 at 5:36 am
Kiara (8/1/2012)
Does this look like a giant advertisement to anyone else?http://www.sqlservercentral.com/Forums/Topic1039196-391-1.aspx
Nah, I'm sure 5 different people are going to swoop in and post once time on the same forum just...
"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
August 1, 2012 at 7:38 am
SQLRNNR (7/31/2012)
Grant Fritchey (7/31/2012)
"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
August 1, 2012 at 7:36 am
Looks ok. No, it doesn't ignore procedures. Procedures show up in both query stats and proc stats. You can just use proc stats to narrow down what you're querying against...
"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
August 1, 2012 at 7:35 am
To get fine control over that type of maintenance, I'd suggest getting a copy of Michelle Ufford's scripts or Ola Hollengren's scripts. They'll do a much better job than Maintenance...
"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
August 1, 2012 at 7:33 am
GilaMonster (7/31/2012)
Creating a good, solid, scalable design is not premature optimisation. It's doing a good #@$@# job.
+Infinity
Especially for the curse words.
"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
August 1, 2012 at 7:16 am
Viewing 15 posts - 10,576 through 10,590 (of 22,219 total)