How to use MS SQL Server Profiler?

Database

How to use MS SQL Server Profiler?

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?

Tags (1)
2 REPLIES

Re: How to use MS SQL Server Profiler?

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

    Re: How to use MS SQL Server Profiler?

    Thanks andrew for your suggestion