Server ALEN-PC\SQLSERVER2016

CollapseAll image

Collapse image 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    

Collapse image 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 (Build 14393: )

Collapse image 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  
Total: 13 database(s)

Collapse image 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 

Collapse image See also


Jobs

Logins

Server roles