Viewing 15 posts - 13,321 through 13,335 (of 22,227 total)
It's also possible, even though the plan changed, that you ran into resource contention or blocking or something else entirely.
Without lots more detail, it's hard to know. Based on everything...
"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 10, 2011 at 6:32 pm
But, almost forgot this, that assumes no compression. If you're using compression, all bets are off on making that estimate.
"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 10, 2011 at 6:29 pm
The backup consists of the actual space used in the data and log files (not the space allocated) plus a bit of room for meta data and some more 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 10, 2011 at 6:27 pm
I think it's possible that might lead to multiple plans (sort of, actually you're likely to see multiple plans for the different strings, but a single plan for the proc),...
"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 10, 2011 at 6:02 pm
Congrats Brandie. That's really wonderful. Well done.
"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 10, 2011 at 11:23 am
Brandie Tarvin (2/10/2011)
Ninja's_RGR'us (2/10/2011)
kasaranenikiran-725528 (2/10/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
February 10, 2011 at 6:33 am
Ninja's_RGR'us (2/10/2011)
kasaranenikiran-725528 (2/10/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
February 10, 2011 at 5:36 am
As soon as you need to start taking direct control over what is running within Maintenance Plans, you've just out-grown them. This is actually kind of a great moment. Now...
"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 9, 2011 at 5:06 pm
I think your assessment of the issue is accurate. I'm glad things are back on track. I'd suggest you might want to set up some statistics maintenance. The auto update...
"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 9, 2011 at 5:00 pm
m.s.blake (2/9/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
February 9, 2011 at 4:58 pm
Not seeing the code, I'm guessing, but I'll bet one or more of your queries are dynamic using EXEC or sp_executeSQL. That would explain why you have two apparent plans...
"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 9, 2011 at 12:54 pm
I'd favor going for the Developer version over SQL Express. There is just so much you can't do with SQL Express that is a standard part of SQL Server. If...
"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 9, 2011 at 12:52 pm
From what you've supplied, it's hard to be sure where the problem is occurring. You're saying that the query is a loop? That could be the problem right there. 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
February 9, 2011 at 12:33 pm
Jan Van der Eecken (2/9/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
February 9, 2011 at 11:36 am
Steve Jones - SSC Editor (2/9/2011)
BACKUP DATABASE MYDatabase to disk = 'c:\mybackup.bak'
runs to the C: drive on...
"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 9, 2011 at 9:13 am
Viewing 15 posts - 13,321 through 13,335 (of 22,227 total)