We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH is always high and the procedure cache is always around 700mB. Durring production hours we have over 6000 connections to sql server (500 users).
1. What is wrong here?
2. Do you think changing the "Parameterization" database option to forced would help?
Please take a look at the both images for the PAGEIOLATCH_SH and the Procedure Cache. Thank you for your help.
Software/Hardware used: SQL SERVER 2005 Enterprise 32-bit, Windows SERVER 2003 Enterprise 32-bit