Share via


Data Warehouse Performance Counters

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

The following table describes the Data Warehouse performance counters that you should monitor for information collected during Data Warehouse tasks. You can analyze the results of these performance counters to make sure that tasks such as importing catalogs and products are performing as expected. You can also use the Data Warehouse performance counters to compare the total number of resolved and unresolved IP addresses, and use this data to troubleshoot the Data Transformation Services DTS IP Resolution task.

You can find these counters in Microsoft Windows Server System Monitor. The System Monitor organizes performance counters by performance object. You should monitor your site by using performance counters and view the results collectively.

Commerce: Data Warehouse

Counter name

Description

CatImport: Total Catalogs

Total number of catalogs imported during this DTS import task.

CatImport: Total Categories

Total number of categories imported during this DTS import task.

CatImport: Total Products

Total number of products imported during this DTS import task.

Provider: Total SetColumns

The total number of times SetColumns() has been called.

SES: Row Commit Insert/sec

The number of rows stored per second.

Total IPs resolved

Total number of IPs resolved during this DTS IP Resolution task.

Total IPs unresolved

Total number of IPs unresolved during this DTS IP Resolution task.

UImport: Commerce events

The total number of Commerce Server events that occurred for the import task.

UImport: Current visits

The total number of active visits recorded when the log files are processed.

UImport: Decoded cookies

The total number of Commerce Server-decoded cookies found when the import task was running.

UImport: Free hit buffers

The number of currently available empty hit buffers.

UImport: Hits/sec

The rate at which the import task is processing hits per second.

UImport: Query strings

The total number of query strings processed when the import task was running.

UImport: Used hit buffers

The number of currently filled hit buffers.

See Also

Other Resources

Monitoring Performance Counters

How to View Commerce Server Performance Counters

Commerce Server Performance Counters