Archive Accounting Information

Applies To: Windows Server 2008 R2

Windows System Resource Manager uses any available disk space to store accounting data. However, Windows System Resource Manager does not automatically overwrite old records or reuse storage space. You must archive and delete accounting data to manage the size of the accounting database.

Important

Deleting archived records does not reduce the disk usage of the accounting database. If your database grows too large, see “Reduce the size of the Windows System Resource Manager database” later in this topic.

Because the disk usage of the accounting system increases until you delete old records, you should configure the accounting system to use a volume other than the one that the operating system uses. This reduces the chance of the operating system running out of disk space.

Archive accounting information

Membership in the local Administrators group, or equivalent, is the minimum required to complete this procedure.

To archive accounting information

  1. Open Windows System Resource Manager. To open Windows System Resource Manager, click Start, point to Administrative Tools, and then click Windows System Resource Manager.

  2. In the Connect to Computer dialog box, select This computer, and then click Connect.

  3. In the console tree, right-click Accounting, and then click Archive or Delete Information.

  4. In the Archive or Delete Accounting Information dialog box, in the Start date list, select a beginning date for the data to be archived.

  5. In the End date list, select an ending date for the data to be archived.

  6. Under Select computers to manage accounting information, do one of the following:

    • Click Specify computers and type a computer name or a comma-separated list of computer names.

    • Click All computers.

  7. To configure your archiving options, select the Archive data check box.

  8. In the Archive file box, type a file name and path for the archived data, or click Browse to find the directory where you want to save the archive file.

  9. In the File format box, select a file format.

  10. If desired, select the Delete entries from the database check box.

Reduce the size of the Windows System Resource Manager database

If you archive or delete entries from the database and you want to reduce the amount of disk space used by Windows System Resource Manager accounting, you must shrink the database. This procedure requires downloading and installing two free utilities.

Download and install database utilities

Microsoft SQL Server Native Client

First, download and install the Microsoft SQL Server Native Client. This is a single dynamic-link library (DLL) that contains run-time support for applications that use SQL Server 2005 features.

Microsoft SQL Server 2005 Command Line Query Utility

Second, download and install the Microsoft SQL Server 2005 Command Line Query Utility. This utility allows you to connect, send Transact-SQL batches, and output rowset information from SQL Server 7.0, SQL Server 2000, and SQL Server 2005 instances.

Note

SQLCMD is a replacement for ISQL and OSQL, but can coexist with installations of ISQL and OSQL.

Use SQL utilities to shrink the database

The following procedure will shrink the native Windows System Resource Manager database.

Membership in the local Administrators group, or equivalent, is the minimum required to complete this procedure.

To shrink the database

  1. On the computer where the accounting database is located, click Start, click All Programs, and then click Accessories.

  2. Right-click Command Prompt, and then click Run as administrator.

  3. At the command prompt, type cd %windir%\system32\windows system resource manager\db and then press ENTER.

  4. At the command prompt, type shrinkdb.cmd and then press ENTER.

Additional considerations

  • You must stop the Windows System Resource Manager service before using another application in order to back up the accounting database.

  • When Accounting is enabled, both Manage and Profile management types generate accounting data.

Additional references