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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment