Crashing on large datasets with sql & io on

[brian.merz]

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

[nick.maidment]

Does this crash happen every time you try to profile? Please could you send the ANTS logs to support @ red-gate.com?

[brian.merz]

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.

[nick.maidment]

They should be found by looking under the help menu, open log folder option. Please include case number F0036372 in the subject line. Thanks!

[brian.merz]

Log files are on their way.