Share via


Archive Accounting Information

Applies To: Windows Server 2008

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. Use the procedure to shrink the database if your database grows too large.

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 the operating system uses. This reduces the chance of the operating system running out of disk space.

Membership in the local Administrators group, or equivalent, is required to complete these procedures.

Archive accounting information

To archive accounting information

  1. Open Windows System Resource Manager.

  2. In the navigation tree, right-click Accounting, and then click Archive or Delete Information.

  3. In Start Date, select a beginning date for the data to be archived.

  4. In End Date, select an ending date for the data to be archived.

  5. In Computer(s) whose accounting information is to be considered, do one of the following:

    • Click Specify Computer(s) and type a computer name or a comma-separated list of computer names.

    • Click All Computers.

  6. Click Archive Data to configure your archiving options.

  7. In Archive File, 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.

  8. In File Format, select a file format.

  9. If desired, click to Delete entries from the database.

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.

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 press ENTER.

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

Additional considerations

  • To open Windows System Resource Manager, click Start, point to Administrative Tools, and then click Windows System Resource Manager. In the Connect to Computer dialog box, select This computer, and then click Connect. Microsoft Management Console will start with the Windows System Resource Manager (Local) snap-in open.

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

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

Additional references