SQL Server System Info


SQL Server System Info
This script provides SQL Server instance level configurations.

GitHub Gist : https://gist.github.com/I90Runner/7bc31a10897a2168816073db781d5e77

Results from the Above Query

ServerPropertyValue
AuditLevel3
NumberOfLogFiles-1
LoginMode2
MailProfile
BackupDirectory
PerfMonMode1000
InstallDataDirectory
ServiceName
ErrorLogPath
RootDirectory
IsCaseSensitive0
MaxPrecision38
IsFullTextInstalled1
VersionString13.0.1400.361
EditionEnterprise Evaluation Edition (64-bit)
ProductLevelRC3
IsSingleUser0
EngineEdition3
CollationSQL_Latin1_General_CP1_CI_AS
IsClustered0
NetName
MasterDBLogPathG:\SQL2016\MSSQL13.DEV2016\MSSQL\DATA
MasterDBPathG:\SQL2016\MSSQL13.DEV2016\MSSQL\DATA
DefaultFileG:\SQL2016\MSSQL13.DEV2016\MSSQL\DATA\
DefaultLogL:\SQL2016\
ResourceVersionString13.00.1400
ResourceLastUpdateDateTime35:44.1
CollationID872468488
ComparisonStyle196609
SqlCharSet1
SqlCharSetNameiso_1
SqlSortOrder52
SqlSortOrderNamenocase_iso
ComputerNamePhysicalNetBIOS
BuildClrVersionStringv4.0.30319
ServiceStartMode2
ServiceAccount
NamedPipesEnabled0
TcpEnabled1
InstallSharedDirectory
SqlDomainGroupNT Service\MSSQL$DEV2016
PolicyHealthState0
FilestreamLevel3
FilestreamShareName
TapeLoadWaitTime-1
IsHadrEnabled0
HadrManagerStatus2
ClusterName
ClusterQuorumType4
ClusterQuorumState3
ServiceAccountSidNULL
Name
InstanceName
Status1
IsContainedAuthentication0
ServerTypeNULL

Leave a Reply

Your email address will not be published. Required fields are marked *

*