SQL Server Performance Forum – Threads Archive
ProfilerWhen using profiler to monitor, i was wondering, what events are worth monitoring? My users complain that at ever 12:30 PM, SQL Server response time is very bad and even a simple query takes several minutes. I was wondering, what events i need to monitor from profile? Appreciated if someone please advice? Thanks,
SQL-Server-Performance.com All in Love is Fair
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
http://sqlserver-qa.net/blogs/perftune/archive/2007/05/25/identify-and-troubleshoot-slow-running-queries-in-sql-server.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.