Viewing 15 posts - 1 through 15 (of 52 total)
Disregard - I found a solution by adding the Testfield after the minus sign as it's own case statement.
January 18, 2017 at 3:04 pm
GilaMonster (7/26/2012)
You're IO bound. Fiddling with CPU and memory won't help, the IO subsystem is the bottleneck.Can you write the backups to a different destination? One that's faster preferably.
After spending...
July 27, 2012 at 7:09 am
The wait types during the backup slowness are Async_IO_Completion, Backupbuffer, and Backupio. And I've tried a third party tool and sql backups. Both result in slowness, and the same wait...
July 26, 2012 at 7:53 am
Yes unfortunetly it's 24x7. I'm putting in my recommendation to burn lefthand! Thank you for your help
July 25, 2012 at 12:22 pm
Are you compressing the backups? Have you considered a 3rd party backup tool?
How many filegroups does the DB have?
That's what I expected i/o. We do have a third party tool...
July 25, 2012 at 11:46 am
Lynn Pettis (7/3/2012)
SQLRNNR (7/3/2012)
Lynn Pettis (7/3/2012)
SQLRNNR (7/3/2012)
sqluser_8119 (7/3/2012)
Lynn Pettis (7/3/2012)
SQLKnowItAll (7/3/2012)
July 3, 2012 at 1:50 pm
Lynn Pettis (7/3/2012)
SQLKnowItAll (7/3/2012)
Are you running out of space? If so, I wouldn't shrink them. Just continue to use up the available space.
I'm going to throw out the...
July 3, 2012 at 1:16 pm
Yes they were changed from the defaul "PRIMARY" filegroup to a different filegroup. The old location never shrank in size, and the new location is 500 GB larger.
July 3, 2012 at 12:47 pm
Great they both worked...thank you everyone!
June 13, 2012 at 12:06 pm
It's peanut butter jelly time!!
Yeah that's what I thought - sql by design. What is the reasoning behind that - why does it slowly consume memory? All of the...
June 6, 2012 at 6:42 am
I removed it so no one else would think that 🙂 Thank you so much...this works perfectly. I can always count on someone from here to help.
May 23, 2012 at 1:53 pm
This isn't real data so relax
May 23, 2012 at 1:46 pm
Viewing 15 posts - 1 through 15 (of 52 total)