SUPPORT / SAMPLES & SAS NOTES
Problem Note 36311: Performance issues might be encountered during the store synchronization process in SAS® Size Profiling
 |  |  |  |  |
Performance issues might be encountered during the store synchronization process in SAS Size Profiling.
The RUN_GEO_SYNC task of %SZPF_RUN_JOB synchronizes new stores with the generated and published profiles. As the number of rows in the str_grp_mbr (for generated profiles) and profile_cluster tables (for published profiles) increase as well as the number of size sets in the system, performance of the RUN_GEO_SYNC task degrades dramatically, and at some point it might hang the process.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft Windows Server 2003 Datacenter Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||