[Script of Oct. 4] Check VLF information (T-SQL)


Script Download: VLFinfo.zip
http://gallery.technet.microsoft.com/scriptcenter/Check-VLF-information-T-SQL-f7e2bd94

This script will list the actual log size, used log space, actual VLFs and used VLFs etc. information of all databases in an instance. Besides, the script will proactively list potential log size, potential VLFs of based on the current size of the transaction log.

The script will list information about VLFs about all the databases in an instance.

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

Skip to main content