SQL Profiler

[vanram]

Is it possible for SQL Profiler to be enabled for your DBA customers? I tried it today it said it was not allowed.

[bruce]

This is not allowed for performance reason.

[b]quote:Originally posted by vanram

Is it possible for SQL Profiler to be enabled for your DBA customers? I tried it today it said it was not allowed.
</blockquote id="quote"></font id="quote">

[vanram]

Interesting, I expected you to say - for Security reasons. What performance issues have you identified with SQL Profiler? Has this issue been experienced by others?

[vanram]

I would apreciate the detail behind DASP's decision not to support SQL Profiler. This is one of the tools I have noticed that some others are supporting...(I can get an example if required...) This tool is worth the effort!

[bruce]

Please provide some companies that are doing that.

[b]quote:Originally posted by vanram

I would apreciate the detail behind DASP's decision not to support SQL Profiler. This is one of the tools I have noticed that some others are supporting...(I can get an example if required...) This tool is worth the effort!
</blockquote id="quote"></font id="quote">

[bruce]

To be honest, i really don't understand exactly why. I just got the anwser from our internal KB. i can check w/ the DBA for more detail.

The bottom line is Profiler is not supported.


[b]quote:Originally posted by vanram

Interesting, I expected you to say - for Security reasons. What performance issues have you identified with SQL Profiler? Has this issue been experienced by others?
</blockquote id="quote"></font id="quote">

[bruce]

I've confirmed w/ our DBA.

Profiler is not supported because it requires SA permission to run. You were right, it's a security issue.

[b]quote:Originally posted by bruce

Please provide some companies that are doing that.

[b]quote:Originally posted by vanram

I would apreciate the detail behind DASP's decision not to support SQL Profiler. This is one of the tools I have noticed that some others are supporting...(I can get an example if required...) This tool is worth the effort!
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

[vanram]

Thanks for the update. The other hosting company I observed had SQL Profiler is 'MaximumASP'; Or to be more correct thay expose much of the same functionality...