x
login about faq Site discussion (meta-askssc)

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.

more ▼

asked Jun 17 '11 at 04:15 PM in Default

leadsbyfone gravatar image

leadsbyfone
31

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

The quickest way would be to identify the source/login.

You can use this SP to see where the connections are been used.

If you want deeper details of the connections then Adam Mechanics script is a perfect way to do so

more ▼

answered Jun 17 '11 at 05:16 PM

sp_lock gravatar image

sp_lock
8.1k 20 26 29

+1 for Who is Active. Adam Mechanic has saved my bottom a time or two with that one.

Jun 18 '11 at 11:17 AM Tim
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1832

asked: Jun 17 '11 at 04:15 PM

Seen: 186 times

Last Updated: Jun 17 '11 at 04:15 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.