3.1.4.2.2.1.3.72.1 Columns

The DISCOVER_DB_MEM_STATS rowset contains the following columns.

Name	Type	Restriction	Description
CATALOG_NAME	xsd:string	Yes	The name of the online database. The system tracker name is $System.
DATABASE_ID	xsd:string		The identifier of the online database.
DATABASE_GUID	uuid		The GUID of the online database. The value is empty for the system tracker.
CURRENTLY_USED	xsd:boolean		A Boolean that indicates whether any requests are currently running against this database. The value is empty for the system tracker.
POPULARITY	xsd:float		A measure of how frequently the database is used. The value is empty for the system tracker.
WEIGHTEDPOPULARITY	xsd:double		A measure of how frequently the database is used, expressed as a fraction with respect to the other databases. The value is empty for the system tracker.
OWNED_MEMORY_KB	xsd:long		The total amount of memory, in kilobytes, that is owned by the database or system, including all of the proxy requests memory that was transferred to the database tracker.
ACTIVE_REQUESTS_MEMORY_KB	xsd:long		The total amount of memory, in kilobytes, that is owned by the active request trackers.
ACTIVE_REQUESTS_COUNT	xsd:unsignedInt		The number of active requests that are running against the database or the system tracker.
PROXY_REQUESTS_MEMORY_KB	xsd:long		This column SHOULD<366> indicate the total amount of memory, in kilobytes, that is used by proxy request trackers.
PROXY_REQUESTS_COUNT	xsd:unsignedInt		The number of request trackers that are proxies of the current database.
PROXY_REQUESTS_ALLOCATIONS_COUNT	xsd:unsignedLong		The number of individual allocations tracked by the requests trackers that are proxies of the database or system tracker.
DB_PROXY_TRACKERS_COUNT	xsd:unsignedInt		The number of database trackers that are proxies of the system tracker. This value is reported only by the system tracker.
DB_PROXY_TRACKERS_ALLOCATIONS_COUNT	xsd:unsignedLong		The number of individual allocations tracked by database trackers that are proxies of the system tracker This value is reported only by the system tracker.

The rowset is sorted on CATALOG_NAME.

The response has the following definition.

 <xsd:element name="root">
   <xsd:complexType>
     <xsd:sequence minOccurs="0" maxOccurs="unbounded">
       <xsd:element name="row" type="row" />
     </xsd:sequence>
   </xsd:complexType>
 </xsd:element>
 <xsd:simpleType name="uuid">
   <xsd:restriction base="xsd:string">
     <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
   </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="xmlDocument">
   <xsd:sequence>
     <xsd:any />
   </xsd:sequence>
 </xsd:complexType>
 <xsd:complexType name="row">
   <xsd:sequence>
     <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="DATABASE_ID" name="DATABASE_ID" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="DATABASE_GUID" name="DATABASE_GUID" type="uuid" minOccurs="0" />
     <xsd:element sql:field="CURRENTLY_USED" name="CURRENTLY_USED" type="xsd:boolean" 
                  minOccurs="0" />
     <xsd:element sql:field="POPULARITY" name="POPULARITY" type="xsd:float" minOccurs="0" />
     <xsd:element sql:field="WEIGHTEDPOPULARITY" name="WEIGHTEDPOPULARITY" type="xsd:double" 
                  minOccurs="0" />
     <xsd:element sql:field="OWNED_MEMORY_KB" name="OWNED_MEMORY_KB" type="xsd:long" 
                  minOccurs="0" />
     <xsd:element sql:field="ACTIVE_REQUESTS_MEMORY_KB" name="ACTIVE_REQUESTS_MEMORY_KB" 
                  type="xsd:long" minOccurs="0" />
     <xsd:element sql:field="ACTIVE_REQUESTS_COUNT" name="ACTIVE_REQUESTS_COUNT" 
                  type="xsd:unsignedInt" minOccurs="0" />
     <xsd:element sql:field="PROXY_REQUESTS_MEMORY_KB" name="PROXY_REQUESTS_MEMORY_KB" 
                  type="xsd:long" minOccurs="0" />
     <xsd:element sql:field="PROXY_REQUESTS_COUNT" name="PROXY_REQUESTS_COUNT" 
                  type="xsd:unsignedInt" minOccurs="0" />
     <xsd:element sql:field="PROXY_REQUESTS_ALLOCATIONS_COUNT" 
                  name="PROXY_REQUESTS_ALLOCATIONS_COUNT" type="xsd:unsignedLong" 
                  minOccurs="0" />
     <xsd:element sql:field="DB_PROXY_TRACKERS_COUNT" name="DB_PROXY_TRACKERS_COUNT" 
                  type="xsd:unsignedInt" minOccurs="0" />
     <xsd:element sql:field="DB_PROXY_TRACKERS_ALLOCATIONS_COUNT" 
                  name="DB_PROXY_TRACKERS_ALLOCATIONS_COUNT" type="xsd:unsignedLong" 
                  minOccurs="0" />
   </xsd:sequence>
 </xsd:complexType>