Server properties: ALEN-PC\TABULAR2016
Name | Value | Pending value (if different) | Default value | Units |
BackupDir | C:\Program Files\Microsoft SQL Server\MSAS13.TABULAR2016\OLAP\Backup | Folder | ||
CollationName | Latin1_General_CI_AI | |||
CommitTimeout | 0 | 0 | MS | |
CoordinatorExecutionMode | -4 | -4 | ||
DataDir | C:\Program Files\Microsoft SQL Server\MSAS13.TABULAR2016\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.TABULAR2016\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 |
Name | Value | Pending value (if different) | Default value | Units |
AllowedBrowsingFolders | C:\Program Files\Microsoft SQL Server\MSAS13.TABULAR2016\OLAP\Backup\|C:\Program Files\Microsoft SQL Server\MSAS13.TABULAR2016\OLAP\Log\|C:\Program Files\Microsoft SQL Server\MSAS13.TABULAR2016\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.TABULAR2016\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 |