Discover how to limit the size of the trace file in SQL Server Profiler and how to specify whether the file rolls over when it reaches maximum size. [!INCLUDE SQL Server] Use the following procedure ...
SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...
A modern SQL Server profiling extension for Visual Studio Code using Extended Events (XEvents). This extension provides a complete replacement for the Azure Data Studio profiler that is being ...
In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...