-
SQL Profiler
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
Last edited by Owais; 12-26-2007 at 04:14 PM.
-
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.
Last edited by Owais; 12-26-2007 at 04:18 PM.
-
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.
Last edited by Owais; 12-26-2007 at 04:29 PM.
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|