Hi, I have a 32 BIT sql 2000 server with a database of +-300 GB. (AWE not enabled) on a IBM blade server HS21
We often have performance drops. ( large query can take from 10 till 300 sec).
When i look at the statistics is see a low pagelife expectancy.
What are the counters i should look for to exactly find my bottleneck?
Will enabling the AWE option and using all the physical ram (8GB) be a solution?
in attachment an example of values.