Profiler | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


When 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,
TSQL: Completed.
RC: Completed.
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy. 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.