[Script of Feb. 5] Script to review non-default SQL configuration settings (sp_configure)


Script Download: NonDefaultSpConfigure.zip 
http://gallery.technet.microsoft.com/scriptcenter/Script-to-review-non-d5c1a6ae 

This is a frequent troubleshooting requirement for individual sp_configure values during most SQL performance troubleshooting. We've hundreds of known cases which have this settings check as among first step of SQL performance troubleshooting.

Quickly checking sp_configure values is a frequently asked question by IT administrators in the TechNet forums.  IT professionals want to validate the non-default SQL Server configuration values so as to quickly identify these values using T-SQL scripts, for example,
  • Encountering a performance issue.
  • Validating SQL instance configuration settings.
  • Running same script across multiple versions (SQL Server 2005/2008/2008R2/2012)
  • When automating this collection across multiple server using scripts
  • Checking Sql instance configuration settings with respect to http://support.microsoft.com/kb/319942 (How to determine proper SQL Server configuration settings).
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/Loker%20Daerah%20Kepulauan%20Riau
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Maluku
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Maluku%20Utara
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Nusa%20Tenggara%20Barat
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Nusa%20Tenggara%20Timur
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sulawesi%20Barat
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sulawesi%20Selatan
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sulawesi%20Tengah
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sulawesi%20Tenggara
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sulawesi%20Utara
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sumatera%20Barat
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sumatera%20Selatan
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sumatera%20Utara
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Antar%20Daerah
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Artha%20Graha%20Internasional
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Bukopin
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Bumi%20Arta
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20ICB%20Bumiputera%20Indonesia
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Ekononomi%20Raharja
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Ganesha
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Hana
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Himpunan%20Saudara%201906
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20ICBC%20Indonesia
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Index%20Selindo
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20SBI%20Indonesia
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Internasional%20Indonesia
    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