Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database Server Monitoring
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

498 Posts

Posted - 02/01/2013 :  15:26:23  Show Profile  Reply with Quote

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


Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 02/02/2013 :  02:42:53  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

Aged Yak Warrior

596 Posts

Posted - 02/02/2013 :  09:31:33  Show Profile  Reply with Quote
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

Posting Yak Master

160 Posts

Posted - 02/04/2013 :  05:53:00  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000