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. 3 1941
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]
- mv*@spam.guard.caspershouse.com
"Ian Frawley" <ch****@away.com> wrote in message
news:n8***************@news-1.opaltelecom.net... 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.
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 [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:ui****************@TK2MSFTNGP12.phx.gbl... 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] - mv*@spam.guard.caspershouse.com
"Ian Frawley" <ch****@away.com> wrote in message news:n8***************@news-1.opaltelecom.net... 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.
Yep sussed it. By accessing the Raw performance counters I can get just
about everything I need. Thanks for your help!
Ian
"Ian Frawley" <ch****@away.com> wrote in message
news:gl***************@news-1.opaltelecom.net... 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 [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
in message news:ui****************@TK2MSFTNGP12.phx.gbl... 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] - mv*@spam.guard.caspershouse.com
"Ian Frawley" <ch****@away.com> wrote in message news:n8***************@news-1.opaltelecom.net... 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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Tim D |
last post by:
Hi,
I originally posted this as a reply to a rather old thread in
dotnet.framework.general and didn't get any response. I thought it might be
more relevant here; anyone got any ideas? My...
|
by: datapro01 |
last post by:
I am a DB2 DBA that has been asked to become familiar enough with SQL
Server in order to become actively involved in its installation,
implementation, and to review database backup/recovery...
|
by: Jacand4321 |
last post by:
I'm trying to audit all the database activities using Server-side trace
in SQL Server 2000.
Basically I need to get the login information (login Id, Login time
etc) along with the name of the...
|
by: webmaster |
last post by:
Greetings,
We are pleased to announce the that new found blood has given the
Detroit Area SQL Server Special Interest Group/Usergroup a new look and
new talent.
As a result of promotions and...
|
by: Ben |
last post by:
I am building a web app using ASP.NET 2.0. One of the requirements is that we
link to a third party vendor's site, display their content. let the user make
choices on the vendors site and then...
| |
by: DataPro |
last post by:
Our shop is expanding use of SQL Server, both 2000 and 2005. We have
Litespeed on some boxes to handle the backup/recovery jobs. Can I ask
what are considered the best tools for monitoring SQL...
|
by: aleu |
last post by:
Hi,
I was wondering whether any of you is monitoring MSSQL server 2005
(whatever information could be obtained) from a remote Linux server with
the use of SNMP or WMI-perl scripts (for example...
|
by: sherifbk |
last post by:
Problem description
==============
- I have 4 clients and 1 server (SQL server)
- 3 clients are Monitoring console 1 client is operation console
- Monitoring console collects some data from...
|
by: peter |
last post by:
Hi,
Here is an urgent requirement with one of our direct customer for
Sr.Windows Server Administrator.Client is an Financial Services
company looking for Senior Consultants for this position....
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |