anzz
SSCertifiable
Points: 5503
More actions
August 4, 2010 at 9:06 pm
#141495
Hi guys
I need to run a SQL Trace on prod server. we have issues with one database that is performing slow.
So, we are running trace.
My question is what are the events selection i should select in SQL Sever Profiler?
Thanks in advance.
Jack Corbett
SSC Guru
Points: 184394
August 4, 2010 at 10:03 pm
#1202480
It depends on what you think is causing the issue. I'd start with RPC:Completed and SQL:BatchCompleted as these give you CPU, Reads, Writes, and Duration.
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
August 5, 2010 at 7:56 am
#1202753
Thank you Jack.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply