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:
- Create a settings section.
- 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.