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.
What is the alternative for this?