Red Gate forums :: View topic - ANTS Extremely slow in analyzing the results
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

ANTS Extremely slow in analyzing the results

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



Joined: 29 Jan 2012
Posts: 4

PostPosted: Sun Jan 29, 2012 9:50 am    Post subject: ANTS Extremely slow in analyzing the results Reply with quote

We are evaluating the 6.3 on a very powerful machine with 128gb ram [Win/SQL 2008 R2 Enterprise 64bit]. The storage is a solid state raid and still ANTS is very slow to work with. GUI freezes all the time.

The profiled app just connects to an SQL server, retrieves 100.000 rows and iterates them. Not something I'd expect to be a profiler killer. Other profilers worked fine.

After each profiling session I have to wait 5 mins to be able to work with the gui "Retrieving the Results". Then if we eg. change the period, recalculation takes another year. It only consumes 1 core full (only 4% of the machine's power) during that period.

We moved the temp to ssd with setting RDTEMP system variable. Still no changes.

Is there anything we can do?
Back to top
View user's profile Send private message
DSKY



Joined: 29 Jan 2012
Posts: 4

PostPosted: Sun Jan 29, 2012 11:49 am    Post subject: Reply with quote

We wanted to performance profile our application, we ended up performance profiling the performance profiler.

Life is like a box of chocolate.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Mon Jan 30, 2012 1:16 pm    Post subject: Reply with quote

Hi,

I'm sorry to see ANTS Performance Profiler has given you this trouble. Unfortunately from the supplied information I can't tell you why it's doing this and the vast majority of customers do not have this experience.

However, I'd say the difference between most other profilers and ANTS is the SQL and I/O profiling - do you see similar results if you turn those off? (Do not record SQL and I/O performance)

You may also be unintentionally profiling other processes (Profile child processes setting).
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