Hello guys,
Just wondering if i can use CPU, Memory usage, I/O or wait events for SQL trace. I am having difficulty in finding theses events on SQL trace.
Also is it possible to show the SQL trace file output in graphical format.
Thanks
Printable View
Hello guys,
Just wondering if i can use CPU, Memory usage, I/O or wait events for SQL trace. I am having difficulty in finding theses events on SQL trace.
Also is it possible to show the SQL trace file output in graphical format.
Thanks
I am actually running a trace on SQL server 2005 box. Any feedback would be appreciated.
Rmiao is there a way i can change the title of the thread from Enterprise Manager to SQL Profiler.
Why don't monitor those in perfmon?
Thanks for the quick reply. Actually I am capturing the following events in SQL Profiler.
RPC:Completed, SQL:BatchCompleted, SQL:BatchStarting, SQL:StmtStarting, SQL:StmtCompleted, Prepare SQL, Exec Prepared SQL, Unprepare SQL
User wants me to capture CPU, Memory usage, I/O and block events along with the above events.
And then he wants me to show the captured events in graphs.
You can check data column cpu, reads and writes for the event but not memory usage. And there is no direct way to show blocking in profiler, you can trace locks events.
thanks rmiao