Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2011-11-29 : 06:33:08
|
| Hi All,I have to analyze procedure perormance and its blockings and dependant tables indexes from sql server profiler.Please tell me what are the events to be selected in profiler?TIA. |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-11-29 : 11:50:56
|
| Can you do this in a test environment that's very similar to production? If so it might be easiest to run only the proc(s) you care about there while running the monitors from SQL Sentry or SQL Solutions, etc. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-11-30 : 15:45:04
|
| Why you want to do in Profiler for procedure? Can't you check the underlying query and it's execution plans. |
|
|
|
|
|
|
SQL Server Profiler analysis