Nieuws

Andy Hogg demonstrates how to clean up dirty data with the data profiling tool that comes with Microsoft SQL Server ...
Then I would select a Profiler template to use and select events that I wish to trace such as Logins, Logouts, Stored Procedures starting, finishing, T-SQL Batches starting etc.
The SQL Profiler allows you to select the Deadlock Graph as a traced event. It captures deadlock information in XML format and displays it graphically in the tool.