SQL Server monitoring

  • Thread starter Thread starter Ian Frawley
  • Start date Start date
I

Ian Frawley

Anyone used WMI to get stats back on MS SQL Server?
Any good articles anywhere?

--
Ian (Freebasing On Boredom.......)

BEING IN THERAPY
And yet, having therapy is very much like making love to a beautiful
woman. You... get on the couch, string 'em along with some half-lies and
evasions, probe some deep dark holes, and then hand over all your
money.
 
Ian,

If you know the name of the management classes, then it should be easy
enough. You can use the classes in System.Management to perform a WMI
query.

Hope this helps.
 
Nicholas,

Yeah I have been doing some Services and Process monitoring but now I have
to turn my hand to SQL Server monitoring. I have seem an article or two on
MOM but its prooving to be a bit of a big old topic.

Ian

Nicholas Paldino said:
Ian,

If you know the name of the management classes, then it should be easy
enough. You can use the classes in System.Management to perform a WMI
query.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Ian Frawley said:
Anyone used WMI to get stats back on MS SQL Server?
Any good articles anywhere?

--
Ian (Freebasing On Boredom.......)

BEING IN THERAPY
And yet, having therapy is very much like making love to a beautiful
woman. You... get on the couch, string 'em along with some half-lies and
evasions, probe some deep dark holes, and then hand over all your
money.
Click to expand...
Click to expand...
 
Yep sussed it. By accessing the Raw performance counters I can get just
about everything I need. Thanks for your help!

Ian

Ian Frawley said:
Nicholas,

Yeah I have been doing some Services and Process monitoring but now I have
to turn my hand to SQL Server monitoring. I have seem an article or two on
MOM but its prooving to be a bit of a big old topic.

Ian

message news:uibSM%[email protected]...
Ian,

If you know the name of the management classes, then it should be easy
enough. You can use the classes in System.Management to perform a WMI
query.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Ian Frawley said:
Anyone used WMI to get stats back on MS SQL Server?
Any good articles anywhere?

--
Ian (Freebasing On Boredom.......)

BEING IN THERAPY
And yet, having therapy is very much like making love to a beautiful
woman. You... get on the couch, string 'em along with some half-lies and
evasions, probe some deep dark holes, and then hand over all your
money.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top