Poor SQL Server performance on 64-Bit operating systems
Follow this procedure to correct poor SQL Server performance on 64-Bit operating systems.
About this task
Note: If you are using Discover version 8.8 or later, SQL Server 2005 is no longer
supported. For more information, see "Supported SQL Server Versions" in the Unica Discover Databases Guide.
Discover databases are designed to take advantage of 64-bit operating system capabilities. However, because of a Microsoft™ issue, performance issues may arrive when running SQL Server 2005 on a 64-bit version of Windows™. These issues can include the following:
- The performance of SQL Server 2005 decreases suddenly.
- SQL Server 2005 stops responding for a short time.
- A timeout occurs for applications that connect to SQL Server 2005.
- Problems occur when you run even simple commands or use applications on the system.
The issue may be that 64-bit Windows operating system is paging out the working set of the SQL Server process. When the SQL Server process reaches 50 percent of the memory that is allocated for the process on SQL Server 2005 SP2 or later, error messages may begin appearing in the SQL Server error log.
To fix the issue: