PDA

View Full Version : SQL Server Profiling


rickasp
03-11-2010, 01:06 AM
The new SQL Server Profiling service is a great addon I think, but a 2 minute run is not that much especially when you have not much traffic, so it will be a wild guess when to schedule.

Although I understand a longer run on high traffic websites will result in large trace files. Is it not possible to run until the log file will hit a certain filesize?
Also maybe its an idea to integrate this service in the control panel?

I am interested in running such a service but not spend $15 dollar for a run that won't collect any data, or am I overlooking something/missing the point about this service?

bruce
03-11-2010, 02:29 PM
We do allow more than 2 minutes of trace for additional fee.

The main reason why we keep the basic service for 2 minute is because of server load.

Is it not possible to run until the log file will hit a certain filesize?

Interesting suggestion. We'll consider it.

Also maybe its an idea to integrate this service in the control panel?

If we see enough demand for this service, we'll consider putting the UI in the CP.

rickasp
03-11-2010, 11:15 PM
Interesting suggestion. We'll consider it.

If we see enough demand for this service, we'll consider putting the UI in the CP.Great, good luck and let us know :)