Google Feed code leaking SQL connections

[AbleMods]

The problem I was having was that more and more connections were being opened and never getting used or closed.

Understood. Just thought I'd share with you in case you see your site running high on connections. So far I'm seeing 60-80 open connections on production sites we've looked at thus far.

[jguengerich]

Joe,

OK, thanks. Now you've got me curious if that is what other production sites are seeing . Of course, it depends on how busy the site is, server setup, etc., so I guess it is probably more important that the number remain in the same range for a given site rather than how it compares to other sites.

As I mentioned before, my site will be low-usage for quite a while, so I probably won't see that many connections.

[AbleMods]

You started it with your fancy sp_who2 query

[jguengerich]

It is debugging situations like this that remind me what an amazing resource the Internet is. A few searches and a few minutes of reading turned up the error message and cause, that stored procedure and how to use it, and how to filter the results returned by a stored procedure using a table variable.