Pro SQL Server 2019 Wait Statistics by Enrico van de Laar

Author:Enrico van de Laar
Language: eng
Format: epub
ISBN: 9781484249161
Publisher: Apress

Listing 7-5Restore AdventureWorks database

If we were to look at the sys.dm_os_waiting_tasks DMV while the backup is running, we would see the waits occurring as shown in Figure 7-8, which shows a selection of waits on my test SQL Server.

Figure 7-8BACKUPTHREAD and other waits

As you can see in Figure 7-8, the wait time of the BACKUPTHREAD wait type is pretty close to that of the PREEMPTIVE_OS_WRITEFILEGATHER wait type. This wait type is responsible for writing data to the file system, but we will dive deeper into this specific wait type in Chapter 11, “Preemptive Wait Types.”

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.