Using SQL Server 2012 Column-Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com

Administration

Configuring Resources

To ensure optimal system performance, you have to give sufficient system resources to SQL Server. The

most important resources are memory and CPU. For using the column-store with SAP BW, you should have

a database server with at least eight CPU threads (for example, 2 CPUs having 4 cores per CPU). In typical

customer scenarios, the database server has 16 CPU threads or more.

SQL Server memory

SQL Server memory manager dynamically allocates memory used for the column-store. An administrator

only has to make sure that the total memory configured for SQL Server is sufficient. Normal tables and b-tree

indexes allocate memory from SQL Server Buffer Pool. The column-store uses its own memory pool, the

Column Store Object Pool. You can check the size of both pools by running the following SQL command:

 select * from sys.dm_os_memory_broker_clerks

The query returns 2 rows containing the total size of both pools (or only one row for the Buffer Pool, if the

Column Store Object Pool is not used at all).

As of SQL Server 2012, the configuration options min and max server memory contain all memory used by

SQL Server, not only the Buffer Pool. For more information about SQL Server 2012 memory configuration for

SAP systems, see SAP note 1702408.

SQL Server parallelism

SAP recommends setting the global SQL Server configuration option max degree of parallelism to 1. SAP

BW overwrites this global setting by means of SQL Server optimizer hints. Per default, SAP BW requests two

SQL Server threads per query and eight SQL Server threads for index creation. However, you can change

the default behavior by setting RSADMIN parameters:

 MSS_MAXDOP_INDEXING

This RSADMIN parameter sets the maximum number of CPU threads that are used during index

creation in SAP BW (for column-store indexes and b-trees). Index creation is performed when

originally creating the column-store index, during BW process chains, and during cube compression.

The default value of MSS_MAXDOP_INDEXING is 8. SAP does not recommend decreasing this

value. However, you may want to increase it, if your database server has more than 16 CPU threads.

 MSS_MAXDOP_QUERY

This RSADMIN parameter sets the maximum number of CPU threads that are used for a single SQL

query as part of a BW query. The default value of MSS_MAXDOP_INDEXING is 2. The degree of

parallelism was chosen relatively low, since a single BW query typically results in many parallel

running SQL queries. You may want to increase MSS_MAXDOP_QUERY (to 3, 4 or 6), if your

database server has more than 16 CPU threads. However, you should never decrease it below 2.

The easiest way to set a RSADMIN parameter is to use SAP report SAP_RSADMIN_MAINTAIN. SAP

strongly recommends using this report, because table RSADMIN is buffered on the SAP application servers.

1 2 ... 11 12 13 14 15 16 17 18 19

Komentarze do niniejszej Instrukcji

Brak uwag

Samsung UN40D5003 manuels

Manuels d'utilisation et guides de l'utilisateur pour Télévisions LED Samsung UN40D5003.
Nous fournissons des manuels en pdf 1 Samsung UN40D5003 à télécharger gratuitement par type de document : Manuel de l'utilisateur

Samsung UN40D5003 Manuel de l'utilisateur (35 pages)

marque: Samsung | Catégorie: LED TVs | Taille: 10.37 MB |

Table des matières

User Manual

Still image warning

Contents

Getting Started

01 Getting Started

Viewing the Control Panel

ConnectionsConnections

02 Connections

Connections

Channel List

Basic Features

03 Basic Features

¦ Setting the Time

¦ Using the Sleep Timer

¦ Setting the On/Off Timer

¦ Other Features

Advanced Features

Photo Music Setup

Other Information

05 Other Information

¦ License

Plus de produits et de manuels pour Télévisions LED Samsung

Modèles	Type de document
UE26EH4500W	Manuel Samsung UE40ES5700S Benutzerhandbuch, 933 pages
PS51F5500AK	Guide de l'utilisateur Samsung PS51F5500AK 51" Full HD 3D compatibility Smart TV Black, 198 pages
UN32D4003	Manuel de l'utilisateur Samsung UN32D4003, 35 pages
HG46NB890XF	Manuel d'installation Samsung HG46NB890XF 46" Full HD 3D compatibility Smart TV Wi-Fi Black, 52 pages
UN65HU9000F	Spécifications Samsung UN55HU9000F 55" 4K Ultra HD 3D compatibility Smart TV Wi-Fi Black, 245 pages
UN55FH6200F	Manuel de l'utilisateur Samsung UN55FH6200F 54.6" Full HD Smart TV Wi-Fi Black LED TV, 677 pages
UE32H4000AK	Manuel de l'utilisateur Samsung UE48H5003AW User manual [en] [pt] , 125 pages
UN60EH6000F	Manuel Samsung UN60EH6000F, 8 pages
UA46D7000	Spécifications Samsung UA46D7000 LED TV, 280 pages
UN50EH6000F	Manuel de l'utilisateur Samsung UN50EH6000F, 16 pages
UN32D4003BD	Manuel de l'utilisateur Samsung UN32D4003BD, 64 pages
HG32NA470GF	Manuel d'installation Samsung HG39NA578CF, 43 pages
HG55EA790MSXZT	Manuel d'installation Samsung HG55EA790MSXZT 55" Full HD 3D compatibility Smart TV Black LED TV, 77 pages
UN50EH5000F	Manuel de l'utilisateur Samsung UN50EH5000F, 16 pages
UN55HU8550F	Spécifications Samsung UN55HU8550F 54.6" 4K Ultra HD 3D compatibility Smart TV Wi-Fi Black, Silver, 231 pages
UN55FH6200	Manuel de l'utilisateur Samsung UN50ES6500F 49.5" Full HD 3D compatibility Smart TV Black, 675 pages
UN39FH5000F	Spécifications Samsung UN39FH5000F, 4 pages
UN40EH5000F	Manuel de l'utilisateur Samsung UN40EH5000F 40" Full HD Black, 2 pages
UA32D4000	Spécifications Samsung UA32D4000 LED TV, 176 pages
UE55F6800SS	Manuel Samsung UE55F6800SS 55" Full HD 3D compatibility Smart TV Wi-Fi Black, 194 pages

Dynamic Precision BPC 7.3 Instrukcja Użytkownika Strona 16

Komentarze do niniejszej Instrukcji

Samsung UN40D5003 manuels

Samsung UN40D5003 Manuel de l'utilisateur (35 pages)

Table des matières

Plus de produits et de manuels pour Télévisions LED Samsung