Home > Articoli > Daily Series: Wait stats

Daily Series: Wait stats

Pinal Dave (blog | twitter) in questa serie di posts ci parla dei vari wait stats e queues.

Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28

Signal Wait Time Introduction with Simple Example – Wait Type – Day 2 of 28

DMV – sys.dm_os_wait_stats Explanation – Wait Type – Day 3 of 28

DMV – sys.dm_os_waiting_tasks and sys.dm_exec_requests – Wait Type – Day 4 of 28

Capturing Wait Types and Wait Stats Information at Interval – Wait Type – Day 5 of 28

CXPACKET – Parallelism – Usual Solution – Wait Type – Day 6 of 28

CXPACKET – Parallelism – Advanced Solution – Wait Type – Day 7 of 28

SOS_SCHEDULER_YIELD – Wait Type – Day 8 of 28

PAGEIOLATCH_DT, PAGEIOLATCH_EX, PAGEIOLATCH_KP, PAGEIOLATCH_SH, PAGEIOLATCH_UP – Wait Type – Day 9 of 28

IO_COMPLETION – Wait Type – Day 10 of 28

ASYNC_IO_COMPLETION – Wait Type – Day 11 of 28

PAGELATCH_DT, PAGELATCH_EX, PAGELATCH_KP, PAGELATCH_SH, PAGELATCH_UP – Wait Type – Day 12 of 28

FT_IFTS_SCHEDULER_IDLE_WAIT – Full Text – Wait Type – Day 13 of 28

BACKUPIO, BACKUPBUFFER – Wait Type – Day 14 of 28

LCK_M_XXX – Wait Type – Day 15 of 28

Guest Post – Jonathan Kehayias – Wait Type – Day 16 of 28

WRITELOG – Wait Type – Day 17 of 28

LOGBUFFER – Wait Type – Day 18 of 28

PREEMPTIVE and Non-PREEMPTIVE – Wait Type – Day 19 of 28

MSQL_XP – Wait Type – Day 20 of 28

Guest Posts – Feodor Georgiev – The Context of Our Database Environment – Going Beyond the Internal SQL Server Waits – Wait Type – Day 21 of 28

Guest Post – Jacob Sebastian – Filestream – Wait Types – Wait Queues – Day 22 of 28

OLEDB – Link Server – Wait Type – Day 23 of 28

2000 – DBCC SQLPERF(waitstats) – Wait Type – Day 24 of 28

2011 – Wait Type – Day 25 of 28

Guest Post – Glenn Berry – Wait Type – Day 26 of 28

Best Reference – Wait Type – Day 27 of 28

Summary of Month – Wait Type – Day 28 of 28

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