Worktables From Cache Ratio (WorktablesFromCacheRatio)
Percentage of work tables created where the initial two pages of the work table were not allocated but were immediately available from the work table cache. (When a work table is dropped, two pages may remain allocated and they are returned to the work table cache. This increases performance.)
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_PERFMON_ACCESS_METHODS |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | Percent |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | No |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Perfmon Access Methods |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |