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