Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2013-02-01 : 15:26:23
|
| Hi,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:1. Disk space used/free2. Jobs status3. Sql Services Thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-02 : 02:42:53
|
| 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?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2013-02-02 : 09:31:33
|
| 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. |
|
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-04 : 05:53:00
|
| You can use sqlcmd and run the system sp's to find the status of all monitors like xp_fixedrives to find the status of disk space. |
|
|
|
|
|
|
Database Server Monitoring