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.
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.