January 4, 2006 at 6:02 am
Dear all
Do anyone has any idea on what should be there in the Daily check list for SQL server?? we have a dozen of SQL servers, need to monitor.. So please help us by giving a sample daily check list....
Thanks in advance
Regards
Santhosh
January 5, 2006 at 11:01 am
You could start with (others will add; also you could search forum for that topic)
1. SQL Error Logs
2. Event Logs
3. Failed Jobs
4. Perfmon (Review Log Perfmon output if necessary/if you have).
5. Suspect Databases
6. Server Drive Space
7. Logshipping
8. Blocking
9. Any Jobs/Server-Databases/Backups UPDATES
10. Failed backups
11. If you have any Cluster-make sure it runs on the proper Node
12. Any Object\Login Changes\adds\modifications; Any Changes in Master DB
13. Any Long-Running Queries
14. Any Unwanted Users ( it could run every few minutes)
All of the above you could encompass in Stored Procs (Jobs) and run on a regular basis.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply