Server properties: ALEN-PC\SQLSERVER2016

CollapseAll image

Collapse image Basic properties


Name  Value  Pending value (if different)  Default value  Units 
BackupDir C:\Program Files\Microsoft SQL Server\MSAS13.SQLSERVER2016\OLAP\Backup     Folder
CollationName Latin1_General_CI_AI      
CommitTimeout 0   0 MS
CoordinatorExecutionMode -4   -4  
DataDir C:\Program Files\Microsoft SQL Server\MSAS13.SQLSERVER2016\OLAP\Data   \data Folder
DataMining\AllowAdHocOpenRowsetQueries false   false  
DataMining\AllowSessionMiningModels false   false  
DataMining\MaxConcurrentPredictionQueries 0   0  
Feature\ComUdfEnabled false   false  
Feature\LinkFromOtherInstanceEnabled false   false  
Feature\LinkInsideInstanceEnabled true   true  
Feature\LinkToOtherInstanceEnabled false   false  
ForceCommitTimeout 30000   30000 MS
Language 1033   0  
Log\FlightRecorder\Enabled true   true  
Log\QueryLog\CreateQueryLogTable false   false  
Log\QueryLog\QueryLogConnectionString        
Log\QueryLog\QueryLogSampling 10   10  
Log\QueryLog\QueryLogTableName OlapQueryLog   OlapQueryLog  
LogDir C:\Program Files\Microsoft SQL Server\MSAS13.SQLSERVER2016\OLAP\Log     Folder
Memory\HardMemoryLimit 0   0  
Memory\LowMemoryLimit 6.5E1   6.5E1  
Memory\TotalMemoryLimit 8.E1   8.E1  
Memory\VertiPaqMemoryLimit 6.E1   6.E1  
Network\ListenOnlyOnLocalConnections false   false  
Network\Requests\EnableBinaryXML false   false  
Network\Requests\EnableCompression false   false  
Network\Responses\EnableBinaryXML true   true  
Network\Responses\EnableCompression true   true  
OLAP\LazyProcessing\Enabled true   true  
OLAP\LazyProcessing\SleepIntervalSecs 5   5 Sec
OLAP\Process\DatabaseConnectionPoolConnectTimeout 60   60  
Port 0   0  
Security\RequireClientAuthentication true   true  

Collapse image Advanced properties


Name  Value  Pending value (if different)  Default value  Units 
AllowedBrowsingFolders C:\Program Files\Microsoft SQL Server\MSAS13.SQLSERVER2016\OLAP\Backup\|C:\Program Files\Microsoft SQL Server\MSAS13.SQLSERVER2016\OLAP\Log\|C:\Program Files\Microsoft SQL Server\MSAS13.SQLSERVER2016\OLAP\Data\   \data  
AutoSetDefaultInitialCatalog true   true  
BackgroundSessionRollbackBatchingInterval 2   2 Sec
CoordinatorCancelCount 1000   1000  
DataMining\Algorithms\Microsoft_Association_Rules\Enabled true   true  
DataMining\Algorithms\Microsoft_Clustering\Enabled true   true  
DataMining\Algorithms\Microsoft_Decision_Trees\Enabled true   true  
DataMining\Algorithms\Microsoft_Linear_Regression\Enabled true   true  
DataMining\Algorithms\Microsoft_Logistic_Regression\Enabled true   true  
DataMining\Algorithms\Microsoft_Naive_Bayes\Enabled true   true  
DataMining\Algorithms\Microsoft_Neural_Network\Enabled true   true  
DataMining\Algorithms\Microsoft_Sequence_Clustering\Enabled true   true  
DataMining\Algorithms\Microsoft_Time_Series\Enabled true   true  
DataMining\AllowedProvidersInOpenRowset        
DSO\LocksDirectory       Folder
DSO\RemoteLocksDirectory       Folder
DSO\RemoteRepositoryConnectionString        
DSO\RepositoryConnectionString        
ExternalCommandTimeout 3600   3600 Sec
ExternalConnectionTimeout 60   60 Sec
Feature\ResourceMonitoringEnabled true   true  
FileStore\RandomFileAccessMode 0   0  
IdleConnectionTimeout 0   0 Sec
IdleOrphanSessionTimeout 120   120 Sec
InstanceVisible true   true  
Log\File msmdsrv.log   msmdsrv.log File
Log\FlightRecorder\FileSizeMB 10   10 MB
Log\FlightRecorder\LogDurationSec 3600   3600 Sec
Log\FlightRecorder\SnapshotDefinitionFile       File
Log\FlightRecorder\SnapshotFrequencySec 120   120 Sec
Log\FlightRecorder\TraceDefinitionFile       File
Log\MaxFileSizeMB 0   0 MB
Log\MaxNumberOfLogFiles 0   0  
Log\MessageLogs File;Console;System   File;Console;System  
Log\Trace\TraceReportFQDN 0   0  
MaxIdleSessionTimeout 0   0 Sec
Memory\HeapTypeForObjects 0   0  
Memory\MemoryHeapType -1   -1  
Memory\VertiPaqPagingPolicy 1   1  
MinIdleSessionTimeout 2700   2700 Sec
Network\Listener\IPV4Support 2   2  
Network\Listener\IPV6Support 2   2  
Network\Listener\MaxAllowedRequestSize 0   0 Bytes
OLAP\LazyProcessing\MaxCPUUsage 5.E-1   5.E-1  
OLAP\LazyProcessing\MaxObjectsInParallel 2   2  
OLAP\Process\AggregationMemoryLimitMax 8.E1   8.E1  
OLAP\Process\AggregationMemoryLimitMin 1.E1   1.E1  
OLAP\Process\BufferMemoryLimit 6.E1   6.E1  
OLAP\Process\CheckDistinctRecordSortOrder 1   1  
OLAP\Process\DatabaseConnectionPoolMax 50   50  
OLAP\Process\DatabaseConnectionPoolTimeout 120000   120000  
OLAP\Process\DeepCompressValue 1   1  
OLAP\Process\ROLAPDimensionProcessingEffort 300000   300000  
OLAP\Process\XMLAConnectionPoolTimeout 720000   720000  
OLAP\ProcessPlan\MemoryLimitErrorEnabled true   true  
OLAP\Query\AutoExistMemoryLimit 6.5E1   6.5E1  
OLAP\Query\DefaultDrillthroughMaxRows 10000   10000  
OLAP\Query\DisableCalcExpressNonEmpty 0   0  
OLAP\Query\NonEmptyBehaviorMode 1   1  
OLAP\Query\QueryOptimizerRatio -1.   -1.  
OLAP\Query\SessionCubesMode 1   1  
PredictiveAnalytics\AlgorithmLibraries\MicrosoftPredictiveAnalytics\CLSID 8B0958F1-D921-40F7-B19C-005B36FC14D5   8B0958F1-D921-40F7-B19C-005B36FC14D5  
PredictiveAnalytics\AlgorithmLibraries\MicrosoftPredictiveAnalytics\Enabled true   true  
PredictiveAnalytics\AlgorithmLibraries\MicrosoftPredictiveAnalytics\Manifest PAAlgo.X.manifest   PAAlgo.X.manifest  
Security\BuiltinAdminsAreServerAdmins true   true  
Security\CellPermissionMode 0   0  
Security\ServiceAccountIsServerAdmin true   true  
ServerTimeout 3600   3600 Sec
TempDir C:\Program Files\Microsoft SQL Server\MSAS13.SQLSERVER2016\OLAP\Temp     Folder
ThreadPool\Command\GroupAffinity        
ThreadPool\Command\MaxThreads 0   0  
ThreadPool\Command\MinThreads 0   0  
ThreadPool\IOProcess\GroupAffinity        
ThreadPool\IOProcess\MaxThreads 0   0  
ThreadPool\IOProcess\MinThreads 0   0  
ThreadPool\IOProcess\PerNumaNode -1   -1  
ThreadPool\Parsing\Long\GroupAffinity        
ThreadPool\Parsing\Short\GroupAffinity        
ThreadPool\Process\GroupAffinity        
ThreadPool\Process\MaxThreads 0   0  
ThreadPool\Process\MinThreads 0   0  
ThreadPool\Query\GroupAffinity        
ThreadPool\Query\MaxThreads 0   0  
ThreadPool\Query\MinThreads 0   0  
VertiPaq\DefaultSegmentRowCount 0   0  
VertiPaq\ProcessingTimeboxSecPerMRow -1   -1  
VertiPaq\ThreadPool\GroupAffinity        
WriteTransactionIdleTimeout 0   0 Sec

Collapse image See also


About this documentation