Get SQL Server Configuration using T-SQL


As a SQL architect or Database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share how to accomplish this task.


The following T-SQL script returns the following information for your SQL Server instance.


  • Domain

  • SQLServerName

  • InstanceName

  • ComputerNamePhysicalNetBIOS

  • Clustered or not clustered

  • ClusterNodes

  • Active Node

  • HostIPAddress

  • PortNumber

  • Authentication Mode

  • Product Version

  • ProductLevel

  • Resource Version

  • ResourceLastUpdateDateTime

  • EngineEdition

  • BuildClrVersion

  • Collation

  • ComparisonStyle

  • FullTextInstalled or not

  • SQLCharset

  • SQLCharsetName

  • SQLSortOrderName

  • Platform

  • Windows Version

  • ProcessorCount

  • ProcessorType

  • Physical Memory

  • PageFile

  • SQL Server Installation Location

  • BinariesPath

  • Error Logs Location

  • Service account for SQL Server service

  • Service account for SQL Server agent

  • Startup type for SQL Server service

  • Startup type for SQL Server agent server

  • Instance Last Start Date

Take the script from the link and execute it on your SQL instance.
https://github.com/rajendragp/RajendraScripts/blob/master/SQLServerConfiguration.sql

73 views0 comments