SQL Server Performance Forum – Threads Archive

Monitroing queries

How could I identify slow-executing queries from Profiler? Could somebody please advice? Thanks,

---

Not only that you can also use PERFMON in this case:
http://sqlserver-qa.net/blogs/perft…shoot-slow-running-queries-in-sql-server.aspx
http://sqlserver-qa.net/blogs/perft…-a-process-spid-using-tools-tsql-queries.aspx
http://sqlserver-qa.net/blogs/perft…mon-counters-using-a-tsql-query-aka-dmvs.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Thanks for the links. But i want to use Profiler and none of the links talks about this? Am i missing something?

---

I don’t think u read them completely anyway:
http://www.sql-server-performance.com/sql_server_performance_audit10.asp & KBAhttp://support.microsoft.com/kb/243589 fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Thank you so much Satya. The provided web links were very helpful in setting up profiler and tracing info based on my requirement. Thanks again,

---

I was sucesful enough to trace all the long-running queries through profiler and now, i want to view these collected data in form of graph? Is this possible? Appreciated if someone shed some light on this. Thanks,

---

]]>