Article ID: 128722, created on Apr 22, 2016, last review on Apr 22, 2016

  • Applies to:
  • Operations Automation

Question

"MS SQL Disk Space Quota" resource usage shown at Home > All Resource Usage in CCP is bigger than the actual usage shown for the hosted database within the subscription at More Services > Databases > . Why are these values not the same?

Answer

The MS SQL disk space usage is calculated for all hosted databases, which includes MS SQL system DBs. Logging in to the Web Data Administrator of the subscription and listing the databases, the total size will consist of the database hosted by user and 'master', 'msdb', 'tempdb' databases, stored by MS SQL service.

Per the documentation, available at http://download.automation.odin.com/pa/6.0/doc/portal/6.0/oa/51566.htm: The size of all databases including transaction logs is limited by the new Disk Space Quota resource.

"All databases" here means precisely that all possible space occupied by MS SQL service is accounted.

Search Words

size

ms sql

Resource overusage attempt

mssql

Disk Space Quota

data

database

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF