Red Gate forums :: View topic - SQL, File I/O not working via command line profiling
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

SQL, File I/O not working via command line profiling

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



Joined: 08 Aug 2009
Posts: 40
Location: Cape Town, South Africa

PostPosted: Tue Jul 13, 2010 12:39 pm    Post subject: SQL, File I/O not working via command line profiling Reply with quote

Hi

I have created a ANTS project that allows me to profile a VDir in IIS using the default port 80. I also set the SQL, File I/O options to monitor the disk and SQL Server. When I profile via the UI, it gathers all information inclusing the SQL and File I/O correctly.

I now want to automate the process via the command line as well using soapUI to create load on the web site. I send through the following command line arguments that include the same project used via the ANTS UI:

Code:

  "C:\Program Files\Red Gate\ANTS Performance Profiler 6\Profile.exe" /project:"D:\PragmaDev\OK52\pOnKey\Main\Metrics\P
  erformanceTests\Pragma.OnKey5.app6" /verbose /methodLevel /onlyWithSource /force /timeout:60 /data:"D:\PragmaDev\OK52
  \pOnKey\Main\Metrics\PerformanceResults\2010_07_13\StaffMember\13_16\StaffMember.app6results" /htmlreport:"D:\PragmaD
  ev\OK52\pOnKey\Main\Metrics\PerformanceResults\2010_07_13\StaffMember\13_16\StaffMember.Summary.html"



However when I open the results generated in the ANTS UI, it does not include the SQL and File I/O activity Sad Is this to be expected?
Back to top
View user's profile Send private message
slaphead99



Joined: 10 Mar 2010
Posts: 93

PostPosted: Tue Jul 13, 2010 6:32 pm    Post subject: Reply with quote

Yes, sorry. This has not yet been implemented. It is something we are looking at.
Back to top
View user's profile Send private message
cjlotz



Joined: 08 Aug 2009
Posts: 40
Location: Cape Town, South Africa

PostPosted: Tue Jul 13, 2010 8:02 pm    Post subject: Reply with quote

ETA? Hopefully we don't have to wait till v7 for this to be working seeing that v6 was just released. I mentioned this during this EAP as well so it is sad to see that it didn't make the final product. Are there any other features like this that are not supported by the command line version?
Back to top
View user's profile Send private message
AndrewH



Joined: 17 Aug 2006
Posts: 137

PostPosted: Wed Jul 14, 2010 10:29 am    Post subject: Reply with quote

I've just tried this out, and I think it does work if you use a project file. There's no way to switch this option on without using one at the moment, which is an oversight on our part.

However: this feature only works if the profiler is launched as an administrator. The command-line tool doesn't perform elevation like the UI does, and the resulting error is not being reported.

I think that it's probably correct that the command-line doesn't automatically try to elevate itself, as the UAC prompt is probably the last thing you want to appear when running non-interactively.

This does reveal several changes we do need to make, though:

* We need to add a 'record sql/file events' option so that a project file isn't always necessary to enable this feature.
* We need to display a clear warning when a profiling session requires administrator permissions to work correctly and these aren't available.
* If there are any errors while recording events, these should be displayed as warnings when profiling finishes.

I don't think any of these are major modifications, so I'd be confident scheduling these for v6.1.
_________________
Andrew Hunter
Software Developer
Red Gate Software Ltd.
Back to top
View user's profile Send private message
cjlotz



Joined: 08 Aug 2009
Posts: 40
Location: Cape Town, South Africa

PostPosted: Wed Jul 14, 2010 11:20 am    Post subject: Reply with quote

Andrew

Just to verify that I understand you correctly - you are saying that the command line profiling should generate the SQL/File I/O stats as long as we run it in an elevated command prompt with administrator rights? I'm running without UAC and it is still not generating the stats.

Thanks
Back to top
View user's profile Send private message
AndrewH



Joined: 17 Aug 2006
Posts: 137

PostPosted: Wed Jul 14, 2010 11:39 am    Post subject: Reply with quote

Yes, that should work: if you're using a project file with the option turned on, then the command line should enable the feature the same way the UI does, so if it works in the UI on a given system then it should also work with the command line.

The data has to be viewed via the UI after being saved out with the /data option.

The problem is that there's almost no feedback if a problem occurs as things stand, so there isn't much opportunity to correct problems at the moment. This will be rectified in v6.1.
_________________
Andrew Hunter
Software Developer
Red Gate Software Ltd.
Back to top
View user's profile Send private message
cjlotz



Joined: 08 Aug 2009
Posts: 40
Location: Cape Town, South Africa

PostPosted: Wed Jul 14, 2010 12:12 pm    Post subject: Reply with quote

Thanks Andrew. Rough estimate on v6.1 - 1 month/2 month timeframe? I need to report back to management. Thx
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