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.
Exercise 1: PAGEIOLATCH
Exercise 2: PAGELATCH
Exercise 3: WRITELOG
Exercise 4: ASYNC_NETWORK_IO
Reviews
There are no reviews yet.