Advertisement
Guest User

Untitled

a guest
Jun 11th, 2011
1,363
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.38 KB | None | 0 0
  1. <ConfigurationSettings>
  2. <DataDir>C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data</DataDir>
  3. <LogDir>C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log</LogDir>
  4. <BackupDir>C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup</BackupDir>
  5. <AllowedBrowsingFolders>C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup\|C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\</AllowedBrowsingFolders>
  6. <CollationName>Latin1_General_CI_AS</CollationName>
  7. <Language>1033</Language>
  8. <TempDir>C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Temp</TempDir>
  9. <ThreadPool>
  10. <Query>
  11. <MaxThreads>10</MaxThreads>
  12. <MinThreads>1</MinThreads>
  13. <PriorityRatio>2</PriorityRatio>
  14. <Concurrency>2</Concurrency>
  15. <StackSizeKB>0</StackSizeKB>
  16. </Query>
  17. <Process>
  18. <MaxThreads>64</MaxThreads>
  19. <MinThreads>1</MinThreads>
  20. <PriorityRatio>2</PriorityRatio>
  21. <Concurrency>2</Concurrency>
  22. <StackSizeKB>0</StackSizeKB>
  23. </Process>
  24. <Parsing>
  25. <Short>
  26. <NumThreads>4</NumThreads>
  27. <PriorityRatio>2</PriorityRatio>
  28. <Concurrency>2</Concurrency>
  29. <StackSizeKB>512</StackSizeKB>
  30. </Short>
  31. <Long>
  32. <NumThreads>4</NumThreads>
  33. <PriorityRatio>2</PriorityRatio>
  34. <Concurrency>2</Concurrency>
  35. <StackSizeKB>0</StackSizeKB>
  36. </Long>
  37. </Parsing>
  38. </ThreadPool>
  39. <DeploymentMode>0</DeploymentMode>
  40. <ErrorReportingMode>0</ErrorReportingMode>
  41. <Security>
  42. <DataProtection>
  43. <RequiredProtectionLevel>1</RequiredProtectionLevel>
  44. </DataProtection>
  45. <AdministrativeDataProtection>
  46. <RequiredProtectionLevel>1</RequiredProtectionLevel>
  47. </AdministrativeDataProtection>
  48. <RequireClientAuthentication>1</RequireClientAuthentication>
  49. <SecurityPackageList/>
  50. <DisableClientImpersonation>0</DisableClientImpersonation>
  51. <BuiltinAdminsAreServerAdmins>1</BuiltinAdminsAreServerAdmins>
  52. <ServiceAccountIsServerAdmin>1</ServiceAccountIsServerAdmin>
  53. <ErrorMessageMode>2</ErrorMessageMode>
  54. <CellPermissionMode>0</CellPermissionMode>
  55. </Security>
  56. <Network>
  57. <Listener>
  58. <RequestSizeThreshold>4095</RequestSizeThreshold>
  59. <MaxAllowedRequestSize>0</MaxAllowedRequestSize>
  60. <ServerSendTimeout>60000</ServerSendTimeout>
  61. <ServerReceiveTimeout>60000</ServerReceiveTimeout>
  62. <IPV4Support>2</IPV4Support>
  63. <IPV6Support>2</IPV6Support>
  64. </Listener>
  65. <TCP>
  66. <MaxPendingSendCount>12</MaxPendingSendCount>
  67. <MaxPendingReceiveCount>4</MaxPendingReceiveCount>
  68. <MinPendingReceiveCount>2</MinPendingReceiveCount>
  69. <MaxCompletedReceiveCount>9</MaxCompletedReceiveCount>
  70. <ScatterReceiveMultiplier>5</ScatterReceiveMultiplier>
  71. <MaxPendingAcceptExCount>10</MaxPendingAcceptExCount>
  72. <MinPendingAcceptExCount>2</MinPendingAcceptExCount>
  73. <InitialConnectTimeout>10</InitialConnectTimeout>
  74. <SocketOptions>
  75. <SendBufferSize>0</SendBufferSize>
  76. <ReceiveBufferSize>0</ReceiveBufferSize>
  77. <DisableNonblockingMode>1</DisableNonblockingMode>
  78. <EnableNagleAlgorithm>0</EnableNagleAlgorithm>
  79. <EnableLingerOnClose>0</EnableLingerOnClose>
  80. <LingerTimeout>0</LingerTimeout>
  81. </SocketOptions>
  82. </TCP>
  83. <Requests>
  84. <EnableBinaryXML>0</EnableBinaryXML>
  85. <EnableCompression>0</EnableCompression>
  86. </Requests>
  87. <Responses>
  88. <EnableBinaryXML>1</EnableBinaryXML>
  89. <EnableCompression>1</EnableCompression>
  90. <CompressionLevel>9</CompressionLevel>
  91. </Responses>
  92. <ListenOnlyOnLocalConnections>0</ListenOnlyOnLocalConnections>
  93. </Network>
  94. <ExternalConnectionTimeout>60</ExternalConnectionTimeout>
  95. <ExternalCommandTimeout>3600</ExternalCommandTimeout>
  96. <IdleConnectionTimeout>0</IdleConnectionTimeout>
  97. <IdleOrphanSessionTimeout>120</IdleOrphanSessionTimeout>
  98. <MinIdleSessionTimeout>2700</MinIdleSessionTimeout>
  99. <MaxIdleSessionTimeout>0</MaxIdleSessionTimeout>
  100. <ServerTimeout>3600</ServerTimeout>
  101. <AdminTimeout>0</AdminTimeout>
  102. <CommitTimeout>0</CommitTimeout>
  103. <ForceCommitTimeout>30000</ForceCommitTimeout>
  104. <RequestPrioritization>
  105. <Enabled>0</Enabled>
  106. <StatisticsStoreSize>1024</StatisticsStoreSize>
  107. </RequestPrioritization>
  108. <Port>0</Port>
  109. <InstanceVisible>1</InstanceVisible>
  110. <EnableFast1033Locale>0</EnableFast1033Locale>
  111. <ServerThreadLocale>0</ServerThreadLocale>
  112. <Log>
  113. <File>msmdsrv.log</File>
  114. <FileBufferSize>0</FileBufferSize>
  115. <MessageLogs>File;Console;System</MessageLogs>
  116. <ErrorLog>
  117. <ErrorLogFileName/>
  118. <ErrorLogFileSize>4</ErrorLogFileSize>
  119. <KeyErrorAction>0</KeyErrorAction>
  120. <KeyErrorLogFile/>
  121. <KeyErrorLimit>0</KeyErrorLimit>
  122. <KeyErrorLimitAction>0</KeyErrorLimitAction>
  123. <LogErrorTypes>
  124. <KeyNotFound>1</KeyNotFound>
  125. <KeyDuplicate>0</KeyDuplicate>
  126. <NullKeyConvertedToUnknown>0</NullKeyConvertedToUnknown>
  127. <NullKeyNotAllowed>1</NullKeyNotAllowed>
  128. <CalculationError>0</CalculationError>
  129. </LogErrorTypes>
  130. <IgnoreDataTruncation>0</IgnoreDataTruncation>
  131. </ErrorLog>
  132. <QueryLog>
  133. <QueryLogSampling>10</QueryLogSampling>
  134. <QueryLogFileName/>
  135. <QueryLogFileSize>4</QueryLogFileSize>
  136. <QueryLogConnectionString>[EncryptedDataStart]CAAAAAAAAAAZZmP6W9MZgDorGonIpAdE
  137. [EncryptedDataEnd]</QueryLogConnectionString>
  138. <QueryLogTableName>OlapQueryLog</QueryLogTableName>
  139. <CreateQueryLogTable>0</CreateQueryLogTable>
  140. <UBOMaxQueries>100</UBOMaxQueries>
  141. </QueryLog>
  142. <Exception>
  143. <CreateAndSendCrashReports>1</CreateAndSendCrashReports>
  144. <CrashReportsFolder/>
  145. <SQLDumperFlagsOn>0x0</SQLDumperFlagsOn>
  146. <SQLDumperFlagsOff>0x0</SQLDumperFlagsOff>
  147. <MiniDumpFlagsOn>0x0</MiniDumpFlagsOn>
  148. <MiniDumpFlagsOff>0x0</MiniDumpFlagsOff>
  149. <MinidumpErrorList>0xC1000000, 0xC1000001, 0xC102003F, 0xC1360054, 0xC1360055</MinidumpErrorList>
  150. <ExceptionHandlingMode>0</ExceptionHandlingMode>
  151. <CriticalErrorHandling>1</CriticalErrorHandling>
  152. <MaxExceptions>500</MaxExceptions>
  153. <MaxDuplicateDumps>1</MaxDuplicateDumps>
  154. </Exception>
  155. <Trace>
  156. <TraceMaxRowsetSize>1000000</TraceMaxRowsetSize>
  157. <TraceBackgroundDistributionPeriod>2000</TraceBackgroundDistributionPeriod>
  158. <TraceBackgroundFlushPeriod>2000</TraceBackgroundFlushPeriod>
  159. <TraceRowsetBackgroundFlushPeriod>500</TraceRowsetBackgroundFlushPeriod>
  160. <TraceFileBufferSize>12000</TraceFileBufferSize>
  161. <TraceFileWriteTrailerPeriod>300000</TraceFileWriteTrailerPeriod>
  162. <TraceQueryResponseTextChunkSize>8192</TraceQueryResponseTextChunkSize>
  163. <TraceReportFQDN>0</TraceReportFQDN>
  164. <TraceRequestParameters>1</TraceRequestParameters>
  165. <TraceProtocolTraffic>0</TraceProtocolTraffic>
  166. </Trace>
  167. <FlightRecorder>
  168. <Enabled>1</Enabled>
  169. <FileSizeMB>10</FileSizeMB>
  170. <LogDurationSec>3600</LogDurationSec>
  171. <SnapshotFrequencySec>120</SnapshotFrequencySec>
  172. <TraceDefinitionFile/>
  173. <SnapshotDefinitionFile/>
  174. </FlightRecorder>
  175. </Log>
  176. <Memory>
  177. <MemoryHeapType>1</MemoryHeapType>
  178. <HeapTypeForObjects>1</HeapTypeForObjects>
  179. <HardMemoryLimit>0</HardMemoryLimit>
  180. <TotalMemoryLimit>80</TotalMemoryLimit>
  181. <LowMemoryLimit>65</LowMemoryLimit>
  182. <MidMemoryPrice>10</MidMemoryPrice>
  183. <HighMemoryPrice>1000</HighMemoryPrice>
  184. <VirtualMemoryLimit>80</VirtualMemoryLimit>
  185. <SessionMemoryLimit>50</SessionMemoryLimit>
  186. <MinimumAllocatedMemory>25</MinimumAllocatedMemory>
  187. <WaitCountIfHighMemory>10</WaitCountIfHighMemory>
  188. <DefaultPagesCountToReuse>2</DefaultPagesCountToReuse>
  189. <HandleIA64AlignmentFaults>0</HandleIA64AlignmentFaults>
  190. <PreAllocate>0</PreAllocate>
  191. <PagePoolRestrictNumaNode>0</PagePoolRestrictNumaNode>
  192. </Memory>
  193. <FileStore>
  194. <MemoryLimitMin>0</MemoryLimitMin>
  195. <MemoryLimit>90</MemoryLimit>
  196. <UnbufferedThreshold>0</UnbufferedThreshold>
  197. <PerformanceTrace>0</PerformanceTrace>
  198. <PercentScanPerPrice>0.1</PercentScanPerPrice>
  199. <MemoryModel>
  200. <Tax>5</Tax>
  201. <Income>1</Income>
  202. <MaximumBalance>1000000</MaximumBalance>
  203. <MinimumBalance>-300000</MinimumBalance>
  204. <InitialBonus>2</InitialBonus>
  205. </MemoryModel>
  206. </FileStore>
  207. <CoordinatorExecutionMode>-4</CoordinatorExecutionMode>
  208. <CoordinatorShutdownMode>0</CoordinatorShutdownMode>
  209. <FilteredDumpMode>0</FilteredDumpMode>
  210. <CoordinatorCancelCount>1000</CoordinatorCancelCount>
  211. <CoordinatorBuildMaxThreads>4</CoordinatorBuildMaxThreads>
  212. <CoordinatorQueryMaxThreads>16</CoordinatorQueryMaxThreads>
  213. <CoordinatorQueryBalancingFactor>-1</CoordinatorQueryBalancingFactor>
  214. <CoordinatorQueryBoostPriorityLevel>3</CoordinatorQueryBoostPriorityLevel>
  215. <LockManager>
  216. <DefaultLockTimeoutMS>-1</DefaultLockTimeoutMS>
  217. <LockWaitGranularityMS>5000</LockWaitGranularityMS>
  218. <DeadlockDetectionGranularityMS>30000</DeadlockDetectionGranularityMS>
  219. </LockManager>
  220. <OLAP>
  221. <Memory>
  222. <DefaultPageSizeForData>65536</DefaultPageSizeForData>
  223. <DefaultPageSizeForDataHeader>8192</DefaultPageSizeForDataHeader>
  224. <DefaultPageSizeForIndex>8192</DefaultPageSizeForIndex>
  225. <DefaultPageSizeForIndexHeader>8192</DefaultPageSizeForIndexHeader>
  226. <DefaultPageSizeForString>65536</DefaultPageSizeForString>
  227. <DefaultPageSizeForHash>8192</DefaultPageSizeForHash>
  228. <DefaultPageSizeForProp>8192</DefaultPageSizeForProp>
  229. </Memory>
  230. <LazyProcessing>
  231. <Enabled>1</Enabled>
  232. <SleepIntervalSecs>5</SleepIntervalSecs>
  233. <MaxCPUUsage>0.5</MaxCPUUsage>
  234. <MaxObjectsInParallel>2</MaxObjectsInParallel>
  235. <MaxRetries>3</MaxRetries>
  236. </LazyProcessing>
  237. <ProcessPlan>
  238. <MemoryLimit>65</MemoryLimit>
  239. <MemoryLimitErrorEnabled>1</MemoryLimitErrorEnabled>
  240. <MemoryAdjustConst>1000000</MemoryAdjustConst>
  241. <MemoryAdjustFactor>1</MemoryAdjustFactor>
  242. <CacheRowsetRows>65536</CacheRowsetRows>
  243. <CacheRowsetToDisk>1</CacheRowsetToDisk>
  244. <ForceMultiPass>0</ForceMultiPass>
  245. <DistinctBuffer>0x10000</DistinctBuffer>
  246. <OptimizeSchema>0x1</OptimizeSchema>
  247. <MaxTableDepth>0x100</MaxTableDepth>
  248. <EnableTableGrouping>0</EnableTableGrouping>
  249. <EnableRolapDimQueryTableGrouping>1</EnableRolapDimQueryTableGrouping>
  250. </ProcessPlan>
  251. <ProactiveCaching>
  252. <DimensionLatencyAccuracy>5</DimensionLatencyAccuracy>
  253. <PartitionLatencyAccuracy>60</PartitionLatencyAccuracy>
  254. <DefaultRefreshInterval>60</DefaultRefreshInterval>
  255. </ProactiveCaching>
  256. <Process>
  257. <CheckDistinctRecordSortOrder>1</CheckDistinctRecordSortOrder>
  258. <RecordsReportGranularity>10000</RecordsReportGranularity>
  259. <BufferMemoryLimit>60</BufferMemoryLimit>
  260. <BufferRecordLimit>1048576</BufferRecordLimit>
  261. <CacheRecordLimit>0</CacheRecordLimit>
  262. <AggregationMemoryLimitMin>10</AggregationMemoryLimitMin>
  263. <AggregationMemoryLimitMax>80</AggregationMemoryLimitMax>
  264. <PropertyBufferRecordLimitEnabled>0</PropertyBufferRecordLimitEnabled>
  265. <AggregationNewAlgo>1</AggregationNewAlgo>
  266. <AggregationPerfLog2>0</AggregationPerfLog2>
  267. <MapFormatMask>0x10100100</MapFormatMask>
  268. <DeepCompressValue>1</DeepCompressValue>
  269. <DataPlacementOptimization>0</DataPlacementOptimization>
  270. <DimensionPropertyKeyCache>1</DimensionPropertyKeyCache>
  271. <DimensionPropertyKeyCacheLimit>0</DimensionPropertyKeyCacheLimit>
  272. <DimensionPropertyShortPath>1</DimensionPropertyShortPath>
  273. <AggIndexBuildThreshold>65536</AggIndexBuildThreshold>
  274. <IndexBuildThreshold>4096</IndexBuildThreshold>
  275. <IndexBuildEnabled>1</IndexBuildEnabled>
  276. <AggregationsBuildEnabled>1</AggregationsBuildEnabled>
  277. <DataSliceInitEnabled>1</DataSliceInitEnabled>
  278. <DataFileInitEnabled>0</DataFileInitEnabled>
  279. <IndexFileInitEnabled>0</IndexFileInitEnabled>
  280. <DatabaseConnectionPoolMax>50</DatabaseConnectionPoolMax>
  281. <DatabaseConnectionPoolTimeout>120000</DatabaseConnectionPoolTimeout>
  282. <DatabaseConnectionPoolConnectTimeout>60</DatabaseConnectionPoolConnectTimeout>
  283. <DatabaseConnectionPoolGeneralTimeout>60</DatabaseConnectionPoolGeneralTimeout>
  284. <ROLAPDimensionProcessingEffort>300000</ROLAPDimensionProcessingEffort>
  285. </Process>
  286. <Query>
  287. <CalculationEvaluationPolicy>4</CalculationEvaluationPolicy>
  288. <CalculationAdvancedEvaluatorDisableMask>0</CalculationAdvancedEvaluatorDisableMask>
  289. <QueryOptimizerRatio>-1</QueryOptimizerRatio>
  290. <QueryOptimizerPolicy>1</QueryOptimizerPolicy>
  291. <SpaceDecomposition>8</SpaceDecomposition>
  292. <CalculationCoverPolicy>0</CalculationCoverPolicy>
  293. <NonEmptyBehaviorMode>1</NonEmptyBehaviorMode>
  294. <CalculationPassMode>0</CalculationPassMode>
  295. <CalculationPrefetchLocality>
  296. <ApplyIntersect>1</ApplyIntersect>
  297. <ApplySubtract>1</ApplySubtract>
  298. <PrefetchLowerGranularities>1</PrefetchLowerGranularities>
  299. </CalculationPrefetchLocality>
  300. <PreciseSubtract>0</PreciseSubtract>
  301. <LookupNormalizedSubcubeSlices>0</LookupNormalizedSubcubeSlices>
  302. <UseCalculationCacheRegistry>1</UseCalculationCacheRegistry>
  303. <UseDataCacheRegistry>1</UseDataCacheRegistry>
  304. <UseDataCacheFreeLastPageMemory>1</UseDataCacheFreeLastPageMemory>
  305. <UseDataCacheRegistryMultiplyKey>1</UseDataCacheRegistryMultiplyKey>
  306. <UseDataCacheRegistryHashTable>1</UseDataCacheRegistryHashTable>
  307. <DataCacheRegistryMaxIterations>1000</DataCacheRegistryMaxIterations>
  308. <CalculationCacheRegistryMaxIterations>100</CalculationCacheRegistryMaxIterations>
  309. <DataStorePageSize>8192</DataStorePageSize>
  310. <DataStoreHashPageSize>8192</DataStoreHashPageSize>
  311. <DataStoreStringPageSize>65536</DataStoreStringPageSize>
  312. <AllowPresizeHashTable>1</AllowPresizeHashTable>
  313. <DataCache>
  314. <MemoryModel>
  315. <Tax>5</Tax>
  316. <Income>1</Income>
  317. <MaximumBalance>1000000</MaximumBalance>
  318. <MinimumBalance>-300000</MinimumBalance>
  319. <InitialBonus>2</InitialBonus>
  320. </MemoryModel>
  321. </DataCache>
  322. <CachedPageAlloc>
  323. <MemoryModel>
  324. <Tax>5</Tax>
  325. <Income>1</Income>
  326. <MaximumBalance>100000</MaximumBalance>
  327. <MinimumBalance>-30000</MinimumBalance>
  328. <InitialBonus>2</InitialBonus>
  329. </MemoryModel>
  330. </CachedPageAlloc>
  331. <CellStore>
  332. <MemoryModel>
  333. <Tax>5</Tax>
  334. <Income>2</Income>
  335. <MaximumBalance>1000000</MaximumBalance>
  336. <MinimumBalance>-300000</MinimumBalance>
  337. <InitialBonus>4</InitialBonus>
  338. </MemoryModel>
  339. </CellStore>
  340. <CopyLinkedDataCacheAndRegistry>0</CopyLinkedDataCacheAndRegistry>
  341. <UseDataSlice>1</UseDataSlice>
  342. <IndexUseEnabled>1</IndexUseEnabled>
  343. <AggregationsUseEnabled>1</AggregationsUseEnabled>
  344. <DefaultDrillthroughMaxRows>10000</DefaultDrillthroughMaxRows>
  345. <MapHandleAlgorithm>3</MapHandleAlgorithm>
  346. <UseMaterializedIterators>1</UseMaterializedIterators>
  347. <MaxRolapOrConditions>150</MaxRolapOrConditions>
  348. <ExpressNonEmptyUseEnabled>1</ExpressNonEmptyUseEnabled>
  349. <UseSinglePassForDimSecurityAutoExist>1</UseSinglePassForDimSecurityAutoExist>
  350. <ConvertDeletedToUnknown>0</ConvertDeletedToUnknown>
  351. <DimensionPropertyCacheSize>4000000</DimensionPropertyCacheSize>
  352. <AllowSEFiltering>1</AllowSEFiltering>
  353. <AllowOptimizedResponse>1</AllowOptimizedResponse>
  354. <IgnoreNullRolapRows>1</IgnoreNullRolapRows>
  355. <UseVBANet>1</UseVBANet>
  356. <EnableRolapOptimization>0</EnableRolapOptimization>
  357. <DisableStrongAttributeRelationships>0</DisableStrongAttributeRelationships>
  358. <CalculatedVisualTotalStyleForSubselects>0</CalculatedVisualTotalStyleForSubselects>
  359. <EnableCalculatedMemberUsageForCalculationLRU>1</EnableCalculatedMemberUsageForCalculationLRU>
  360. <CalculationLRUSize>20</CalculationLRUSize>
  361. <CalculationLRUMinSize>60</CalculationLRUMinSize>
  362. <CalculationLRUMaxSize>3000</CalculationLRUMaxSize>
  363. <DisableDCSliceIndex>0x0</DisableDCSliceIndex>
  364. <DCSliceIndexThreshold>0</DCSliceIndexThreshold>
  365. <DisablePrefetchForOutlineCalcs>0x0</DisablePrefetchForOutlineCalcs>
  366. <DisableFusionOfStorageEngineSubspaces>0x0</DisableFusionOfStorageEngineSubspaces>
  367. <DisableCalcExpressNonEmpty>0</DisableCalcExpressNonEmpty>
  368. <ComplexSlice>
  369. <Enabled>1</Enabled>
  370. <MaxAttributesForPartitions>5</MaxAttributesForPartitions>
  371. <MaxAttributesForDimensions>5</MaxAttributesForDimensions>
  372. <AttributeProjectionRatio>10</AttributeProjectionRatio>
  373. <MaxSets>5</MaxSets>
  374. <MaxCells>10000</MaxCells>
  375. </ComplexSlice>
  376. <AggregateHybridPlan>1</AggregateHybridPlan>
  377. <SpaceEvaluatorPlan>0</SpaceEvaluatorPlan>
  378. <DimensionCacheLookupMode>0</DimensionCacheLookupMode>
  379. <NamedSetShallowExistsMode>0</NamedSetShallowExistsMode>
  380. <AxisSetShallowExistsMode>0</AxisSetShallowExistsMode>
  381. <MdxSubqueries>15</MdxSubqueries>
  382. <FactPrefetchMode>0</FactPrefetchMode>
  383. <LazyEnabled>0</LazyEnabled>
  384. </Query>
  385. <Jobs>
  386. <ProcessProperty>
  387. <MemoryModel>
  388. <Tax>5</Tax>
  389. <Income>1</Income>
  390. <MaximumBalance>1000000</MaximumBalance>
  391. <MinimumBalance>-300000</MinimumBalance>
  392. <InitialBonus>2</InitialBonus>
  393. </MemoryModel>
  394. </ProcessProperty>
  395. <ProcessPartition>
  396. <MemoryModel>
  397. <Tax>5</Tax>
  398. <Income>100</Income>
  399. <MaximumBalance>1000000000</MaximumBalance>
  400. <MinimumBalance>-3000000</MinimumBalance>
  401. <InitialBonus>0.01</InitialBonus>
  402. </MemoryModel>
  403. </ProcessPartition>
  404. <ProcessAggregation>
  405. <MemoryModel>
  406. <Tax>5</Tax>
  407. <Income>50</Income>
  408. <MaximumBalance>1000000000</MaximumBalance>
  409. <MinimumBalance>-3000000</MinimumBalance>
  410. <InitialBonus>0.01</InitialBonus>
  411. </MemoryModel>
  412. </ProcessAggregation>
  413. </Jobs>
  414. </OLAP>
  415. <Feature>
  416. <ManagedCodeEnabled>1</ManagedCodeEnabled>
  417. <LinkInsideInstanceEnabled>1</LinkInsideInstanceEnabled>
  418. <LinkToOtherInstanceEnabled>0</LinkToOtherInstanceEnabled>
  419. <LinkFromOtherInstanceEnabled>0</LinkFromOtherInstanceEnabled>
  420. <ConnStringEncryptionEnabled>1</ConnStringEncryptionEnabled>
  421. <UseCachedPageAllocators>0</UseCachedPageAllocators>
  422. <ComUdfEnabled>0</ComUdfEnabled>
  423. <SQMSupportEnabled>1</SQMSupportEnabled>
  424. </Feature>
  425. <AllowCLRStoredProcedureCallsInFiberMode>0</AllowCLRStoredProcedureCallsInFiberMode>
  426. <DataMining>
  427. <AllowSessionMiningModels>0</AllowSessionMiningModels>
  428. <AllowAdHocOpenRowsetQueries>0</AllowAdHocOpenRowsetQueries>
  429. <AllowedProvidersInOpenRowset/>
  430. <MaxConcurrentPredictionQueries>0</MaxConcurrentPredictionQueries>
  431. <MaxTimeSeriesPredictionCacheSize>150000</MaxTimeSeriesPredictionCacheSize>
  432. <Algorithms>
  433. <Microsoft_Association_Rules>
  434. <Enabled>1</Enabled>
  435. </Microsoft_Association_Rules>
  436. <Microsoft_Clustering>
  437. <Enabled>1</Enabled>
  438. </Microsoft_Clustering>
  439. <Microsoft_Decision_Trees>
  440. <Enabled>1</Enabled>
  441. </Microsoft_Decision_Trees>
  442. <Microsoft_Naive_Bayes>
  443. <Enabled>1</Enabled>
  444. </Microsoft_Naive_Bayes>
  445. <Microsoft_Neural_Network>
  446. <Enabled>1</Enabled>
  447. </Microsoft_Neural_Network>
  448. <Microsoft_Sequence_Clustering>
  449. <Enabled>1</Enabled>
  450. </Microsoft_Sequence_Clustering>
  451. <Microsoft_Time_Series>
  452. <Enabled>1</Enabled>
  453. </Microsoft_Time_Series>
  454. <Microsoft_Linear_Regression>
  455. <Enabled>1</Enabled>
  456. </Microsoft_Linear_Regression>
  457. <Microsoft_Logistic_Regression>
  458. <Enabled>1</Enabled>
  459. </Microsoft_Logistic_Regression>
  460. </Algorithms>
  461. <Services>
  462. <MicrosoftAssociationRules>
  463. <ProgID>8E8A3C1F-DB79-4cbf-814F-C3C7EA632D7B</ProgID>
  464. <MinimumSupport>0</MinimumSupport>
  465. <MaximumSupport>1</MaximumSupport>
  466. <MinimumItemsetSize>0</MinimumItemsetSize>
  467. <MaximumItemsetSize>3</MaximumItemsetSize>
  468. <MaximumItemsetCount>200000</MaximumItemsetCount>
  469. <MinimumProbability>0.4</MinimumProbability>
  470. <MinimumImportance>-999999999</MinimumImportance>
  471. <OptimizedPredictionCount>0</OptimizedPredictionCount>
  472. <AutodetectMinimumSupport>0</AutodetectMinimumSupport>
  473. </MicrosoftAssociationRules>
  474. <MicrosoftClustering>
  475. <ProgID>FE8EF196-F59A-492d-A723-8E0C0332CF85</ProgID>
  476. <ClusteringMethod>1</ClusteringMethod>
  477. <ClusterCount>10</ClusterCount>
  478. <MinimumSupport>1</MinimumSupport>
  479. <ModellingCardinality>10</ModellingCardinality>
  480. <StoppingTolerance>10</StoppingTolerance>
  481. <SampleSize>50000</SampleSize>
  482. <MaximumInputAttributes>255</MaximumInputAttributes>
  483. <MaximumStates>100</MaximumStates>
  484. <MinimumClusterCases>1</MinimumClusterCases>
  485. <ClusterCountDeviation>10</ClusterCountDeviation>
  486. <ClusterCountPrior>10</ClusterCountPrior>
  487. <Normalization>1</Normalization>
  488. </MicrosoftClustering>
  489. <MicrosoftDecisionTrees>
  490. <ProgID>F39BEF7F-5EE9-453b-A6B8-ED1E0FBB731B</ProgID>
  491. <MaximumInputAttributes>255</MaximumInputAttributes>
  492. <MaximumOutputAttributes>255</MaximumOutputAttributes>
  493. <ScoreMethod>4</ScoreMethod>
  494. <SplitMethod>3</SplitMethod>
  495. <MinimumLeafCases>10</MinimumLeafCases>
  496. <MinimumSupport>10</MinimumSupport>
  497. <ComplexityPenalty>0</ComplexityPenalty>
  498. <MaximumBucketsForContinuousSplit>10</MaximumBucketsForContinuousSplit>
  499. <ForceMaximumBucketsForContinuousSplit>0</ForceMaximumBucketsForContinuousSplit>
  500. <MaximumContinuousInputAttributes>50</MaximumContinuousInputAttributes>
  501. <ForceRegressor/>
  502. <AcyclicGraph/>
  503. </MicrosoftDecisionTrees>
  504. <MicrosoftNaiveBayes>
  505. <ProgID>E884B4C5-4F70-4e28-B97C-82BBC1DB4EFB</ProgID>
  506. <MaximumInputAttributes>255</MaximumInputAttributes>
  507. <MaximumOutputAttributes>255</MaximumOutputAttributes>
  508. <MaximumStates>100</MaximumStates>
  509. <MinimumDependencyProbability>0.5</MinimumDependencyProbability>
  510. </MicrosoftNaiveBayes>
  511. <MicrosoftSequenceClustering>
  512. <ProgID>02F4DB41-AD83-412a-8DCA-E4760D61C087</ProgID>
  513. <ClusterCount>10</ClusterCount>
  514. <MinimumSupport>10</MinimumSupport>
  515. <MaximumStates>100</MaximumStates>
  516. <MaximumSequenceStates>64</MaximumSequenceStates>
  517. <HoldoutMethod>Uniform</HoldoutMethod>
  518. <MinimumClusterCases>10</MinimumClusterCases>
  519. </MicrosoftSequenceClustering>
  520. <MicrosoftTimeSeries>
  521. <ProgID>D598EB8C-D1A9-42a3-AFAD-5ECD590C6333</ProgID>
  522. <MinimumSupport>10</MinimumSupport>
  523. <ComplexityPenalty>0.1</ComplexityPenalty>
  524. <PeriodicityHint>{1}</PeriodicityHint>
  525. <HistoricModelCount>1</HistoricModelCount>
  526. <HistoricModelGap>10</HistoricModelGap>
  527. <MissingValueSubstitution>None</MissingValueSubstitution>
  528. <AutoDetectPeriodicity>0.6</AutoDetectPeriodicity>
  529. <MinimumSeriesValue>-1E+308</MinimumSeriesValue>
  530. <MaximumSeriesValue>1E+308</MaximumSeriesValue>
  531. <MinimumLeafCases>10</MinimumLeafCases>
  532. <PredictionSmoothing>0.5</PredictionSmoothing>
  533. <ArimaAROrder>-1</ArimaAROrder>
  534. <ArimaDifferenceOrder>-1</ArimaDifferenceOrder>
  535. <ArimaMAOrder>-1</ArimaMAOrder>
  536. <InstabilityCutoffWeight>1</InstabilityCutoffWeight>
  537. <ForecastMethod>MIXED</ForecastMethod>
  538. </MicrosoftTimeSeries>
  539. <MicrosoftNeuralNetwork>
  540. <ProgID>0769A20B-0F45-4b55-93E0-0EA08B1E49A7</ProgID>
  541. <HoldoutPercentage>30</HoldoutPercentage>
  542. <HoldoutSeed>0</HoldoutSeed>
  543. <MaximumInputAttributes>255</MaximumInputAttributes>
  544. <MaximumOutputAttributes>255</MaximumOutputAttributes>
  545. <MaximumStates>100</MaximumStates>
  546. <SampleSize>10000</SampleSize>
  547. <HiddenNodeRatio>4</HiddenNodeRatio>
  548. <HoldoutTolerance>0.001</HoldoutTolerance>
  549. <BrentTolerance>0.1</BrentTolerance>
  550. </MicrosoftNeuralNetwork>
  551. <MicrosoftLinearRegression>
  552. <ProgID>4E954761-41EC-4fb4-858F-20E09F3149CF</ProgID>
  553. <MaximumInputAttributes>255</MaximumInputAttributes>
  554. <MaximumOutputAttributes>255</MaximumOutputAttributes>
  555. <ForceRegressor/>
  556. </MicrosoftLinearRegression>
  557. <MicrosoftLogisticRegression>
  558. <ProgID>2ACC1917-A984-403f-B710-8981F6BF125B</ProgID>
  559. <HoldoutPercentage>30</HoldoutPercentage>
  560. <HoldoutSeed>0</HoldoutSeed>
  561. <MaximumInputAttributes>255</MaximumInputAttributes>
  562. <MaximumOutputAttributes>255</MaximumOutputAttributes>
  563. <MaximumStates>100</MaximumStates>
  564. <SampleSize>10000</SampleSize>
  565. <HoldoutTolerance>0.001</HoldoutTolerance>
  566. <BrentTolerance>0.1</BrentTolerance>
  567. </MicrosoftLogisticRegression>
  568. </Services>
  569. </DataMining>
  570. <DSO>
  571. <RemoteRepositoryConnectionString>[EncryptedDataStart]CAAAAAAAAABBBkIIEu9ceW7cQ1ZScAMi
  572. [EncryptedDataEnd]</RemoteRepositoryConnectionString>
  573. <RepositoryConnectionString>[EncryptedDataStart]CAAAAAAAAADFpdE6FFYBSAoXn3mTVizy
  574. [EncryptedDataEnd]</RepositoryConnectionString>
  575. <RemoteLocksDirectory/>
  576. <LocksDirectory/>
  577. </DSO>
  578. <LimitSystemFileCacheSizeMB>0</LimitSystemFileCacheSizeMB>
  579. <LimitSystemFileCachePeriod>1000</LimitSystemFileCachePeriod>
  580. <VertiPaq>
  581. <ThreadPool>
  582. <CPUs>0</CPUs>
  583. </ThreadPool>
  584. <VertiPaqMinWSQuota>20</VertiPaqMinWSQuota>
  585. <DefaultSegmentRowCount>1048576</DefaultSegmentRowCount>
  586. <ProcessingTimeboxEnabled>1</ProcessingTimeboxEnabled>
  587. <SEQueryTraceMaxList>10</SEQueryTraceMaxList>
  588. <SEQueryRewriteBehavior>0</SEQueryRewriteBehavior>
  589. </VertiPaq>
  590. </ConfigurationSettings>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement