question

skbarik avatar image
skbarik asked

Performance Monitor

In which scenario Performance Monitor and SQL Profiler can be used in Production Environment..
profilerperformance-monitor
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

For all answers that are helpful, please indicate this by clicking on the thumbs up next to those answers. If any one answer solved your problem, please indicate that by clicking on the check mark next to that answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Performance Monitor and Profiler are both graphical tools that I wouldn't recommend ever running directly against production machines. Instead, create Data Collector Sets and Server-side Trace from each of the tools respectively. These are command line equivalents of the tools that you can use to output to a file. That allows you to collect the data without running the GUI on the servers. You can then use the GUI software on a different machine to browse and aggregate the data. And, if you're on 2008 or better, I'd strongly recommend extended events over trace/profiler. The events are more lightweight and the filtering mechanisms occur at data collection time, not after collecting the data. Makes a huge difference in the impact on a system. They're much safer.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
Can you elaborate on your question? Performance Monitor is very light weight, running a profiler trace against production is ok in many situations depending on the load on the server and what all you are collecting. It is a primary tool for many of us for collection workloads to do analysis on. Extended events are also good for such data. It is highly recommended though to run the trace on another station other than the actual server.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.