Viewing 15 posts - 13,516 through 13,530 (of 22,232 total)
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
I know that i have not invented an amazing new mouse trap. If the bits of knowledge that I communicate out there are helping, great. Yes, if you just steal...
"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:24 am
Thanks everybody.
And remember, buy Red Gate... kidding, just kidding. Put that rock down.
"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:19 am
Viewing 15 posts - 13,516 through 13,530 (of 22,232 total)