GlennBerry (3/7/2011)
The main interesting thing I saw is that you are on Build 2714, which is fairly old (SP1 CU2). I would want to get SP2 CU2, Build 4272 installed. If you could run my full set of diagnostic queries, I would know a lot more...Do you have "Optimize for ad-hoc workloads" enabled for the instance?
In this installement, we are only focusing on the properties revealed by SQL Monitor. I think running your diagnostic queries would work great for another part of this article series. I'll get back with you when we are ready to do this.
Brad M. McGehee
DBA