The instance has AWE enabled, is the view this is better to have on than off ?
32 bit or 64 bit SQL?
Whilst i was in perform i noticed the pages/sec was quite spiky with peaks of around 1500/sec.
Which pages/sec counter? (there's more than one of them and they mean very, very different things)
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass