Find the use of deprecated or discontinued features without Profiler. Here is a step by step way to track them using Extended Events in SSMS.
SQL SERVER – Identify Page Splits Using Extended Events in SQL Server
How can you track page splits inside SQL Server? PerfMon gives you a count, but here is how to see each of the page splits using Extended Events.
SQL SERVER – System procedures to know SQL Server Version
There are many ways to know SQL Server version, but did you know two system procedures, sp_server_info and xp_msver, also return it?
Schema Change Reports in SQL Server: SQL in Sixty Seconds #078
Schema change reports show which tables, views and indexes were created, altered or dropped recently. The tests here read the default trace behind the SSMS report with T-SQL, show what it misses, and set up an Extended Events session for longer memory.
SQL SERVER – Filtering CPU Bound Execution Plans with Extended Events
Profiler captures every plan or none. With query_post_execution_showplan, Extended Events can capture only CPU bound execution plans in SQL Server 2012.
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.
Investigating a Past Slowdown With the system_health Session
Nobody was tracing when it got slow. The system_health session was. Here is how to read what it kept before the files roll over.







