How can we help you today? How can we help you today?

Crashing on large datasets with sql & io on

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
0

Comments

4 comments

  • nick.maidment
    Does this crash happen every time you try to profile? Please could you send the ANTS logs to support @ red-gate.com?
    nick.maidment
    0
  • 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.
    brian.merz
    0
  • 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!
    nick.maidment
    0
  • brian.merz
    Log files are on their way. :)
    brian.merz
    0

Add comment

Please sign in to leave a comment.