Server
ALEN-PC\SQLSERVER2016
Server properties
| Name | Value |
| Code page | 1252 |
| Network name | ALEN-PC |
| Language | us_english |
| Maximum degree of parallelism | 0 |
| Service name | MSSQL$SQLSERVER2016 |
| Instance name | SQLSERVER2016 |
| Collation | Latin1_General_CI_AI |
| Is clustered | |
| Is full text search installed | |
Version
| Microsoft SQL Server 2016 (RTM-GDR) (KB3179258) - 13.0.1711.0 (X64) Jul 29 2016 16:16:44 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows 10 Pro 6.3 |
Databases
| Database | Owner | System | |
![]() |
AdventureWorks2016CTP3 | Alen-PC\Alen | |
![]() |
iFileTransferV2 | Alen-PC\Alen | |
![]() |
IntradeHarvard2011 | Alen-PC\Alen | |
![]() |
JankoMaster | Alen-PC\Alen | |
![]() |
master | sa | ![]() |
![]() |
model | sa | ![]() |
![]() |
msdb | sa | ![]() |
![]() |
pubs | Alen-PC\Alen | |
![]() |
SSISDB | Alen-PC\Alen | |
![]() |
sysdb1 | Alen-PC\Alen | |
![]() |
sysdb2 | Alen-PC\Alen | |
![]() |
tempdb | sa | ![]() |
![]() |
tSQLt_Example | Alen-PC\Alen |
Server configuration
| Parameter name | Value |
| affinity I/O mask | 0 |
| affinity mask | 0 |
| affinity64 I/O mask | 0 |
| affinity64 mask | 0 |
| Allow cross db ownership chaining | 0 |
| Allow INSERT into a Hadoop external table | 0 |
| Allow recursion for server level triggers | 1 |
| Allow remote access | 1 |
| Allow the use of the REMOTE_DATA_ARCHIVE data access for databases | 0 |
| Allow triggers to be invoked within triggers | 1 |
| Allow updates to system tables | 0 |
| Allows execution of external scripts | 0 |
| Automatic soft-NUMA is enabled by default | 0 |
| Blocked process reporting threshold | 0 |
| c2 audit mode | 0 |
| CLR user code execution enabled in the server | 1 |
| Common Criteria compliance mode enabled | 0 |
| Configure SQL Server to connect to external Hadoop or Microsoft Azure storage blob data sources through PolyBase | 7 |
| Configure SQL Server to encrypt control and data channels when using PolyBase | 1 |
| cost threshold for parallelism | 5 |
| Create DTC transaction for remote procedures | 0 |
| cursor threshold | -1 |
| DB connection timeout for full-text protocol handler (s) | 60 |
| Dedicated Admin Connections are allowed from remote clients | 0 |
| Default fill factor percentage | 0 |
| default full-text language | 1033 |
| Default hash bucket count for the access check result security cache | 0 |
| default language | 0 |
| Default quota for the access check result security cache | 0 |
| Disallow returning results from triggers | 0 |
| Enable checksum of backups by default | 0 |
| Enable compression of backups by default | 0 |
| Enable or disable Ad Hoc Distributed Queries | 0 |
| Enable or disable Agent XPs | 1 |
| Enable or disable command shell | 0 |
| Enable or disable Database Mail XPs | 0 |
| Enable or disable EKM provider | 0 |
| Enable or disable Ole Automation Procedures | 0 |
| Enable or disable Replication XPs | 0 |
| Enable or disable SMO and DMO XPs | 1 |
| Enable or disable the default trace | 1 |
| Enables contained databases and contained authentication | 1 |
| Max number of full-text crawl buffers | 100 |
| Max number of full-text notifications buffers | 100 |
| Maximum crawl ranges allowed in full-text indexing | 4 |
| maximum degree of parallelism | 0 |
| Maximum estimated cost allowed by query governor | 0 |
| Maximum recovery interval in minutes | 0 |
| Maximum size of a text field in replication. | 65536 |
| Maximum size of server memory (MB) | 2147483647 |
| maximum time to wait for query memory (s) | -1 |
| Maximum worker threads | 0 |
| Memory for index create sorts (kBytes) | 0 |
| minimum memory per query (kBytes) | 1024 |
| Minimum size of server memory (MB) | 0 |
| Network packet size | 4096 |
| Number of locks for all users | 0 |
| Number of open database objects | 0 |
| Number of reserved full-text crawl buffers | 0 |
| Number of reserved full-text notifications buffers | 0 |
| Number of user connections allowed | 0 |
| Priority boost | 0 |
| Recovery policy for DTC transactions with unknown outcome | 0 |
| remote login timeout | 10 |
| remote query timeout | 600 |
| scan for startup stored procedures | 0 |
| set working set size | 0 |
| Sets the FILESTREAM access level | 0 |
| show advanced options | 0 |
| Tape retention period in days | 0 |
| Transform noise words for full-text query | 0 |
| two digit year cutoff | 2049 |
| Use precomputed rank for full-text query | 0 |
| User mode scheduler uses lightweight pooling | 0 |
| user options | 0 |
| When this option is set, plan cache size is further reduced for single-use adhoc OLTP workload. | 0 |
See also