December 14, 2004 at 11:02 am
Our MOM application failed to notify us that a server's disk space filled up, and I have been asked to add or enhance what is already in place. First, I do not have a login for the application yet, and second I am not familiar with it anyway. I've been looking at the tables and views and was thinking that I could put a couple of SQL notifications in place temporarily while researching the issue.
What table or view would have triggered a MOM alert that a server's disk space filled up? I am told that an alert should have gone out at a 90% threshhold, but can't seem to find this info. I'm also trying to get some documentation but haven't seen any yet, so any help would be greatly appreciated.
Linda
December 15, 2004 at 12:25 pm
Take a look at this article on monitoring drive and database free space, http://www.sqlservercentral.com/columnists/mnash/monitoringdriveanddatabasefreespace.asp. It may provide some help.
Kemp
December 15, 2004 at 12:42 pm
Great article. Thanks. I have something simple in place to monitor the SQL Servers disk space, but this is much better.
I am still looking for some advise on the MOM database tables. I can see where one of the servers ran out of disk space (non-SQL Server), but I can't find where a threshhold was set. Been looking at the application and haven't found it there yet either. Here's what I have so far:
SELECT [Time] = A.TimeRaised, A.[Name], A.[Description], AL.[Name], C.[Name]
FROM Alert A WITH(NOLOCK) INNER JOIN ProcessRule PR ON A.idProcessRule = PR.idProcessRule
INNER JOIN Computer C ON C.idComputer = A.idComputer
INNER JOIN AlertLevel AL ON AL.[Level] = A.ALertLevel
WHERE PR.IsRuleGroup = 0 AND C.[Name] = 'ServerName'
--AND A.TimeRaised BETWEEN '12/1/04' AND '12/15/04'
GROUP BY A.TimeRaised, A.[Name], A.[Description], AL.[Name], C.[Name]
Anyone have suggestions?
Thanks,
Linda
December 17, 2004 at 8:31 am
If you are looking for where the threshhold was set for free space, Look in the following rule group in the MOM admin console. MS Windows Servers Base Operating System\Windows 2000\State Monitoring and Service Discovery Event rule Run Storage State Monitory. Click on the response tab Edit the script. You will see all the thresholds. Remember you Agent Management computers need to be in the MS windows 2000 server group to be monitored. If you use 2003 servers use the Windows 2003 Rules.
This might help you
December 17, 2004 at 8:51 am
Great! This is exactly what I was looking for. Thank you.
Linda
January 19, 2005 at 2:35 pm
We use SQL Stripes from Purenetworking.net. I think there is a review of it on this site somewere
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply