we have a microsoft SQL server 2005 standard edition running on a Windows server 2003 enterprise edition box which has a quad core processor and 4GM of RAM. i've set the min memory at 1000mb and max memory at 3000mb on the SQL configuration but havent enabled the AWE option as i only have 4GB to work with. But still the users report that the server is performing slow and when i look at the page file usage its always over 2GB. Can anyone of you tell me what i should do? will increasing memory and enabling AWE afterwards help?
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server... So if you are the accidental DBA, or, simp…