I am looking for daily database server monitoring scripts. I want to run script from one server and generate Excel sheet that contains data for all other database servers:
Do you want to run them as secripts from another SQL Server or as scripts outside of SQL Server? I would also recommend you have monitoring set up and reports. The regular monitoring , such as every 5 minutes - with various situations such as : 1)Is the service down? Is the database offline? Has the drive filled?
And the reporting you could run once a day : and would report on things such as : last backup date, is a data and log file on the same drive?
One thing this script may need to do is check the version of the server as it runs. If you have 2000 instances, these may not be able to run the same statements as 2008/2005 can.
Database Server Monitoring
Posted - 02/01/2013 : 15:26:23
