Paul White (9/15/2009)

It would be interesting to know a rough average and range for the page life expectancy you are seeing, together with an average for the buffer cache hit...

Yep, did that. I actually created separate perfmon consoles...

Ok - so we did the partition alignment. Not the blockbuster breakthrough I was hoping to see. Definitely still seeing a lot of PAGEIOLATCH_(xx) types - mainly SH...

Another silly question. If I am on a 32 bit OS, do I need the /3GB switch so SQL Server can allocate > 2 GB or will the /PAE...

Paul - keep throwing links my way if you have them! The last one I think is good. Although it eludes to my issue could either be memory...

Matthew, you are correct. Our issue is a bit more broad than...

Paul, here are the counters you asked for. Between my last post and now here are the things that have changed:

AWE is configured for a max of 3.5 GB...

Interesting outcome today. We had one of our RAID drives recreated so the partitions were aligned. I'm seeing a significant improvement in read/write times as well as the...

Paul White (9/13/2009)

---

It all sounds very much like a lack of buffer pool memory.

Can you answer the following questions please?

a) Is AWE enabled?

b) Does the account that SQL...

FYI

These changes have been running for several days on 3 of our environments without any problems. I think this solved the issue.

No encryption / permission gurus out there?

Larry,

I agree with Col.  You always want to make sure that you have the least amount of traffic going down the wire.  Also, depending on the reporting tool you're using...