Database Server issues

From DocWiki

(Difference between revisions)
Jump to: navigation, search
(New page: '''Database Server Configuration''' :* Verify mode of authentication set in SQL Enterprise Manager (needs to be mixed-mode) :* Verify network packet size :* Verify TCP/IP port (Default por...)
(3 intermediate revisions not shown)
Line 31: Line 31:
:* Consolidate regular database maintenance plans.
:* Consolidate regular database maintenance plans.
-
'''[[Note:]]'''
+
'''Note:'''
The above best practices apply to both Active (stores data associated with the default application partition) and Master (stores data associated with back-end processes and shared resources) databases.
The above best practices apply to both Active (stores data associated with the default application partition) and Master (stores data associated with back-end processes and shared resources) databases.
 +
 +
 +
[[Category:Unified Contact Center Express]]
 +
[[Category:Unified Contact Center Enterprise]]
 +
[[Category:Unified ICM/CCE & Hosted, Release 7.5]]
 +
[[Category:Unified CCE, Release 8.0]]

Revision as of 20:05, 12 January 2012

Database Server Configuration

  • Verify mode of authentication set in SQL Enterprise Manager (needs to be mixed-mode)
  • Verify network packet size
  • Verify TCP/IP port (Default port = 1433)


Database Server issues

  • High Memory and CPU utilization
  • Verify if rebuilding of indexes, archiving jobs, and reports summary jobs are running simultaneously.


Database Performance issue

  • Run custom performance trace/trace templates that may have been created by a Database Administrator (DBA) to collect performance times associated with queries on DB.
  • Run a trace using SQL Query Profiler, and identify queries that may be taking more than 5 seconds to execute completely.
  • Change application log trace level to determine database queries (see Unified EIM / Unified WIM user guides)
  • Analyze <Unified EIM / Unified WIM Install Dir>/logs/eGainQueryTimeLog.txt for queries that may be taking more than 10 seconds to execute completely.


DB Restoration issues

  • Verify user privileges (user must have DB System Administration role assigned)
  • Verify default database for the database users (Active and Master databases).
  • Verify location of full text index (FTI) catalogs in file system. Typically, the FTI catalogs reside in the <MS SQL Server>/MSSQL/Data directory.


Database Configuration Best Practices

  • Rebuild indexes once per week.
  • Verify that ‘Auto-update statistics’ setting is enabled.
  • Verify that ‘Auto-create statistics’ setting is enabled.
  • Configure and analyze performance monitors.
  • Configure appropriate DB size for Unified EIM / Unified WIM Master DB, Active DB and Archive DB based on anticipated DB growth (Recommended size for Active DB is 4 GB, Master DB is 1 GB, and Archive DB is 1 GB. Set the property for database to grow incrementally if required. Please refer Deployment Sizing Guide for Unified EIM / Unified WIM for computing database size based on system parameters).
  • Consolidate regular database maintenance plans.

Note: The above best practices apply to both Active (stores data associated with the default application partition) and Master (stores data associated with back-end processes and shared resources) databases.

Rating: 1.0/5 (1 vote cast)

Personal tools