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