Is there a built in tool to check the database health on SQL 2000?

 Looking for one collective tool to give all the below information.

1. Database server setting for optimization.

2. Checking fragmentation

3. Index

4. Deadlocks

5. Bad Queries affecting performance

6. Space issues

7. Huge difference between data and log file

8. Empty space in data and log files

9. Failing jobs........

Thank you in advance for your time!

Welcome to the forums! 

Is there a built in tool to check the database health on SQL 2000?

AFAIK, no there is no built-in tool available; but you can have SQLCheck from Idera for free http://www.idera.com/Products/SQLcheck/Default.aspx; although it will not give you all the information but its nice to have tool for free.

some of the below can be schedule to run periodically and some needs to monitor pro-actively using native tool/t-sql as routine

1. Database server setting for optimization.  = sp_configure

2. Checking fragmentation == dbcc showcontig

3. Index = dbcc showcontig having table,ind as comment; dbcc reindex,dbcc indexdefreg

4. Deadlocks = sp_who2, sp_lock,

5. Bad Queries affecting performance = sp_who2, profiler and execution plan can help

6. Space issues = sp_helpdb, setting alerts and some scripts available in this site can help you

7. Huge difference between data and log file = please elaborate 

8. Empty space in data and log files = please elaborate

9. Failing jobs........ = error log/ job history or job's log file

hth