When you use Microsoft SQL Server for your SAS Shared Services database, you might see slow performance for services in the SAS® Web Infrastructure Platform. The problem might occur in SAS® solutions that use SAS Workflow Services to manage business processes, such as SAS® Enterprise GRC, SAS® Enterprise Case Management, and SAS® Model Risk Management.
By default, SQL Server sends text values to the server in Unicode format instead of the native data type defined in the database. The implicit data conversion performed by SQL Server might cause a performance problem. To work around the problem, add the following property to the SAS Shared Services JDBC DataSource:
After adding the property, you must restart SASServer1 for the change to take effect.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Web Infrastructure Platform | z/OS | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 | ||
64-bit Enabled AIX | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 | ||
64-bit Enabled Solaris | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 | ||
HP-UX IPF | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 | ||
Linux for x64 | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 | ||
Solaris for x64 | 9.3_M2 | 9.4_M3 | 9.3 TS1M2 | 9.4 TS1M3 |