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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-05-16 : 10:44:10
|
| I have a small doubt.where is the ideal place to run a profiler .can we run a profiler on production server or we have to run profiler on a seperate instance and connect to production server |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-16 : 11:15:54
|
| Profiler can be run from any machine that has connectivity to the server you are monitoring. It does, however, create a small load on the monitored server, so if your server is already suffering from high CPU usage, or memory usage, you may want to run it only in short bursts from a remote client. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 12:08:21
|
| Try to filter it and capture only those events that you need. |
|
|
|
|
|
|
profiler