Database Server issues - Revision history

Jkratky at 20:05, 12 January 2012

2012-01-12T20:05:17Z

← Older revision		Revision as of 20:05, 12 January 2012
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.

Saychakr at 07:48, 24 February 2011

2011-02-24T07:48:20Z

← Older revision		Revision as of 07:48, 24 February 2011
Line 39:		Line 39:
	[[Category:Unified ICM/CCE & Hosted, Release 7.5]]		[[Category:Unified ICM/CCE & Hosted, Release 7.5]]
	[[Category:Unified CCE, Release 8.0]]		[[Category:Unified CCE, Release 8.0]]
-	~~[[Category:Unified ICM/Contact Center Enterprise & Hosted \| Troubleshooting]]~~

Saychakr at 07:42, 24 February 2011

2011-02-24T07:42:44Z

← Older revision		Revision as of 07:42, 24 February 2011
Line 35:		Line 35:


-	~~[[Category:Unified ICM/Contact Center Enterprise & Hosted]]~~
	[[Category:Unified Contact Center Express]]		[[Category:Unified Contact Center Express]]
	[[Category:Unified Contact Center Enterprise]]		[[Category:Unified Contact Center Enterprise]]

Saychakr at 13:14, 11 January 2011

2011-01-11T13:14:15Z

← Older revision		Revision as of 13:14, 11 January 2011
Line 33:		Line 33:
	'''[[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 ICM/Contact Center Enterprise & Hosted]]
		+	[[Category:Unified Contact Center Express]]
		+	[[Category:Unified Contact Center Enterprise]]
		+	[[Category:Unified ICM/CCE & Hosted, Release 7.5]]
		+	[[Category:Unified CCE, Release 8.0]]
		+	[[Category:Unified ICM/Contact Center Enterprise & Hosted \| Troubleshooting]]

Saychakr: 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...

2011-01-10T06:27:43Z

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...

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 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.