Data Warehouse Performance Counters
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