RE: About SQLClient counters

From: Eric Cárdenas [MSFT] (ecardena_at_online.microsoft.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 02:44:44 GMT

> Hi,
> how can i get the following list of counters
> in runtime when we executing the application with
> database support and is there any command to find the
> no.of connection are made in the database and no.of pooled
> connection, no.of non pooled connection for the database.
>
--------------------
You should look at incorporating Windows Management Instrumentation (WMI)
into your application. This is a place to start:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/
wmi_start_page.asp

Hope this helps, 

--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: reuse connection object with diff username passwor ...
    ... Reopening a pooled connection is far from free. ... And certainly only one database is active on sql server? ...
    (microsoft.public.dotnet.framework.adonet)
  • About SQLClient conters
    ... database support and is there any command to find the ... no.of connection are made in the database and no.of pooled ... connection, no.of non pooled connection for the database. ...
    (microsoft.public.sqlserver.server)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)