In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.
Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly
Launching Visual Studio on my VM failed with: The ‘SqlStudio Profile Package’ package did not load correctly. I gathered a list of fixes that can solve it.
SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly
Doing create catalog in SSMS failed with Error 911: database SSISDB does not exist. Here is how SQL Server Profiler showed me the real cause.
SQL SERVER – SQL Profiler vs Extended Events
SQL Profiler or Extended Events? I compare how each one works, why SQL Trace adds overhead on a busy server, and why Extended Events is my choice.
SQL SERVER – FIX: SQL Profiler Error – Cannot Retrieve Trace Definition for SQL Server Version
Profiler on SQL Server 2016 showed an empty message box, then ‘Cannot retrieve trace definition for SQL Server version’. How I fixed this SQL Profiler Error.
Watching Live Data With the XEvent Profiler
XEvent Profiler in SSMS offers live Standard and T-SQL event views; a focused Extended Events session serves repeat investigations.
SQL SERVER – Plan Caching and Schema Change – An Interesting Observation
What counts as a schema change for plan caching? More than table structure: adding or dropping an index also qualifies, per Greg Low’s white paper.