Redigera

Dela via


SQL Server, Catalog Metadata object

Applies to: SQL Server

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.

Example

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Catalog Metadata%';