Cisco Cisco IP Contact Center Release 4.6.1 Technical References
ICM/IPCC Database Troubleshooting
This chapter discusses some common ICM/IPCC Database related problems, their causes, and
some possible solutions.
some possible solutions.
To assist in diagnosis of a problem, the following information may be helpful.
•
Dump Log
•
SQL Server perfmon log
•
SQL trace log and error log
•
Table sizes for tables in your database
•
Space used by your database
•
Logger registry key dump
•
VS .Net mini dump file
Large Reporting Queries Impacting Performance
Symptom:
System performance is impacted adversely when running a reporting query.
Message:
Cause:
Reporting queries need to be kept to a reasonable size or system performance will be impacted
adversely, particularly for especially large queries such as call detail or ECC tables.
adversely, particularly for especially large queries such as call detail or ECC tables.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
453
Chapter 6
Troubleshooting