Database Server Sizing

IT Asset Management (Cloud)

The database server runs an instance of SQL Server to host the IT Asset Management database, the Cognos content store, and the data warehouse. The following guidelines are based on sizing a server that will not host other databases. If the planned server is expected to host databases for other products, its sizing should be increased appropriately to cope with the expected additional resource requirements of those products. The assumption is that, on average, an SAP user has 30-50 rows of consumption per month (number of transactions used).

Table 1. Database server sizing

Resource	Recommendation	Comments
Processors	1 x quad-core CPU per 10 concurrent users	Processor resources are used to service concurrent database queries stemming from remote consoles, report generation and importing inventory data.
Memory	2 GB per 100,000 SAP user accounts	Key IT Asset Management functions whose performance may be affected by the amount of memory available to SQL Server are the inventory import, loading of data for console views, and generation of reports. Although it is possible for SQL Server to service all of these functions using a minimal amount of memory, memory should be sized to ensure a significant proportion of the inventory data in the IT Asset Management database and temporary database can be cached in RAM, so that paging is minimized.
System Drive	40 GB	Allow 10 GB for IT Asset Management components on top of base operating system requirements.
Data Drives	IT Asset Management database data: 10 GB for IT Asset Management system data, plus 5 GB per 100,000 SAP user accounts IT Asset Management database logs: 50 GB tempdb data: 20 GB for IT Asset Management system operations, plus 5 GB per 100,000 SAP user accounts tempdb logs: 20 GB for IT Asset Management system operations, plus 10 GB per 100,000 SAP user accounts.	These estimates can be used to calculate how much disk drive space should be allocated for various files. The actual files on disk will be smaller than these figures. These metrics are calculated such that data file sizes should be up to roughly 50% of the allocated disk space, while log file sizes should be up to roughly 67% of the allocated disk space. The simple database recovery model should be used for the IT Asset Management database, meaning that the transaction log should only grow to not much larger than the largest single transaction. Use of the full database recovery model will result in more database log space being used than is specified here. See Database Disk Recommendations for additional guidelines about the management of data drives.
Operating System	Windows Server 2012 Standard or later	A 64-bit operating system is strongly recommended for the database server in order to get the best SQL Server performance. Windows Server 2012 Enterprise may be typically required for larger servers with more memory.
Other Software	Microsoft SQL Server 2012 Standard Edition (64 bit) or later IIS (version as supplied with OS) Other prerequisites as per release notes	SQL Server Enterprise Edition is required if this server has more than 4 CPUs or more than 64 GB of RAM.