Microsoft SQL Server manages memory dynamically based on the memory requirements of server load. But sometime you experience problem such as…
- The performance of SQL Server decreases suddenly.
- A computer that is running SQL Server stops responding for a short time.
- A time-out occurs for applications that connect to SQL Server.
- Problems occur when you run even simple commands or use applications on the system
This problem occurs because the Windows operating system pages out the working set of the SQL Server process. While looking for workaround for this problem I came across a very good article “How to reduce paging of buffer pool memory in the 64-bit version of SQL Server” by Microsoft Support Team which solved my problem.