Problem Note 42746: Performance degradation in the SAS 9.2 Pooled Workspace Server when querying SAS® Information Maps
In SAS® 9.2, users may notice a decrease in SAS® BI Dashboard performance over time when querying SAS® Information Maps. This decrease in performance is due to a slow memory leak that occurs when the SAS BI Dashboard calls on the SAS Pooled Workspace Server. To alleviate this problem, a reasonable recycle parameter should be set to prevent individual server leaks from becoming a problem. This parameter can be set in SAS® Metadata Repository in order to automatically recycle the server after a specified number of clients. The default value is 0.
A reasonable recycle value is 100, which would recycle the server after every 100 clients. This avoids the problem and does not appear to cause any significant performance impact. It is possible that a higher value, such as 1000, may also work with even less performance impact.
If users are experiencing this behavior, it is recommended that the SAS Administrator set a reasonable recycle value for the server, using the two previously mentioned values (100 and 1000) as the lower and upper bounds for the value.
To change the Recycle Activation Limit, follow these steps:
- Log on to SAS Management Console as the unrestricted user
- On the Plug-ins tab, navigate to Server Manager►SAS Application Servers (SASApp)►Logical Pooled Workspace Server►Pooled Workspace Server
- Right–click the Pooled Workspace Server and select Properties. The Properties dialog box opens.
- Select the Options tab
- Click the Advanced Options... button. This brings up the Advanced Options dialog box.
- Select the Load Balancing tab
- Change the Recycle activation limit to a value between 100 and 1000
Operating System and Release Information
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 R2 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Professional x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Ultimate 32 bit | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows Vista | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| HP-UX IPF | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Solaris for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Linux | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Linux for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| OpenVMS on HP Integrity | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows Vista for x64 | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
| z/OS | 9.21 | 9.3 | 9.2 TS2M2 | 9.3 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Users may experience performance degredation due to a memory leak in the SAS Pooled Workspace Server due to SAS® Information Map queries and a default Recycle Activation Limit of 0
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-11-25 11:16:58 |
| Date Created: | 2011-03-22 13:24:35 |
