Re: Check database healthiness on a daily basis?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: TJTODD (tjtodd_at_anonymous.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 08:17:45 -0400

Hi Andrew - just curious... what would the reason be for moving this data to
another DB? Is it to save CPU cycles? Isn't CHECKDB non-disruptive since
it just takes page locks?

Thanks for your help.

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:unMcp8YdEHA.228@TK2MSFTNGP11.phx.gbl...
> Bing,
>
> Something else to keep in mind if you have some large db's or ones that
are
> 24 x 7. You can restore a full backup on another machine and run the
DBCC's
> there. If it is corrupted on the primary it will be corrupted there as
well
> and you don't have to disrupt anyone while doing the check.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "bing" <bing@discussions.microsoft.com> wrote in message
> news:74A64E31-18DF-4BFF-ACC6-284FFC3914CD@microsoft.com...
> > Thanks so much for your instance response, Hari. Not just for this one.
> You have answered a lot of my questions I posted previously. They are all
> very helpful. I really appreciate your knowledgement and your kindness of
> willing to help others.
> > I'll try what you suggested.
> >
> > Bing
> >
> > "Hari Prasad" wrote:
> >
> > > Hi,
> > >
> > > Yes, that will be a better option to check and confirm that your
> database is
> > > good. DBCC CHECKDB will run for a long time if your database is
> > > big. In that case probably you can do this activity weekly once during
> non
> > > peak hours (weekends).
> > >
> > > Along with this you can also run UPDATE STATISTICS daily on those
tables
> > > which have high DML access (Insert/ Update/ Delete).
> > >
> > > Monthly once check the fragmentation of table using DBCC
> > > SHOWCONTIG(Table_name), if fragmented you could DBCC REINDEX the
table.
> > > THis will remove the fragmentation and increase the performance.
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > > "bing" <bing@discussions.microsoft.com> wrote in message
> > > news:DDCE66EE-CFB0-4C9D-B215-AB7983D4021E@microsoft.com...
> > > > How do people usually do to make sure all the databases are in good
> > > status?
> > > >
> > > > We have about 50 databases. I was intended to write 'dbcc checkdb'
> for
> > > each one in a T-SQL script and have it run every day. Is there a
better
> way
> > > to do that?
> > > >
> > > > Thanks in advance for any advices.
> > > >
> > > > Bing
> > >
> > >
> > >
>
>

Relevant Pages

  • Re: Backup fails, where more details?
    ... Maybe I can just try from Query Analyzer the two backup commands that failed. ... Bing ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: how to extract individual log backup?
    ... Thanks, Andrew. ... Can Lumigent Log ... Bing ... > even though it is housed ina device with others. ...
    (microsoft.public.sqlserver.server)
  • Re: Check database healthiness on a daily basis?
    ... Thanks for the advice, Andrew. ... Bing ... > Something else to keep in mind if you have some large db's or ones that are ...
    (microsoft.public.sqlserver.server)
  • Re: Samsung LCD TV and wanting to use Headphones.
    ... Andrew wrote: ... Try moving your technology knowledge forward 20 ... In which case you don't need a headphone socket. ...
    (uk.tech.digital-tv)
  • Re: Joone Preparations
    ... but I have a 2-for-1 room night coupon if you want it. ... It's funny because it's true. ... Andrew <-- Is it FEBROOARY yet? ... If it keeps moving, regulate it. ...
    (alt.vacation.las-vegas)