Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:04 AM
Points: 2,299, Visits: 1,356
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


Henrik

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!

Miles...





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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 15, 2014 10:25 AM
Points: 172, Visits: 379
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 8:07 AM
Points: 1,366, Visits: 989
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,
Henrik




Post #1431894
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse