| Name | Run Value | Config Value | Minimum | Maximum | Dynamic |
|---|---|---|---|---|---|
| max degree of parallelism | 8 | 8 | 0 | 32767 | True |
| cost threshold for parallelism | 50 | 50 | 0 | 32767 | True |
| max server memory (MB) | 65536 | 65536 | 128 | 2147483647 | True |
| xp_cmdshell | 0 | 0 | 0 | 1 | True |
| Property | Value |
|---|---|
| Edition | Standard Edition (64-bit) |
| VersionString | 16.0.4180.1 |
| ProductLevel / Update | RTM / CU12 |
| IsClustered / IsHadrEnabled | False / False |
| Collation | SQL_Latin1_General_CP1_CI_AS |
| LoginMode | Mixed |
| BackupDirectory | D:\Backups |
| DefaultFile / DefaultLog | E:\Data\ / F:\Log\ |
| Service | Type | State | Start Mode | Account |
|---|---|---|---|---|
| SQL Server (MSSQLSERVER) | Engine | Running | Automatic | CONTOSO\svc_sql |
| SQL Server Agent (MSSQLSERVER) | Agent | Running | Automatic | CONTOSO\svc_sqlagent |
| Logical Name | Type | Size | Growth | Growth Type |
|---|---|---|---|---|
| tempdev | Rows | 1024 MB | 256 | MB |
| tempdev2 | Rows | 1024 MB | 256 | MB |
| templog | Log | 512 MB | 128 | MB |
| Name | Data Source | Provider | Catalog |
|---|---|---|---|
| REPORTINGDW | REPORTINGDW\MSSQLSERVER | SQLNCLI | ReportingDW |