This chapter provides SQL Server configuration and performance guidelines. If you intend to use SQL Server as your CA DLP database engine, you must address various requirements before installing the CMS or a gateway. This chapter also provides details about the various SQL Server logins required by CA DLP and the requirements when installing CMSs and gateways that use a SQL Server database. The final section covers SQL Server upgrades, including snapshot isolation locking on SQL Server 2005 databases.
For details about SQL Server features, see your Microsoft SQL Server documentation.
Note: To ensure optimum performance, you must also regularly maintain your database indexes.
This section contains the following topics:
|
Copyright © 2012 CA.
All rights reserved.
|
|