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?
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.
Auditing Failed Logins With the Error Log and Extended Events
Investigate failed logins with the SQL Server error log and a focused Extended Events session, then group attempts and decide what to do.
Why Queries Recompile
Why queries recompile becomes clearer when you capture Extended Events causes and check schema changes, statistics, SET options, and temp tables.