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 |
Open Windows System Resource Manager. 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.
In the console tree, right-click Accounting, and then click Archive or Delete Information.
In the Archive or Delete Accounting Information dialog box, in the Start date list, select a beginning date for the data to be archived.
In the End date list, select an ending date for the data to be archived.
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.
- Click Specify computers and type a computer name or a comma-separated list of computer names.
To configure your archiving options, select the Archive data check box.
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.
In the File format box, select a file format.
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.
- To download the Microsoft SQL Server Native Client for x86-based operating systems, see
https://go.microsoft.com/fwlink/?LinkId=94787 . - To download the Microsoft SQL Server Native Client for x64-based operating systems, see
https://go.microsoft.com/fwlink/?LinkId=94788 . - To download the Microsoft SQL Server Native Client for IA-64-based operating systems, see
https://go.microsoft.com/fwlink/?LinkId=94789 .
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. |
- To download the Microsoft SQL Server 2005 Command Line Query Utility for x86-based operating systems, see
https://go.microsoft.com/fwlink/?LinkId=94790 . - To download the Microsoft SQL Server 2005 Command Line Query Utility for x64-based operating systems, see
https://go.microsoft.com/fwlink/?LinkId=94791 . - To download the Microsoft SQL Server 2005 Command Line Query Utility for IA-64-based operating systems, see
https://go.microsoft.com/fwlink/?LinkId=94792 .
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 |
On the computer where the accounting database is located, click Start, click All Programs, and then click Accessories.
Right-click Command Prompt, and then click Run as administrator.
At the command prompt, type cd %windir%\system32\windows system resource manager\db and then press ENTER.
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
- Windows System Resource Manager
- Logging Accounting Data in Windows System Resource Manager
- For more information about Windows System Resource Manager, see
https://go.microsoft.com/fwlink/?LinkId=90924 .