SQL Server Performance Forum – Threads Archive

Minimize Production Monitoring Impacts

How can I set the Profiler to minimize its impact on the production? I am running Profiler on another server connected to my production. Is this true that if I use any third party utilities to monitor (and log trace) the production, I would expect the same impact as Profiler? If not, I like to hear about it and your experience with it.
Thanks, CanadaDBA

---

The impact of Profiler on production server depends:
1) Use only neccesay columns.
2) Filter duration.
3) Filter application. About third party tools, I don’t know any tools capable to trace as Profiler.
The lest impact third party tool I know is Sqldiagnostic, but is usefull for Performance Monitor.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

Use server side trace and those will have minimal impact than using PROFILER gui tool: http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
http://vyaskn.tripod.com/analyzing_profiler_output.htm
http://support.microsoft.com/?kbid=822853 With regard to the third party tools, you must test them in the test environment before deploying directly on production, as few processess might have negative effect depending upon the environment and Vendor will be more than happy to fix the customer problems. FYI Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Sorry to ask the following question. Maybe it looks a dum question but I am confused with the term and want to know. Does the "server side" mean the Production server or another server connected to the Production? When you say Use server side trace do you mean the Prod server? CanadaDBA

---

You can run Profiler from other Work Station, I suppose that what Satya mean.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

You can run a trace and not even use Profiler. You just save the trace results to a file. You can then import the file to tables and analyze. Then, you don’t have the overhead of Profiler at all. That’s what we do at our shop. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

I mean to say to run from SQL SErver side and not from any other client’s machine or server. This is to reduce the network contention if the server is already stressed out.[8D]
Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>