[Script of Oct. 29] Check non-BUF Latches (T-SQL)


Script Download: Latch.zip
http://gallery.technet.microsoft.com/scriptcenter/Check-non-BUF-Latches-T-SQL-099b4753

This script will check non-BUF latch information. It waits for a minute and collects the historical latches and instantaneous latches on the instance. If you suspect there is latch contention, you can run this script and troubleshoot based on the results.

You can use this script for troubleshooting when you want to check latch contention in SQL Server. 

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

Comments (1)

  1. aw says:

    You amazingly come with really good posts. Thanks a lot for sharing your blog Microsoft.

    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Teknik
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Teknisi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Televisi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Teller
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20TNI
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Trans7
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20PLN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Telkomsel
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Kimia%20Farma
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jakarta%20Selatan
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jakarta%20Pusat
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Jakarta%20Barat
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jakarta%20Timur
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jakarta%20Utara
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Indosat
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20XL%20AXIATA
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Bangka%20Belitung
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Gorontalo
    http://www.lokerjobindo.com/search/label/Loker%20Daera%20Jambi
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jawa%20Barat
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jawa%20Tengah
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jawa%20Timur
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Kalimantan%20Barat
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Kalimantan%20Selatan
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Kalimantan%20Tengah
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Kalimantan%20Timur
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Kalimantan%20Utara
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Sopir
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Statistik
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20swasta
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Tambang
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BUMN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terbaru
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20SMA
    http://www.lokerjobindo.com
    http://www.yacinta.com
    http://www.kerjabumn.com
    http://www.wisatasia.id/search/label/Wisata-Indonesia

    http://www.wisatasia.id