SQL Server, Catalog Metadata Object

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The SQLServer:Catalog Metadata performance object provides counters for catalog metadata for SQL Server.

This following table describes the SQL Server Catalog Metadata performance objects.

SQL Server Catalog Metadata counters Description
Cache Entries Count Number of entries in the catalog metadata cache.
Cache Entries Pinned Count Number of catalog metadata cache entries that are pinned.
Cache Hit Ratio Ratio between catalog metadata cache hits and lookups.
Cache Hit Ratio Base For internal use only.

There is one instance of the counter for each database.

See Also

Monitor Resource Usage (System Monitor)