[mrtg] Re: Monitoring W2K and SQL server service

[John Pavlakis]

Hi Stephen,

Get mssql.mib and use the microsoft sql server OID of,
.1.3.6.1.4.1.311.1.4.1.1.1.1.4
"The state of SQL Server. Unknown(1) means we are
 unable to determine the state of the server, Running(2)
 means the server is available and can be used, Paused(3)
 means the server is running, but new connections cannot
 currently be established, and Stopped(4) means the server
 is not running and unavailable."

Cheers

-----Original Message-----
From: Stephen [mailto:hyss119 at yahoo.com.sg]
Sent: Monday, November 11, 2002 2:54 PM
To: mrtg at list.ee.ethz.ch
Subject: [mrtg] Monitoring W2K and SQL server service



Hi,

I manage to monitor SQL server service Memory Usage on W2K with oid below.
1.3.6.1.2.1.25.5.1.1.2.852

852 is refering to SQL service processID(PID) at that point of time. If I
reboot system/restart service, PID will change.
does anyone encounter this problem. Please enlighten if you have any
solution. Thanks.

Does anyone monitor w2k system memory utilization? please help.

Stephen

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

__________________________________________________
Do You Yahoo!?
Great flight deals, travel info and prizes!
http://sg.travel.yahoo.com

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi


-- Attached file removed by Ecartis and put at URL below --
-- Type: text/plain
-- Size: 439 bytes
-- URL : http://www.ee.ethz.ch/~slist/pantomime/49-InterScan_Disclaimer


--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi