Monitoring Alert Scripts - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Monitoring Alert Scripts

Author

Topic

poratips
Posting Yak Master

105 Posts

Posted - 2010-06-02 : 22:52:36

We are using Sql server 2005 and i would like to know some monitoring script so i can do some administration and maintenance like if disk get full and its alert us.

Really appreciate your guidelines.

thanks,

poratips
Posting Yak Master

105 Posts

Posted - 2010-06-07 : 17:26:59

Hi,
If someone can guide me as i am currently looking to get the DB volume alert if any files or drive is close to fill up its threshold limit?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-07 : 17:36:35

We use Microsoft's MOM/SCOM tool to monitor your database(s). It isn't free.

For disk space alerting, you could query xp_fixeddrives and alert based upon the results. You can google for alternative solutions also.

If you are using mount points, you can use this: http://weblogs.sqlteam.com/tarad/archive/2007/12/18/60435.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

poratips
Posting Yak Master

105 Posts

Posted - 2010-06-18 : 07:36:58

Thanks, I tried xp_fixeddrives but i was looking something geneirc which based on threshold.

Kristen
Test

22859 Posts

Posted - 2010-06-18 : 10:00:37

We user ServersAlive to monitor some aspects of our servers, dunno if it covers all the things that you want though.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources