Home > Articoli (page 2)

Articoli

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) …

Leggi »

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 »