MS SQL Server Tools - Sql Server 2005 How to ?

Author

Sql Server 2005 How to ?

Bragadiru

2006-03-07, 11:24 am

Hi,

I want to check the connections opened to an instance of Sql Server 2005;
who, when, eventually the connection string. I have an application without
sources that connects to a database and I suspect it leaves the connections
unclosed, until maximum pool size is reached. How to enumerate through
opened connections ?

Thanks for any advice

Wei Lu

2006-03-08, 3:23 am

Hi Bragadiru,

Welcome to use MSDN Managed Newsgroup Support.

From you description, my understanding of this issue is: you want to check
the existing connection of the SQL Server 2005 instance. If I misunderstood
your concern, please feel free to point it out.

You may use the SQL Server Profiler to trace the existing connections to
the SQL Server 2005 instance.

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace
for monitoring an instance of the SQL Server Database Engine or Analysis
Services. You can capture and save data about each event to a file or table
to analyze later.

Start SQL Server Profiler from the Start-> All Programs-> Microsoft SQL
Server 2005-> Performance Tools-> SQL Server Profiler.

Chose File in the Menu bar and select New Trace.

Chose the SQL Instance you want to monitor and then check the
ExistingConnection in the Events Selection Tab at the Trace Properties
dialog box.

Now you can trace the existing connections.

Also, you may try to query the DMV and system views to get the information.

sys.dm_exec_connections
sys.sysprocesses

Hope this will be helpful.

Sincerely yours,

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
====================
====================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Bragadiru

2006-03-13, 9:24 am

Thanks a lot Wei Lu !

"Wei Lu" <t-weilu@online.microsoft.com> wrote in message
news:D2nfS4mQGHA.5116@TK2MSFTNGXA03.phx.gbl...
> Hi Bragadiru,
>
> Welcome to use MSDN Managed Newsgroup Support.
>
> From you description, my understanding of this issue is: you want to check
> the existing connection of the SQL Server 2005 instance. If I
> misunderstood
> your concern, please feel free to point it out.
>
> You may use the SQL Server Profiler to trace the existing connections to
> the SQL Server 2005 instance.
>
> Microsoft SQL Server Profiler is a graphical user interface to SQL Trace
> for monitoring an instance of the SQL Server Database Engine or Analysis
> Services. You can capture and save data about each event to a file or
> table
> to analyze later.
>
> Start SQL Server Profiler from the Start-> All Programs-> Microsoft SQL
> Server 2005-> Performance Tools-> SQL Server Profiler.
>
> Chose File in the Menu bar and select New Trace.
>
> Chose the SQL Instance you want to monitor and then check the
> ExistingConnection in the Events Selection Tab at the Trace Properties
> dialog box.
>
> Now you can trace the existing connections.
>
>
> Also, you may try to query the DMV and system views to get the
> information.
>
> sys.dm_exec_connections
> sys.sysprocesses
>
> Hope this will be helpful.
>
> Sincerely yours,
>
> Wei Lu
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> ====================
====================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ====================
====================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Wei Lu

2006-03-13, 8:24 pm

Hi Bragadiru,

Thanks for the update.

Glad to hear the information is helpful!

If you have any further questions or concerns, please feel free to let us
know.

Have a nice day.

Regards,

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
====================
====================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Sponsored Links