Viewing 12 posts - 16 through 27 (of 27 total)
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...
September 16, 2009 at 8:15 am
Paul White (9/15/2009)
BTW in case you missed Ian 'Capt' Scarlett's suggestions - I would encourage you to follow that good advice.
Paul
Yep, did that. I actually created separate perfmon consoles...
September 16, 2009 at 8:12 am
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...
September 15, 2009 at 12:01 pm
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...
September 15, 2009 at 10:06 am
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...
September 15, 2009 at 9:46 am
Matthew Bryant (9/15/2009)
I assume you have checked that you have correct indexes and they aren't really fragmented etc
Matthew, you are correct. Our issue is a bit more broad than...
September 15, 2009 at 9:39 am
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...
September 15, 2009 at 9:31 am
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...
September 14, 2009 at 11:50 am
Paul White (9/13/2009)
Can you answer the following questions please?
a) Is AWE enabled?
b) Does the account that SQL...
September 14, 2009 at 11:09 am
FYI
These changes have been running for several days on 3 of our environments without any problems. I think this solved the issue.
July 7, 2009 at 10:18 am
No encryption / permission gurus out there?
July 2, 2009 at 2:08 pm
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...
May 25, 2004 at 4:53 am
Viewing 12 posts - 16 through 27 (of 27 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy