Tuesday, February 14, 2012

DB Health Check Script

Hi,
I am an Oracle DBA looking for a SQL Server Health Check script that will tell me the overall status of a database/server. Does anyone have anything like this? I'll be more than happy to share any scripts I already have for Oracle.
Thanks.Check out the system stored procedures already available, such as sp_Helpdb and sp_spaceused.

blindman|||DBCC checkdb and dbcc checktable help as well. DBCC stands for database consistency checker. Type in DBCC in BOL (Books-online) and it will show you a bunch of commands that may help you.

HTH

No comments:

Post a Comment