Viewing 15 posts - 11,311 through 11,325 (of 22,226 total)
GROUP BY and DISTINCT are both aggregate operations, so you might not have saved anything there.
In general, check the SELECT properties. If you see a timeout as the reason...
"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
February 7, 2012 at 5:58 am
Also use STATISTICS IO and compare the number of reads and writes. Do that in addition to measuring time. Both are applicable.
"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
February 7, 2012 at 5:48 am
It can affect the other processes, yes. No process you run is free of cost. Doing a scanned update of statistics is fairly low cost, and usually you can 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
February 7, 2012 at 5:45 am
For quick information on what's running slow, use sys.dm_exec_query_stats to pull out the most frequently called queries or the longest running queries. From there though, you need to know what...
"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
February 7, 2012 at 5:40 am
Nope, not a single issue at all. Great way to do the upgrade. I've done... oh, a whole bunch that way.
However, you should run the Upgrade Advisor first because there...
"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
February 7, 2012 at 5:38 am
The fact that you need a DISTINCT operation in there suggests you might have a structural or data problem you need to concentrate on first.
Also, why are you returning 50000...
"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
February 7, 2012 at 5:33 am
Yeah, totally different. When I've run into that one it's usually been a configuration issue. Either I'm not running the right SP on the server, or the developers are running...
"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
February 6, 2012 at 12:37 pm
GSquared (2/6/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
February 6, 2012 at 11:53 am
I'd put them inside the statement too.
I don't remember how to do it, but it's possible to lose comments that are outside the statement (can't remember how that happens for...
"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
February 6, 2012 at 11:27 am
I'd do a more thorough comparison between this box and the old one to detrmine what all the differences are.
As far as MAXDOP goes, I prefer to leave it set...
"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
February 6, 2012 at 11:25 am
Something over the weekend took more resources than you have available. You just have to figure out what to start trying to troubleshoot the issue.
Is SQL Server alone on 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
February 6, 2012 at 11:23 am
Both occur during that period. To see if it's the exec plan, remove it from cache and then just ask for an estimated plan. However long that takes is your...
"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
February 6, 2012 at 10:15 am
GilaMonster (2/6/2012)
Grant Fritchey (2/6/2012)
Go easy on him. He's trying. Gentle guidance, not all up in his grill.Already done days back. No reply and no improvement.
Understood.
I'm just nervous. We've had a...
"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
February 6, 2012 at 8:30 am
Go easy on him. He's trying. Gentle guidance, not all up in his grill.
"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
February 6, 2012 at 8:21 am
Changing it from non-clustered to clustered won't affect the data in other tables, no.
There are a ton of other affects you're going to see, yeah, but no, it shouldn't change...
"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
February 6, 2012 at 5:13 am
Viewing 15 posts - 11,311 through 11,325 (of 22,226 total)