Sunday, November 8, 2009

Consistency checking for a 1.2 TB database

I would like to share with you my recent experience on how to build consistency checking for VLDB by using DBCC CHECKDB/CHECKTABLE and etc. I was following Paul's great article
http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Consistency-Checking-Options-for-a-VLDB.aspx
to build the same or almost the same strategy on the client's site. They have 8 huge tables arround 658,245,225 pages each table and I tested the bigest one to run DBCC CHECKTABLE command. It took 17 hours to complete the task but unfortunately it was not acceptable for the client. So my final solution is (thanks to Paul) to restore the database on the dev.machine and perform the checking on.

6 comments:

Home Theater said...

thanks for the article


Home Theater | Audio Video | LCD HDTV | BluRay | Speakers | Remote Controls

sdfj said...

christian louboutin christian louboutin cheap christian louboutin sale christian louboutin discount christian shoes christian louboutin shoes designer handbags louis vuitton handbags replica handbags ugg classic tall ugg classic short ugg ultra tall boots christian louboutin boots MBT shoes discount MBTshoes ugg classic cardy boots ugg boots Tory Burch Shoes Giuseppe Zanotti Shoes louboutin ugg boot

liu said...

I have read your blog for many times, and I think it very wonderful. I love some of your articles, they are meaningfull. And what do you think of polo shirts, I think they are are very chic, especially the polo t shirts, I love them very much. I also like playing tennis rackets, it can keep healthy, what do you like to do in your spare time?
cheap tennis racket
discount tennis racket
prince tennis racquet
head tennis rackets
wilson tennis racket
babolat tennis racquet
polo t shirts women
polo t shirts on sale
polo t shirts for women
polo shirts on sale
polo shirts men
men's polo shirt
men polo shirt
mens polo shirts
mens polo shirt
cheap polo shirts
discount polo shirts
men's polo shirts
women's polo shirts

Youdao world said...

“Whoever a woman is,Christian Louboutin
she will be sexy after she wears a pair of beautiful pumps.”Christian Louboutin Pumps LiToYo says.herve legerNowadays, the pumps are the women’s favorite like the old time too.Christian Louboutin Sandals And the height of pumps has made breakthrough for many times. Christian Louboutin BootsTwenty years ago, christian louboutin blackthe fashionable giant Christian Louboutin, gave a standard to the fashionable pumps.christian louboutin discount
He designs pumps which have 10cm high red sole.Christian Louboutin shoes And at the same time, the red-sole sky-high pumps became the striking mark of Louboutin, and the striking mark of fashion.
christian louboutin heels
Let’s imagine about that a woman wears a pair of red-sole sky-high pumps walking on the street with rhythmic strides;
christian heels
how wonderful sight it will be!Christian Louboutin specials If the woman chooses a mini skirt to go with her red-sole pumps,Christian Louboutin black with the gentle summer breeze and long hair and beautiful skirt fluttering slightly,Christian Louboutin red will you think the woman is charming? And the famous designer Christian Louboutin has said that, Christian Louboutin blue“Exactly the red-sole high heels made women have a healthy body, because these high heels make women slow down their steps.Hermes Birkin The difference is like that driving a car is different from ride a bike;Christian Louboutin glitter you can enjoy the scene along the way at least if you ride a bike.”
Maybe the pumps are so high that you will doubt about whether you can walk wearing them. Christian Louboutin pinkIt’s sure that you have not worn Christian Louboutin shoes so far. Louboutin pumps are designed to match body’s structure,Moncler Jackets especially the structure of women’s foeet;HChristian Louboutin Blog and you can have a run with Christian Louboutin pumps. That’s the other one important reason that Christian Louboutin shoes are so appreciated by women.

aiya said...

Office 2010is powerful!
Microsoft Office 2010is the best software in the world.
Microsoft wordis so great!
Office 2007makes life great!
Many people likeMicrosoft Office.
Microsoft Office 2007is welcomed by the whole world.
Office 2007 keyis available here.
Office 2007 downloadis on sale now!
Office 2007 Professionalbring me so much convenience.
Outlook 2010 make life wonderful!
Microsoft outlook is my love.
Microsoft outlook 2010 is convenient!
Windows 7 is convenient!

luck said...

uggs clearance (2) car sales. 3. "Consumer Reports" ratings. Although some models have a very long history, has many loyal fans, such as the Volkswagen Jetta (picture quotation parameters Forum), but the facelift to the present, many models it is almost just a change of face, and not with the quality of the vehicle development and improve the car, Uggs Outlet but look old and outdated. Here let us look at the foreigners in this assessment: "A nine worst U.S. Forbes assessment models.classic short ugg boots"Note: The following models are the U.S. version, with domestic sales model specifications may vary. U.S. data from MSN, Forbes and Consumer Reports ugg boots clearance.