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

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

Peter99
Constraint Violating Yak Guru

494 Posts

Posted - 02/01/2013 :  15:26:23  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2079 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
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
594 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

srimami
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  
 New 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.11 seconds. Powered By: Snitz Forums 2000