ACT Database Configuration
Published: February 29, 2012
Updated: May 31, 2012
Applies To: Windows 7, Windows 8, Windows Vista
The Application Compatibility Toolkit (ACT) uses a Microsoft® SQL Server® database for storing and sharing compatibility issue data. If you do not use Microsoft SQL Server, you can download and install Microsoft SQL Server Express. For information about creating Microsoft SQL Server databases, see Administering the Database Engine.
You can create the ACT database by using one of the following methods:
Run Application Compatibility Manager (ACM), and then use the ACT Configuration Wizard to create a new database.
Run the CreateDB.sql file. The following table shows the location of the CreateDB.sql file.
Operating system Path
Windows Server® 2012
Windows Server 2008 R2
Windows Server 2008 with Service Pack 2 (SP2)
%SYSTEMDRIVE%\ProgramData\Microsoft\Application Compatibility Toolkit\CreateDB.sql
Windows XP with Service Pack 3 (SP3)
%SYSTEMDRIVE%\Documents and Settings\All Users\Application Data\Microsoft\Application Compatibility Toolkit\CreateDB.sql
You must assign the following database roles to the following accounts.
To the user and local service accounts that will run the ACT Log Processing Service (LPS), assign the db_datareader, db_datawriter, and db_owner database roles.
To the user account that will run Application Compatibility Manager (ACM), assign the db_datareader and db_datawriter database roles.
Alternatively, grant the following explicit permissions to each user that will run the ACT LPS or ACM.
We also recommend that you make the following changes to the database as part of your deployment planning:
Create a larger database, including a larger log file–size setting, and then set the growth increments appropriately. If you create a database with the default setting for data storage, the data portion of the database will have an initial size of 1 megabyte (MB), and a growth increment of 1 MB. If you create a database with the default setting for log file storage, the log file portion of the database will have an initial size of 1 MB and a growth increment of 10 percent. We recommend that you maintain a data-to-log file ratio of 5:1 or 4:1. For example, if your data portion is 5 gigabytes (GB), your log file portion should be 1 GB.
Change the recovery model of your database. The default recovery model is Full, but we recommend that you change the recovery model to Simple to improve performance and reduce disk space requirements.
Store the data portion and log file portion of your ACT database on separate hard drives. Unless otherwise specified by your SQL Administrator, the default is for the data and log files to be stored on the same hard drive. We recommend separating the data from the log files to reduce disk I/O contention.