Re: MDAC and open connections

Yes, you use "General Statistics\UserConnections" to monitor the
connections. And I belive this is provider indenpendent, it shows numbers of
physical db connections no matter from what kind of provider. I am not sure
what do you mean by logging SQLOLEDB provider. If you want to monitoring the
sql statements issued to database, you can use Profiler to trace it.

"Zombie" <Zombie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:119F7E66-5957-4D22-A6A4-8368BEBF3E53@xxxxxxxxxxxxxxxx
> Famel
> I belive "General Statistics\UserConnections" is one to be monitored . I
am
> correct ?
> And i am using SQLOLEDB as the provider. Can the number of connections be
> monitored if the application uses this SQLOLEDB provider?
> And one more question, like enabling tracing for ODBC do we have any
option
> in WIN2K Pro where we get the complete log for SQLOLEDB?
>
> "Famel Lee" wrote:
>
> > If you are installing MS SQL Server, you will find "Performance
Counters"
> > options and you can use Performance Monitor to track open connections as
you
> > said.
> >
> > "Zombie" <Zombie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:91A045BB-1B2D-4146-84D6-33C3CEFE3B3E@xxxxxxxxxxxxxxxx
> > > HI,
> > >
> > > I am looking for some help in finding a tool to keep track of number
of
> > opne
> > > connection through MDAC .
> > > Can perform.exe configured to meet this requirement ?
> > > Thanx for the help
> >
> >

.

Relevant Pages

  • Re: MDAC and open connections
    ... And i am using SQLOLEDB as the provider. ... > options and you can use Performance Monitor to track open connections as you ...
    (microsoft.public.data.ado)
  • Re: MDAC and open connections
    ... And i am using SQLOLEDB as the provider. ... > options and you can use Performance Monitor to track open connections as you ...
    (microsoft.public.data.ado)
  • Re: Traffic separation on Solaris
    ... Others two nics are connected to two different service providers. ... I want to separate Internet traffic to the Internet on these two nics, ... as ssh) should work through other nic (other provider). ... I have two internet connections at home and use ...
    (comp.unix.solaris)
  • Strange memory leak in windows service (pool nonpaged bytes)
    ... The following error gets logged to the system event log: ... I turned on performance monitor and started keeping an eye on our process ... Our process is basically a "cache" of data, it initiates connections to ... Commands from clients are also passed via this process and on to the various ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Secondary Monitor
    ... JOLT & JW ... I sincerely appreciate all your help with my monitor problem. ... HDMI connections via the same cable ... I can even change the desktop picture but no mouse arrow, ...
    (microsoft.public.windows.mediacenter)