Home > Articoli > Daily Series: An XEvent a day

Daily Series: An XEvent a day

In questa serie di posts di Jonathan Kehayias si parla di come utilizzare gli Extended Events per monitorare SQL Server.

(1 of 31) – An Overview of Extended Events
(2 of 31) – Querying the Extended Events Metadata
(3 of 31) – Managing Event Sessions
(4 of 31) – Querying the Session Definition and Active Session DMV’s
(5 of 31) – Targets Week – ring_buffer
(6 of 31) – Targets Week – asynchronous_file_target
(7 of 31) – Targets Week – bucketizers
(8 of 31) – Targets Week – synchronous_event_counter
(9 of 31) – Targets Week – pair_matching
(10 of 31) – Targets Week – etw_classic_sync_target
(11 of 31) – Targets Week – Using multiple targets to simplify analysis
(12 of 31) – Using the Extended Events SSMS Addin
(13 of 31) – The system_health Session
(14 of 31) – A Closer Look at Predicates
(15 of 31) – Tracking Ghost Cleanup
(16 of 31) – How Many Checkpoints are Issued During a Full Backup?
(17 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1)
(18 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 2)
(19 of 31) – Using Customizable Fields
(20 of 31) – Mapping Extended Events to SQL Trace
(21 of 31) – The Future – Tracking Blocking in Denali
(22 of 31) – The Future – fn_dblog() No More? Tracking Transaction Log Activity in Denali
(23 of 31) – How it Works – Multiple Transaction Log Files
(24 of 31) – What is the package0.callstack Action?
(25 of 31) – The Twelve Days of Christmas
(26 of 31) – Configuring Session Options
(27 of 31) – The Future – Tracking Page Splits in SQL Server Denali CTP1
(28 of 31) – Tracking Page Compression Operations
(29 of 31) – The Future – Looking at Database Startup in Denali
(30 of 31) – Tracking Session and Statement Level Waits
(31 of 31) – Event Session DDL Events

Chi è Davide Mauri

Microsoft Data Platform MVP dal 2007, Davide Mauri si occupa di Data Architecture e Big Data nel mondo dell'IoT. Attualmente ricopre il ruolo di "Director Software Development & Cloud Infrastructure" in Sensoria, societa specializzata nella creazione di Wearables e sensori per l'IoT applicati a tessuti ed oggetti sportivi.

Leggi Anche

Automazione delle attività di manutenzione in Azure SQL Database (2 Parte)

Introduzione Nell’articolo Automazione delle attività di manutenzione in Azure SQL Database abbiamo descritto le attività …