Red Gate forums :: View topic - Find unclosed connection
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
ANTS Memory Profiler 7
ANTS Memory Profiler 7 forum

Find unclosed connection

Search in ANTS Memory Profiler 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Corobori



Joined: 27 Aug 2013
Posts: 1

PostPosted: Tue Aug 27, 2013 8:51 pm    Post subject: Find unclosed connection Reply with quote

Is it possible to find unclosed connection to SQL Server with this product ?
_________________
Jean-Luc
www.corobori.com
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Thu Aug 29, 2013 7:49 am    Post subject: Reply with quote

Hi,
In answer to your question- possibly.
The actual connections to SQL Server will generally be handled by the .NET framework, and these get recycled and re-used so it's not as simple as just looking for the number of connections to the database.

You could certainly filter the results and look for sqlconnection objects and see if the count of these is going up. If you're creating a connection when a child-screen is opened up and something is not disposing of it when you close the screen, these may increase as objects in memory. You may also find memory goes up due to resultsets from those queries also hanging around.

I'd suggest checking over the QueryBee example: http://www.red-gate.com/products/dotnet-development/ants-memory-profiler/walkthrough

And also strategies for using the profiler: http://documentation.red-gate.com/display/AMP74/Strategies+for+memory+profiling
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group