Viewing 15 posts - 11,311 through 11,325 (of 22,219 total)
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
No real way to give you solid advice based on generalities.
But, in general, test your queries. Concentrate on set-based solutions. Avoid row-by-row processing. Make sure the queries are avoiding all...
"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:11 am
The problem with disk queue length on a san is that you don't have any idea how many disks are involved, so the queue count isn't a number that allows...
"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 4:59 am
Nope. That's not very selective at all. The recommended practices are that the data be about 1% selective, meaning 1 distinct value out of 100 rows. In practice it's usually...
"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 3:39 am
Here's another short article[/url] to get you started on log backups.
"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 5, 2012 at 5:55 am
blech, blech, blech
"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 3, 2012 at 12:00 pm
Oh man, I don't remember the specifics.
I do remember that we had code that made a call through ADO (I think it was) that retrieved the data structure of...
"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 3, 2012 at 7:32 am
Hmmm... Contention for resources? Other processes running at the same time? Ummm... Not sure. But if you're getting pain from a multi-statement TVF, the best solution I know is 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
February 3, 2012 at 7:25 am
Viewing 15 posts - 11,311 through 11,325 (of 22,219 total)