CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services

How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options

How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options

  • Comments 2

The Page Audit User is one of the main execution paths for data integrity checking.   SQLIOSim runs test cycles and during each test cycle the [Audit User] section of the .INI configuration file is used.  These workers perform various page audit actives.

After the cycle completes SQLIOSim creates audit users, per CPU to perform integrity checks for every page.   This might not be possible during the test cycle duration and occurs during a known file state.  The [Audit User] section of the .INI control file does not control the audit user activity outside the test cycle.

Sections with UserCount Option

[AuditUser]
UserCount=0
....

The following table outlines the SQLIOSim behavior for UserCount settings.

UserCount Value Behavior
-1 SQLIOSim sets the user count based on a CPU count formula.
0 SQLIOSim honors, no users of type created during the test cycle.

Not recommended.  Disabling users can result in reduced data integrity checks.
Specified > 0 Honored by SQLIOSim as long as the value remains in a valid range.
Delete the Section or Value SQLIOSim assumes -1 behavior.

I Deleted the Entire [Audit User] Section and It Comes Back

SQLIOSIM.COM  (Command line requires -save to update the config file)

                sqliosim.com -cfg c:\temp\config.ini -save c:\temp\config.new.ini

SQLIOSIM.exe  (GUI - Files and Configuration Dialog allows Load another config file)

                sqliosim.exe

When you click the OK button the configuration file is updated with the information from the dialog, including the defaults which includes the calculated Audit Users.

image

Bob Dorr
SQL Server Senior Escalation Engineer

Leave a Comment
  • Please add 8 and 5 and type the answer here:
  • Post