| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
SQL Server, Catalog Metadata object |
Learn about the SQLServer:Catalog Metadata performance object, which provides counters for catalog metadata for SQL Server. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
reference |
|
[!INCLUDE 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.
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%';