Thanks in advance for your help.
I need to understand how to get a handle on what I consider is excessive paging on one of my servers.
The server is a 16 processor 64-bit Windows Server 2003 - datacenter version. we run SQL Server 2005 enterprise. It also runs an application from i2 called Demand Planner.
The paging spikes throughout the day usually to between 6,000 and 10,000 pages per second.
I monitor the memory using Idera's Diagnostic Manager and can see that when the high paging is happening the total memory is under 60GB. I have SQL Set to a max memory of 50GB leaving 14GB for OS and other processes. the i2 demand planner app is a 32bit app so it should not be using more then about 2gb.
What should I be looking at to determine the cause of this paging, and how should i get it under control.