Viewing 15 posts - 13,501 through 13,515 (of 22,219 total)
Good points Gus. This is meant to be my introductory session on execution plans (it's going, more or less intact, into my SQL Rally all day session). Thanks. Great feedback.
"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
January 25, 2011 at 10:14 am
Not knowing how your backups are configured or running, it's hard to say. But it sounds like whatever process is running the backups either doesn't have that database included, or,...
"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
January 25, 2011 at 9:32 am
It's not something I've run into. Can you post the specific error message, if any?
Is there any chance a different process is also calling the log backup procedure?
"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
January 25, 2011 at 9:31 am
If you're not seeing CPU or Disk issues, I'd start looking for weird stuff. Do you have lots of connections unclosed? Are there uncommitted transactions? Stuff like that. Something 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
January 25, 2011 at 9:28 am
Another possibility is differences in the physical boxes. We had a production box once that had slower CPU's the dev box. Made us crazy for a while til we noticed....
"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
January 25, 2011 at 9:26 am
scorpianprince (1/25/2011)
If huge transactions are happening and if the large insertions and deletions is a daily process then he don't have any other method.
If huge transactions are occurring daily 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
January 25, 2011 at 9:22 am
Maybe use the rule of three's like you suggested for mine? I thought it was a good idea.
"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
January 25, 2011 at 8:52 am
Oooh, that sounds good. When are you putting that session on?
Seriously, thanks. That makes sense. I'll work that in with the edits I'm going to use from Roy's feedback.
"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
January 25, 2011 at 8:50 am
Me too. The last one works best. I think Resume still needs to be in the title.
"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
January 25, 2011 at 8:48 am
If it will help your tinkering (and you can write an article if you get done first), the approach I was going to take was to use PowerShell to do...
"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
January 25, 2011 at 8:46 am
Where's my flipping brain...
Thank you Roy. Feedback is a gift. I appreciate it.
"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
January 25, 2011 at 6:48 am
Brutally honest is good.
So, spice it up a bit. OK. I can do that. More from others?
"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
January 25, 2011 at 6:47 am
Koen (da-zero) (1/25/2011)
Grant Fritchey (1/25/2011)
Thanks everybody.And remember, buy Red Gate... kidding, just kidding. Put that rock down.
http://www.sqlservercentral.com/Forums/Topic1052321-391-1.aspx
Your help is needed, Redgate Man! (insert heroic music here)
:-D:hehe:
Da-Da-Daaa Da-Da-Da
Not sure why they're...
"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
January 25, 2011 at 6:43 am
Yes, you should be able to do this from the command line, I've done it before. I'll add this to a list of new articles I'm working on (just started...
"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
January 25, 2011 at 6:36 am
Roy Ernest (1/25/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
January 25, 2011 at 6:32 am
Viewing 15 posts - 13,501 through 13,515 (of 22,219 total)