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) …
Leggi »Articoli
Daily Series: A SQL Server DBA Myth a day
A SQL Server DBA Myth a day In questa serie di posts di Paul Randal vengono sfatati alcuni “miti” diffusi tra i DBA SQL Server. (1/30) in-flight transactions continue after a failover (2/30) DBCC CHECKDB causes blocking (3/30) instant file initialization can be controlled from within SQL Server (4/30) DDL triggers are INSTEAD OF triggers (5/30) AWE must be enabled …
Leggi »