0

I have a basic knowledge about Microsoft SQL Server Profiler but I want to know that can I monitor a production environment to see which stored procedures are affecting performance by executing too slowly?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Jason Clark
  • 1,307
  • 6
  • 26
  • 51
  • 1
    possible duplicate of [How Can I Log and Find the Most Expensive Queries?](http://stackoverflow.com/questions/257906/how-can-i-log-and-find-the-most-expensive-queries) – Mitch Wheat Sep 19 '15 at 04:17
  • You probably should look into plan cache first, it stores quite a lot of performance related information without having to setup anything extra – James Z Sep 20 '15 at 20:06

1 Answers1

3

SQL Server Profile is very bad for using it in production environment. It could be cause of performance degradation. I could recommend to you two ways

  1. Extended events
  2. Trace

I prefer first one. You can find a lot of information and examples how to use both of them

Vladimir Semashkin
  • 1,270
  • 1
  • 10
  • 21