Crashing on large datasets with sql & io on

Code profiling for .NET Developers

Moderators: Luke Jefferson, StephenC, Alex.Davies, AndrewH, melvyn.harbour, Laura Morley

Crashing on large datasets with sql & io on

Postby brian.merz » Tue Jul 06, 2010 4:14 pm

Hello,

I decided to try out the latest and greatest with my most memory and processor hungry program, the client data access layer. I have one query which returns 5 columns and roughly 500,000 rows. This is a known performance and memory problem without a viable filtering solution at the moment.

After running this query (sql & io on) and viewing different ranges of time (usually less than 5) I am consistently running into crashing. After the last crash I took a look at task manager and profiler is using up 285,980k of ram. Not a huge issue for me since I have 8GB in my box to play with but it might be useful on your end.

I have included the details from the crash dialog below:
Description:
Stopped working

Problem signature:
Problem Event Name: APPCRASH
Application Name: RedGate.Profiler.UI.exe
Application Version: 6.0.0.1312
Application Timestamp: 4c1f8ee9
Fault Module Name: KERNELBASE.dll
Fault Module Version: 6.1.7600.16385
Fault Module Timestamp: 4a5bdfe0
Exception Code: e053534f
Exception Offset: 000000000000aa7d
OS Version: 6.1.7600.2.0.0.256.1
Locale ID: 1033

This does not seem to happen with sql & io off.

This new feature does show great potential. Already pointed out one unexpected call which should save a second or so in form load time.

Thanks for another great release,
--Brian
brian.merz
 
Posts: 37
Joined: Mon Jan 12, 2009 9:40 pm

Postby nick.maidment » Wed Jul 07, 2010 3:05 pm

Does this crash happen every time you try to profile? Please could you send the ANTS logs to support @ red-gate.com?
nick.maidment
 
Posts: 74
Joined: Fri Jan 29, 2010 1:55 pm

Postby brian.merz » Wed Jul 07, 2010 3:09 pm

This does happen every time if sql & io is turned on and I am running large data sets through it.

Where do I find the logs? I will be glad to send them over.
brian.merz
 
Posts: 37
Joined: Mon Jan 12, 2009 9:40 pm

Postby nick.maidment » Wed Jul 07, 2010 8:18 pm

They should be found by looking under the help menu, open log folder option. Please include case number F0036372 in the subject line. Thanks!
nick.maidment
 
Posts: 74
Joined: Fri Jan 29, 2010 1:55 pm

Postby brian.merz » Wed Jul 07, 2010 9:05 pm

Log files are on their way. :)
brian.merz
 
Posts: 37
Joined: Mon Jan 12, 2009 9:40 pm


Return to ANTS Performance Profiler 6

Who is online

Users browsing this forum: No registered users and 0 guests