October 13, 2011 at 12:01 pm
Recently I did a disaster backup and restore on one of our servers, surprisingly I found it took kind of too long to take one database offline, this leads me thinking if there is any health check we can do to a database, in 2005 or 2008, or the database just needs some new indexing or performing an integrity check is the health check I am looking for?
Thanks.
October 13, 2011 at 12:03 pm
Check out "DBCC CHECKDB" online. That should do what you need.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 13, 2011 at 11:28 pm
My bet - excessive VLFs. See Kimberly Tripp's blog.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2011 at 8:22 am
DBCC CHECKDB didn't find out any error in the database, is there other method that I can check the health of the database? I am sure there is some problem in it.
Thanks.
October 14, 2011 at 8:28 am
This is what Gail has in mind :
http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
This is where I'd go next for an overall health check (not specific to this problem).
http://www.brentozar.com/blitz/
And here's the 2.5 hours video that explains how to take over a server in minutes 😀
October 14, 2011 at 10:26 am
Ninja's_RGR'us (10/14/2011)
This is what Gail has in mind :http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
Thank you. It's hard to keep up with SSC while at SQLPass2011
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2011 at 10:29 am
GilaMonster (10/14/2011)
Ninja's_RGR'us (10/14/2011)
This is what Gail has in mind :http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
Thank you. It's hard to keep up with SSC while at SQLPass2011
I know... trying to pick up the "slack".
Big shoes to fill with any 1 of you gone. But with 5-10 of you :crazy:
😀
October 14, 2011 at 10:30 am
P.S. What tablet are you using that makes it hard(er) to copy / paste?
I'd like to keep that in mind in case I buy one! :w00t:
October 14, 2011 at 10:41 am
Ninja's_RGR'us (10/14/2011)
P.S. What tablet are you using that makes it hard(er) to copy / paste?
Err, my win7 laptop.
It's not copy-paste that's problem, it's that I'm posting in spare minutes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2011 at 10:47 am
GilaMonster (10/14/2011)
Ninja's_RGR'us (10/14/2011)
P.S. What tablet are you using that makes it hard(er) to copy / paste?Err, my win7 laptop.
It's not copy-paste that's problem, it's that I'm posting in spare minutes.
DBCC TimeWarp()
For the 15 posts you said you had troubles finding / pasting the link and were not on your laptop?
October 14, 2011 at 10:25 pm
Ninja's_RGR'us (10/14/2011)
For the 15 posts you said you had troubles finding / pasting the link and were not on your laptop?
iPad. I haven't synced bookmarks and I don't have my snippets collection on there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply