How can I do the replacement of SQL Server Profiler deprecation?

Question

I am building an application using ASP.NET and SQL Server But I am facing trouble with SQL query and I would like to see the response of SQL servers.

I can achieve this using the Profiler.exe tool in SQL Server, but got the information that Microsoft will deprecate this tool soon as follows:

We are announcing the deprecation of SQL Server Profiler for Database Engine Trace Capture and Trace Replay. These features will be supported in the next version of SQL Server but will be removed in a later version. The specific version of SQL Server has not been determined. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replays objects will also be deprecated. Note that SQL Server Profiler for the Analysis Services workloads is not being deprecated, and will continue to be supported.

http://msdn.microsoft.com/en-us/library/ms181091.aspx

What is the alternative for this?

Answer 1

You can use trace for the next few versions because it is safe but profiler is never the solution for this. You can check out the proof from here.

If you really want to use trace, then use a server-side trace. But do not write the new code for the trace and expect to live beyond a few versions.

In case you want to use it for a longer-term, then use extended events. You can go through this blog for further information regarding this.

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.