I've recently upgraded a SQL 2000 Server from 4GB to 8GB of RAM. PAE, 3GB and AWE were enabled - AWE was set to ~6GB. The target SQL memory was around 4.1GB and the total SQL memory in use matched that. The VERY odd thing is this did nothing at all to help performance. It almost seems that it hampered it. Any ideas out there?
Read about AWE in 2005...
It explains that the extra memory is not used for sorts and other things that you think it would be...
Bret.
|||
Sorry...I didn't make that clear...
In 2000 it is not used for sorts and other things that would increase performance...
No comments:
Post a Comment