Define sql profiler & it's use with detailed example?

Question

Vasanth Natarajan · Answer

Hi Kathir P. Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. Sql Tools-->SQl server Profiler-->enter the login credentials and then run the profiler open your Application page by page and see the back-end procedure calling of that opened page you have problem with procedure and parameters to check it directly