[Script of Feb. 6] Script to validate Tempdb configuration in SQL Server


Script Download: ValidateTempdbConfig.zip 
http://gallery.technet.microsoft.com/scriptcenter/Script-to-validate-Tempdb-4c988afa 

This T-SQL sample script illustrates how to check tempdb configuration per best practices. Tempdb is a system database is highly used by Sql Server and an optimal tempdb configuration is generally important for smooth running of the Sql instance.

Ideal tempdb configuration is a frequently asked question by IT administrators in the TechNet forums.  IT professionals want to check tempdb best practices by script, for example,

  • Checking current number of tempdb data files
  • Suggesting ideal number of tempdb data files (subject to testing).
  • Checking if tempdb files are created of equal size.
  • Checking if tempdb files are created of equal growth (increment and type).
  • Checking if tempdb trace flag (for uniform extent allocation) is enabled and required depending on Sql version
  • Suggesting if tempdb configuration is healthy if no suggestions were made
  • Ability to run script in Sql 2005/2008/2008R2/2012.
  • Properly switching users in Windows 8 without a Start button can be a bit of a chore. Many users may want to switch users in just one click. This script enables users to click a tile to switch user on the Start menu.
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