Jump to: navigation, search

Database Performance

This page provides general recommendations on running Microsoft SQL.

Further information on improving the performance of the Interaction Server database is also available.

Microsoft SQL 2000

  • In general, patch up to Service Pack 4.
  • If Microsoft SQL is running on a machine with over 2 GB of RAM, use Windows’ AWE (Address Windowing Extensions) mode. To avoid performance degradation, patch Microsoft SQL according to Microsoft’s recommendation “FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4” (see http://support.microsoft.com/?kbid=899761). This patch brings Microsoft SQL to version 8.00.2040.

Microsoft SQL 2005

There is an issue that occurs with Microsoft SQL 2005: when the database is very large (on the order of one million interactions), there are periodically exceptions in the Stat service, and CPU activity rises to 100%.

To avoid this issue, configure the UCS DAP as follows:

  1. Create a settings section.
  2. In this section, create an option called prepare and set its value to false.

This DAP configuration applies to Microsoft SQL 2005 only; configuring the DAP in this way with Microsoft SQL 2000 degrades performance.

This page was last edited on August 1, 2014, at 23:28.
Comments or questions about this documentation? Contact us for support!