question

leadsbyfone avatar image
leadsbyfone asked

SQL SERVER POOLS ARE BEING USED UP AND CAUSING TIME OUTS

our pools are getting maxed out by one of our programs/routines...and we cannot identify which program is running that is causing this...does anyone offer phone consulting or know of a program that we can run that can identify which program or function is causing this.
sql-server-2005
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
The quickest way would be to identify the source/login. You can use this [SP][1] to see where the connections are been used. If you want deeper details of the connections then Adam Mechanics [script][2] is a perfect way to do so [1]: http://sqlserverplanet.com/dmv-queries/a-better-sp_who2-using-dmvs-sp_who3/ [2]: http://sqlblog.com/files/folders/35240/download.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image Tim commented ·
+1 for Who is Active. Adam Mechanic has saved my bottom a time or two with that one.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.