Hp ProLiant DL980 G7 Server Uživatelský manuál stáhnout pdf (Strana 8)

• Data Warehouse (DW) / Business Intelligence (BI) identification and support

User interface for entering login credentials for DW and BI instances◦

◦ Recommendations for optimized settings for the following parameters in DW instances

and databases, based on monitored workload:

– Max Degree of Parallelism (MAXDOP)

– Max Worker Threads

– Startup options (trace flags) T834, T8048, T1117, and T1118

◦ Recommendations for optimized settings for the following parameters in SQL Server

Analysis Services (SSAS) instances, based on monitored workload:

– Resource Monitor

– RandomFileAccessMode

– FlightRecorder

– Enable ROLAP Distinct Count On DataSource

– Coordinator Query Balancing Factor

– CordinatorQueryBoostPriorityLevel

– MemoryLimit (Low/Total)

– Analysis Services Process GroupAffinity (only for SQL Server 2012 Analysis Services)

◦ Recommendations for optimized storage settings for the following parameters in DW

instances:

– Database file autogrowth (Growth)

– Storage layout of database files

◦ Recommendations for optimized storage settings for the following parameters in SSAS

instances:

– DataDir, LogDir, and TempDir

– Custom storage location of databases

– Partition information such as Proactive Caching, Estimated Rows, Estimated Size

• SAP Database Engine identification and support

Recommendations for optimized settings for the following parameters in databases, based

on monitored workload:

◦

– Max Degree of Parallelism (MAXDOP)

– Checkpoint

– Xp_CmdShell

– Startup options (trace flags) T1117, T1118, T2371, T2549, and T2562

– Database auto create/update/async statistics

◦ Recommendations for optimized storage settings for the following parameters:

– Database file autogrowth (Growth)

– Storage layout of database files

• Improved response times for page loading, saving, and rollback

8 Introduction

1 2 3 4 5 6 7 8 9 10 11 12 13 ... 80 81

Žádné komentáře

Hp ProLiant DL980 G7 Server Uživatelský manuál Strana 8