Databases
1Properties
| Name | Value |
|---|---|
| Product | Microsoft SQL Server |
| Version Level | RTM |
| Edition | Standard Edition (64-bit) |
| Version | 16.0.1000.6 |
| Language | English (United States) |
| Collation | SQL_Latin1_General_CP1_CI_AS |
| Platform | NT x64 |
| OS Version | 6.3 (20348) |
| Processors | 16 |
| Physical Memory (Mb) | 32767 |
| Clustered | False |
| Root Directory | D:\SQL_Data\MSSQL16.MSSQLSERVER\MSSQL |
Settings
| Name | Value |
|---|---|
| Default data file path | D:\SQL_Data\MSSQL16.MSSQLSERVER\MSSQL\DATA\ |
| Default log file path | E:\SQL_logs\ |
| Default backup file path | D:\Backups\ |
| Recovery Interval (minutes) | 0 |
| Default index fill factor (%) | 80 |
| Default backup media retention (days) | 0 |
| Compress backup | False |
| Nested triggers enabled | True |
| Allow triggers to fire others | True |
| Default language | us_english |
| Default fulltext language | us_english |
| Default fulltext language LCID | 1033 |
| Network packet size | 4096 |
| Two digit year cutoff | 2049 |
| Max text replication size (bytes) | 65536 |
| Locks | 0 |
| Blocked process threshold | 0 |
| Cursor threshold | -1 |
| Cost threshold for parallelism | 5 |
| Scans and runs startup procedures | False |
| Transform noise words | True |
| Filestream access level | Disabled |
| Optimize for 'ad hoc' workloads | False |
| Remote login timeout (sec) | 10 |