Capture SQL Server Trace (Server Side)
Run SQL Server Background Trace While troubleshooting lot of performance issues one thing which was common is running SQL Server Profiler. Running SQL Server Profiler from client machine or on the server it is treated as client side trace and system resources are being utilized. Situation gets worst when we do not have much resource […]