Catalog Performance Counters
The following table describes the catalog performance counters that you should monitor for data related to your catalog, inventory, and product queries. You can use the results of these performance counters to analyze how searches are conducted and the frequency of particular searches. You can also use the catalog performance counters to monitor the frequency of catalog maintenance to make sure that inventory items are imported, exported, and updated as expected.
You can find these counters in Microsoft Windows Server System Monitor. The Service Monitor organizes the performance counters by performance object. You should monitor your site by using performance counters and view the results collectively.
Commerce: Catalog
Counter name |
Description |
|---|---|
Advanced search rate |
The number of advanced searches (product queries - property based search) per second. |
Advanced search time |
The average time (in seconds) to perform an advanced search (product query - property based search). |
Advanced search total |
The total number of advanced searches. |
Ancestor Categories query rate |
The number of Ancestor Categories queries per second. |
Ancestor Categories query time |
The average time (in seconds) for querying Ancestor Categories. |
Ancestor Categories query total |
The total number of Ancestor Categories queries. |
Cache Hit Ratio |
The ratio of cache hits to the total number of calls. |
Cache Hits/sec |
The number of cache hits per second. |
Cache Misses/sec |
The number of cache misses per second. |
Cache Total Entries |
The number of items in the cache. |
Cache Total Hits |
The total number of cache hits. |
Cache Total Misses |
The total number of cache misses. |
Cache Turnover Rate |
The number of additions to and removals from the cache per second. |
Canonical Categories query rate |
The number of Canonical Categories queries per second. |
Canonical Categories query time |
The average time (in seconds) for querying Canonical Categories. |
Canonical Categories query total |
The total number of Canonical Categories queries. |
Catalog items export rate |
The number of catalog items exported per second. |
Catalog items export time |
The average time taken (in seconds) to export one item. |
Catalog items export total |
The number of catalog items exported. |
Catalog items imported rate |
The number of catalog items imported per second. |
Catalog items imported time |
The average time taken (in seconds) to import one item. |
Catalog items imported total |
The number of catalog items imported. |
Catalog updates rate |
The number of catalog updates (for example, updates to products, categories, variants, relationships, and hierarchies) per second. |
Catalog updates time |
The average time (in seconds) per catalog update requests (for example, updates to products, categories, variants, relationships, and hierarchies). |
Catalog updates total |
The total number of catalog updates (for example, updates to products, categories, variants, relationships, and hierarchies). |
Category query rate |
The total number of category details queries per second. |
Category query time |
The average time (in seconds) to retrieve category details. |
Category query total |
The total number of category details queries. |
Child Categories query rate |
The number of Child Categories queries per second. |
Child Categories query time |
The average time (in seconds) for querying Child Categories. |
Child Categories query total |
The total number of Child Categories queries. |
Child Products query rate |
The number of Child Products queries per second. |
Child Products query time |
The average time (in seconds) for querying Child Products. |
Child Products query total |
The total number of Child Products queries. |
Combined search rate |
The combined number of advanced searches, specification searches, and free text searches per second. |
Combined search time |
The average time (in seconds) to perform an advanced search, a specification search, or a free text search. |
Combined search total |
The total number of combined searches. |
Free-text search rate |
The number of free-text searches per second. |
Free-text search time |
The average time (in seconds) to perform a free-text search. |
Free-text search total |
The total number of free-text searches. |
Inventory items export time (sec) |
The average time taken (in seconds) to export one inventory item. |
Inventory items export total |
The number of inventory items exported. |
Inventory items export/sec |
The number of inventory items exported per second. |
Inventory items imported time (sec) |
The average time taken (in seconds) to import one inventory item. |
Inventory items imported total |
The number of inventory items imported. |
Inventory items imported/sec |
The number of inventory items imported per second. |
Inventory updates time (sec) |
The average time (in seconds) per inventory update (update to any inventory property) request. |
Inventory updates total |
The total number of inventory updates. |
Inventory updates/sec |
The number of inventory updates (update to any inventory property) request per second. |
Parent Categories query rate |
The total number of Parent Categories queries per second. |
Parent Categories query time |
The average time (in seconds) to retrieve Parent Categories. |
Parent Categories query total |
The total number of Parent Categories queries. |
Product details query rate |
The number of product details queries per second. |
Product details query time |
The average time (in seconds) to retrieve product details. |
Product details query total |
The total number of product details queries. |
Relationships query rate |
The total number of Product/Category Relationships queries per second. |
Relationships query time |
The average time (in seconds) for querying Product/Category Relationships. |
Relationships query total |
The total number of Product/Category Relationships queries. |
Specification search rate |
The number of specification searches per second. |
Specification search time |
The average time (in seconds) to perform a specification search. |
Specification search total |
The total number of specification searches. |
Variant details query rate |
The number of variant details queries per second. |
Variant details query time |
The average time (in seconds) to retrieve variant details. |
Variants details query total |
The total number of variant products queries. |
Catalog Query Rate Performance Counter
The Catalog Query Rate counter is the rate of queries per second through the Marketing and Catalog object on a server. These queries include all category- and product-related queries in addition to free text search. You can reduce queries to the Catalog System by using a product cache or search cache to improve performance. Free text search can also be tracked with the Microsoft search>queries/sec counter.
Note
The catalog query rate is the uncached rate. If this rate is high, you should change the application code to take advantage of a local caching mechanism, such as the LRUCache counter.
See Also
Other Resources
Monitoring Performance Counters