Problem Note 50744: Performance of the SAS® Metadata Server might decrease significantly when you use the search feature in SAS® Web Report Studio
 |  |  |  |  |
If your SAS® Enterprise Business Intelligence deployment has hundreds of metadata folders, then performing a search in SAS Web Report Studio might significantly decrease the performance of the SAS Metadata Server.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply the hot fix, the search process is more focused on relevant object types. In addition, a new, customizable SAS Web Report Studio property enables the software to search folders in smaller groups when the total number of folders exceeds a specified number. By default, if the number of folders to search exceeds 500, then the folders are processed in groups of 200.
To modify these default processing values, perform these steps.
- In SAS® Management Console, expand Application Management ► Configuration Manager (► SAS Application Infrastructure).
- Right-click Web Report Studio 4.x, and select Properties.
- In the Properties dialog box, click the Advanced tab.
- Click Add to open the Define New Property dialog box.
- For the Property Name, enter wrs.searchTools.numFoldersToRequireChunking
- For the Property Value, enter a number. When the total number of folders that are being searched exceeds this number, SAS Web Report Studio breaks the search down into smaller groups of folders. The size of the folder groups is determined by the wrs.searchTools.folderChunkSize property.
- Click OK.
- Click Add again to open the Define New Property dialog box.
- For the Property Name, enter wrs.searchTools.folderChunkSize
- For the Property Value, enter the size of the folder group.
- Click OK twice to exit both dialog boxes and save the changes.
- To enforce the new settings, restart your web application server.
Note: A hot fix related to this issue is also available for the SAS Metadata Server. For best performance, apply the hot fix from this SAS note and from SAS Note 50673: Searching in SAS® Web Report Studio from the SAS Folders root folder might cause the SAS® Metadata Server to become unresponsive.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | z/OS | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 |
| Microsoft® Windows® for x64 | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 R2 | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Microsoft Windows XP Professional | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise x64 | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Professional 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Professional x64 | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows Vista | 4.3 | 9.2 TS2M3 | ||||
| Windows Vista for x64 | 4.3 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| 64-bit Enabled Solaris | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| HP-UX IPF | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Linux for x64 | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Solaris for x64 | 4.3 | 4.4_M1 | 9.2 TS2M3 | 9.4 TS1M1 | ||