Easy way to find connection leaks?

I, just like others, am experiencing problems with data leaks. I was wondering if anyone knows of a tool out there that can help pinpoint the pages with problems? I basically want to find the culprits!

Thanks,
--
YonahBack in the old days I usedNumega's BoundsChecker but it's for C++.

In principal with managed code (i.e., C# and VB.Net) you shouldn't have problems with memory leaks, though I'm sure there are ways to generate them.

There may be some tricks you can use to recover memory faster. The articles below may help:

Garbage Collector Basics and Performance Hints

Garbage Collection: Automatic Memory Management in the Microsoft .NET Framework|||::In principal with managed code (i.e., C# and VB.Net) you shouldn't have problems with
::memory leaks.

Interesting statement given that the question is for CONNECTION LEAKS, not memory leaks. The articles are of similar relevance :-(

I, just like others, am experiencing problems with data leaks.

No, not really.

What you can do is get a profiler (there are some good free ones around) that helps you to figur out what objects are in memory and why. If you experience a "forgot to close the connection" issue, though - you are stuck here.

What I do in general (in our O/R mapper) is handle all database connection open/close from one class - so I actually never have this issue, simply because my code is very sure things are easy here. Consider going this appraoch, concentrating this in one location.

Besides this:

You an set for SQL Server an application "name" that shows up in SQL Server's enterprise manager when you look at open connections. You COULD set this name differently for every page (like the page name), then you would know WHERE you forget to close the connection.

Dynamic Text in Group Headers

I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
a group header when the group spans multiple pages. When I used to use
Crystal Reports 8.5 this was very simple to do uising the
"InRepeatedGroupHeader" built in function. I have not been able to find
anything like this in SSRS. I've seen several people asking for the same
thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?tachtenberg wrote:
> I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
> a group header when the group spans multiple pages. When I used to use
> Crystal Reports 8.5 this was very simple to do uising the
> "InRepeatedGroupHeader" built in function. I have not been able to find
> anything like this in SSRS. I've seen several people asking for the same
> thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
Try Something like this:
=IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
,Globals!ReportName)
-MM|||That will not work because some groups span more than one page and others do
not. Page numbering does not reset with each group.
"Michael" wrote:
> tachtenberg wrote:
> > I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
> > a group header when the group spans multiple pages. When I used to use
> > Crystal Reports 8.5 this was very simple to do uising the
> > "InRepeatedGroupHeader" built in function. I have not been able to find
> > anything like this in SSRS. I've seen several people asking for the same
> > thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
> Try Something like this:
> =IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
> ,Globals!ReportName)
>
> -MM
>|||My bad. I didn't read the question slow enough. I thought it seemed a
little too easy.
Anyway, I did find this that might be what you need.
http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx
tachtenberg wrote:
> That will not work because some groups span more than one page and others do
> not. Page numbering does not reset with each group.
> "Michael" wrote:
>> tachtenberg wrote:
>> I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
>> a group header when the group spans multiple pages. When I used to use
>> Crystal Reports 8.5 this was very simple to do uising the
>> "InRepeatedGroupHeader" built in function. I have not been able to find
>> anything like this in SSRS. I've seen several people asking for the same
>> thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
>> Try Something like this:
>> =IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
>> ,Globals!ReportName)
>>
>> -MM|||On Jan 18, 2:25=A0pm, Michael <Mich...@.discussions.microsoft.com> wrote:
> My bad. I didn't read the question slow enough. I thought it seemed a
> little too easy.
> Anyway, I did find this that might be what you need.http://blogs.msdn.com/=
chrishays/archive/2006/09/27/ContinuedHeader.aspx
>
> tachtenberg wrote:
> > That will not work because some groups span more than one page and other=s do
> > not. =A0Page numbering does not reset with each group.
> > "Michael" wrote:
> >> tachtenberg wrote:
> >> I'm woirking in SSRS 2005. =A0I'm looking for a way to add "(Continued=...)" to
> >> a group header when the group spans multiple pages. =A0When I used to =use
> >> Crystal Reports 8.5 this was very simple to do uising the
> >> "InRepeatedGroupHeader" built in function. =A0I have not been able to =find
> >> anything like this in SSRS. =A0I've seen several people asking for the= same
> >> thing on MSDN but no solutions. =A0Any ideas on how this can be done i=n SSRS?
> >> Try Something like this:
> >> =3DIIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
> >> ,Globals!ReportName)
> >> -MM- Hide quoted text -
> - Show quoted text -
Also, here's white paper that shows (among other things) how to reset
page numbers when groups change.
http://msdn2.microsoft.com/en-us/library/bb395166.aspx|||I've looked at Chris's work around. Unfortunately, there are other items
above the table I need the repeated group headers in so it will not work.
"Michael" wrote:
> My bad. I didn't read the question slow enough. I thought it seemed a
> little too easy.
> Anyway, I did find this that might be what you need.
> http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx
>