Problem Note 45632: Queries against the SAS® OLAP Server on Microsoft Windows might use excessive memory due to a Windows cache manager issue
 |  |  |  |  |
When querying a SAS OLAP cube with high I/O, the Windows machine that is running the SAS OLAP Server might show excessive memory usage. This problem can occur because the cache manager on Windows retains all pages of data that are open for random access.
For more information about this Windows random access issue, see Problem Note 39615.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply the hot fix to 9.2 TS2M3, the default SAS functionality still uses the original I/O method. To enable SAS to override the random access method, you must create a Windows environment variable called SAS_NO_RANDOM_ACCESS and set the value to 1. This task is described in Problem Note 39615.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS OLAP Server | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Windows Vista | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Windows Vista for x64 | 9.2 TS2M0 | 9.3 TS1M2 | ||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#45632A fix for this issue for SAS Threaded Kernel Core Routines 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G01.html#45632| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-03-02 08:53:18 |
| Date Created: | 2012-02-10 13:10:15 |