Applies to
SSRS
Description
SSRS response to request from client application can be affected by the available memory in the server. This performance counter gives you an indication of current memory state.
Current memory state value can be in a range of 1 to 5, whereby 1: no memory pressure; 2: low memory pressure; 3: medium memory pressure; 4: high memory pressure; 5: exceeded memory pressure limit.
Applications that are likely to be affected by current memory state includes Report Manager portal, Report Server Web Service and automated background processes such as sending out of report subscriptions and database maintenance.
Resolved by
DBAs, Server administrators, System administrators, Web administrators
Suggested solutions
- Failed allocate pages: FAIL_PAGE_ALLOCATION 2 indicates OutOfMemory error
- Consider setting WorkingSetMaximum property in the RSReportServer.config file
- In order to see NotifyMemoryPressure items in the Reporting Services Trace Log, consider setting the log to Verbose
- If you are running subscriptions, consider offloading them to a separate server from on demand report requests
Additional research
SSRS Memory Pressure Zones
Monitoring SSRS Report Performance – Part 4
Performance Counters (SSAS)