Re: Check database healthiness on a daily basis?
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/29/04
- Next message: Hugo Kornelis: "Re: Small join issue"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Indexed View"
- In reply to: bing: "Check database healthiness on a daily basis?"
- Next in thread: bing: "Re: Check database healthiness on a daily basis?"
- Reply: bing: "Re: Check database healthiness on a daily basis?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Jul 2004 21:34:10 +0530
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
- Next message: Hugo Kornelis: "Re: Small join issue"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Indexed View"
- In reply to: bing: "Check database healthiness on a daily basis?"
- Next in thread: bing: "Re: Check database healthiness on a daily basis?"
- Reply: bing: "Re: Check database healthiness on a daily basis?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
