Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

The Gambler Expand / Collapse
Posted Friday, March 15, 2013 9:28 AM


Group: General Forum Members
Last Login: Tuesday, January 26, 2016 9:10 AM
Points: 2,602, Visits: 1,694
henrik staun poulsen (3/15/2013)

The only solution is to really get a good second box and throw some horsepower on it. I'd try to run it every week.
yes, agree, and we have done that. Only problem is that a restore (from disk not from tape) takes 3 days, and DBCC CHECK_DB another 2 days.
That leaves very little time for other use of the box.
My manager thinks that's a little expensive.

Best regards,
Henrik Staun Poulsen
Stovi Software


Just a thought after reading this again, have you considered standing up a cloud server with the express purpose of DBCC CHECK_DB? Stand up the cloud server that has the necessary resources to process in a few hours and let it rip. When done take it down. It might get the job done in a far more reasonable time period and should not cost such that your manager would worry about the extra dollars.

Might be worth a shot!


Not all gray hairs are Dinosaurs!
Post #1431593
Posted Friday, March 15, 2013 4:43 PM


Group: General Forum Members
Last Login: Thursday, October 13, 2016 6:11 AM
Points: 198, Visits: 508
Good idea, Miles.

Who knows, it might even turn out to be a more cost effective and better performing platform than what Henrik has at the moment.

Henrik, 3 days to restore from disk sounds like "very thin provisioning". How many terabytes is your database?

You should try solid state disks - more expensive to buy but cost per IO much less than spindle disks.
Post #1431836
Posted Saturday, March 16, 2013 7:41 AM



Group: General Forum Members
Last Login: Today @ 12:33 AM
Points: 1,758, Visits: 1,204
Hi Miles, Howard,

A very good idea that I'll look at on Monday.
Last time I looked, there were a limit at 15 TB, but that is quite some time ago.
I'm not sure how happy our network guys will be if we send 35 TB to the cloud every week.

It is indeed "very thin provisioning", only 486 GB per hour or 136 MB/s.

Unfortunately, we could only get "shared storage" for the test system
On the production system we get an order of magnitude more, I believe.

Best regards,

Post #1431894
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse