Share via


Catalog Performance Counters

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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

How to View Commerce Server Performance Counters

Commerce Server Performance Counters