Buffer Manager Page reads/sec & Physical memory

anushahanna
anushahanna used Ask the Experts™
on
If there are too many physical database page reads (50K for example), will more physical memory the solution? Is there anything else that can be checked/explored for the high reads.

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> If there are too many physical database page reads (50K for example), will more physical memory the solution?

Not required unless otherwise you suffer from memory contention.
Having more memory will ensure that the frequently used objects ( including result sets) are hold in cache for better performance..
And hence adding more memory is not just a step to resolve this one out..

And Yes, if it is frequently hitting a single table, then make sure that it stays in the buffer for a longer period of time by including more memory.

>> Is there anything else that can be checked/explored for the high reads

Hope you are aware of using perfmon for high Disk IO activity and use Profiler trace to find out whether most of the queries have High reads and writes or not..

Author

Commented:
Thanks.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial