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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.