Server DEVSQL2016EA172
PropertyValue
ProductMicrosoft SQL Server
Version13.0.4224.16
LanguageEnglish (United States)
PlatformNT x64
EditionDeveloper Edition (64-bit)
Processors4
OS Version6.3 (9600)
Physical Memory8191
Is ClusteredFalse
Root DirectoryC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL
CollationSQL_Latin1_General_CP1_CI_AS
PropertyValue
Default data file pathC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\
Default backup file pathC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup
Default log file pathC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\
Recovery Interval (minutes)0
Default index fill factor0
Default backup media retention0
Compress BackupFalse
PropertyValue
Locks0
Nested triggers enabledTrue
Allow triggers to fire othersTrue
Default languageEnglish
Network packet size4096
Default fulltext language LCID1033
Two-digit year cutoff2049
Remote login timeout10
Cursor threshold-1
Max text replication size65536
Parallelism cost threshold50
Max degree of parallelism0
Min server memory256
Max server memory2147483647
Scan for startup procsFalse
Transform noise wordsFalse
CLR enabledFalse
Blocked process threshold0
Filestream access levelFalse
Optimize for ad hoc workloadsFalse