Red Gate forums :: View topic - Crashing on large datasets with sql & io on
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
ANTS Performance Profiler 6
ANTS Performance Profiler 6 forum

Crashing on large datasets with sql & io on

Search in ANTS Performance Profiler 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
brian.merz



Joined: 12 Jan 2009
Posts: 37

PostPosted: Tue Jul 06, 2010 4:14 pm    Post subject: Crashing on large datasets with sql & io on Reply with quote

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
Back to top
View user's profile Send private message
nick.maidment



Joined: 29 Jan 2010
Posts: 74

PostPosted: Wed Jul 07, 2010 3:05 pm    Post subject: Reply with quote

Does this crash happen every time you try to profile? Please could you send the ANTS logs to support @ red-gate.com?
Back to top
View user's profile Send private message
brian.merz



Joined: 12 Jan 2009
Posts: 37

PostPosted: Wed Jul 07, 2010 3:09 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
nick.maidment



Joined: 29 Jan 2010
Posts: 74

PostPosted: Wed Jul 07, 2010 8:18 pm    Post subject: Reply with quote

They should be found by looking under the help menu, open log folder option. Please include case number F0036372 in the subject line. Thanks!
Back to top
View user's profile Send private message
brian.merz



Joined: 12 Jan 2009
Posts: 37

PostPosted: Wed Jul 07, 2010 9:05 pm    Post subject: Reply with quote

Log files are on their way. Smile
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