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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-11-17 : 11:56:22
|
| Env.: Win2k3, SQL2k SP3I want to monitor the Production server. I can run Profiler on another machine and set it to monitor my production. I can also use Profiler to create a trace script and run it in QA on the same machine instead of Profiler. Which one has less impact to production? The answer seems obvious that a script should be better than a GUI utility like Profiler but I am looking for any Microsoft suggestion or any practical experience. Thanks,Canada DBA |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-17 : 13:23:24
|
| Don't think it matters so long as it is not run on SQL Server box itselfKristen |
 |
|
|
|
|
|
Profiler or trace script?