As an application, SQL Server may request system resources as it executes a user query and waits for its request to be completed.  Waits are represented by SQL Server wait statistics. SQL Server tracks wait information any time that a user connection or session_id is waiting. This wait information is summarized and categorized across all connections so that a performance profile can be obtained for a given work load. In this lab we will observer four wait types that frequently occur in SQL Server. In this lab, we’ll learn PAGEIOLATCH, PAGELATCH, WRITELOG and ASYNC_NETWORK_IO wait types.

Subscribe to Download


Version1.0
Download7
File Size657.17 KB
Create DateSeptember 7, 2016
Last UpdatedSeptember 12, 2016
SQL Server Wait Types Part 2
SQL Server Transaction Log Management