17 Jun

Best Practice No.13

If you have to use Profiler on your production SQL Servers – filter as much as you can, configure profiler from a remote machine and do not save the profiler trace on the same production box. Rather prefer using server-side trace.
Note: Profiler is deprecated now, start using Extended Events – they are very light weight.

About Author:

SQLServer - MVP Sarabpreet is SQLServer MVP, Consultant, Speaker, Trainer, Blogger and Community Lead. You can find him speaking at a local UG Event or a SQL Webcast. He has 11+ years of Experience and worked with Industry Leaders. He has many SQL Certifications under his belt. His core competency lies in administration of SQL Server. Always ready to help, online \offline. His life’s mantra is “Knowledge Increases by sharing so, Pass it on”.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.