SCSM 2012 Disk Requirements for DB Servers

Please keep in mind that this does not take precedence over the information provided in the MS Infrastucture Planning Guide.

Full documentation and planning guidance for System Center 2012 Service Manager can be found HERE.

Alternatively, the documentation may also be found in Microsoft’s TechNet Library.

The following calculations were derived from the ‘SM2012_Sizer.xlsm‘ (sizing calculator) contained within the SM_job_aids zip file from Microsoft. Though the calculations below may vary slightly from what is in the sizing calculator mentioned above, they should nonetheless be very close.

Please keep in mind that the default settings for data retention of 90 days in the Management DB and 1095 days in the Data Warehouse are the “Best Practice” recommendations from Microsoft. If we choose to set the retention for longer periods of time, we can mitigate performance issues within the console through the use of multiple work item views as well as adding CPU cores/ threads and memory to the server.

With that said, here is the math…

Service Manager DB Sizing

#of computer work items per month

(#of Computers in CMDB * #of new incidents per month) + #of new change requests

  • EXAMPLE:
    • 10,000 Computers * 3 new incidents per month = 30,000 new incidents per month
    • 30,000 + 500 new change requests = 30,500 computer work items per month

SvcMgr DB (GB)

1 + ((500 +( 5 * Work item retention days)) * #of computer work items per month) / 1,000,000

  • EXAMPLE:
    • 5 * 180 Work item data retention days = 900
    • 1 + 500 + 900 = 1,401
    • 1,401 * 30,500 = 42,730,500
    • 42,730,500 / 1,000,000 = 42.7305
    • SvcMgr DB = 43GB

Minimum total disk size (GB) for DB

SvcMgr DB *1.53

  • EXAMPLE:
    • 43GB * 1.53 = 65.79GB
    • Minimum Total Disk = 66GB

Data Warehouse Sizing

DWStagingandConfig

SvcMgr DB Size * 2

  • EXAMPLE:
    • 43GB * 2 = 86GB
    • DWStagingandConfig = 86GB

Repository

SvcMgr DB * (Data Retention Days/365) * 2

  • EXAMPLE:
    • 1095 Data Retention Days / 365 = 3
    • 43GB * 3 = 129GB
    • 129GB * 2 = 258GB
    • Repository = 258GB

DWDataMart

SvcMgr DB * (Data Retention Days/365) * 2

  • EXAMPLE:
    • 1095 Data Retention Days / 365 = 3
    • 43GB * 3 = 129GB
    • 129GB * 2 = 258GB
    • DWDataMart = 258GB

TempDB

SvcMgr DB * 5

  • EXAMPLE:
    • 43GB * 5 = 215GB
    • TempDB = 215GB

DWASDataBase

DWDataMart * 0.2

  • EXAMPLE:
    • 258GB * 0.2 = 51.6GB
    • DWDataMart = 52GB

Minimum total disk size (GB) for DW

(DWStagingandConfig + Repository + DWDataMart + TempDB + DWASDataBase) * 1.53

  • EXAMPLE:
    • 86GB + 258GB + 258GB +215GB + 52GB = 869GB
    • 869GB * 1.53 = 1,329.57GB
    • Minimum Total Disk = 1,330GB