SQLDMO and server.Disconect

From: Eladio J (namrek1_at_hotmail.com)
Date: 01/30/05 

Date: Mon, 31 Jan 2005 00:07:21 +0100

Hi,

I'm using SQL-DMO to view some properties from a SQL Server instance; I have
a doubt about the results I see in profiler and I hope that any of you can
help me with my question;

When I connect to the instance I use the method Connect and when I finish I
use the method Disconnect from the SQLDMO.SQLServer2 object. I see in
profiler the Audit Login and Audit Logout events and I don't see that the
process stays in sysprocesses, but every time I Connect/Disconnect, the
Application Name in Profiler is changed ( SQLDMO_1, SQLDMO_2, SQLDMO_3, ...)

Do you know any part of EM that uses DMO to see if the same behaviour is
reproduced?
Do you know if I can set the Application Name in the same way that we can do
now with the method ApplicationName in the ADO.NET object Connection?

I was worried about the different Application names in profiler because it
looked like the connection remains open, but seeing sysprocesses the
connection is dropped.

I know that DMO do not use connection pooling, can it be a SQLDMO "mecanism"
to avoid the connections reuse?

Thank you,
Eladio J

Relevant Pages

  • Re: SqlCommand Open VERY slow on application load
    ... other comparably fast machines that did not experience this delay at all - ... Profiler: The profiler is empty for the entire 45 seconds, ... The delay was the same when we did not explicitly open the connection The ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SqlCommand Open VERY slow on application load
    ... Does anyone from MS actually monitor this ... > Profiler: The profiler is empty for the entire 45 seconds, ... > The delay was the same when we did not explicitly open the connection The ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How do you uniquely identify a connection in a connection pool
    ... Have you taken a look at the CLR Profiler? ... > will create as many as 25 new connections in the connection pool. ... the DAOs are in an assembly that is called by ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Windows CE Platform Manager Configuration - real device Qtek 9000
    ... profiler, at this point, which will handle managed and unmanaged code. ... I need to profile performance of my application with Entrek profiler ... connection I'm using Windows CE Platform Manager Configuration. ...
    (microsoft.public.windowsce.app.development)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... What comes to my mind is that there is a Default SQL Server instance is installed on that working system and your application connects to that instance. ... This connection string should work as you do not force the connection to use a specific protocol, Shared Memory will be used as this is the primary protocol by default. ... Default Instances uses 1433 TCP port by default as a Static Port but not the ...
    (microsoft.public.sqlserver.setup)