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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database Server Monitoring

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/free

2. Jobs status

3. 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
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -