October 9, 2014 at 11:50 pm
Hi All,
We have a SQL Server 2008 R2. Below are the performance counters we ran to test memory levels.
Memory\Available MBytes539.6707581
PhysicalDisk(_Total)\Disk Reads/sec40.83330242
SQLServer:Buffer Manager\Page life expectancy2430.698917
SQLServer:Buffer Manager\Page reads/sec202.9084788
SQLServer:Memory Manager\Total Server Memory (KB)14680064
SQLServer:Memory Manager\Target Server Memory (KB)14680064
SQLServer:Memory Manager\Optimizer Memory (KB)12010.88809
SQLServer:Memory Manager\Memory Grants Pending0
As per some blogs SQLServer:Buffer Manager\Page reads/sec should be less than 90. But on this server it is 202. Looks like memory pressure. This Server is running with log shipping on one database and on the same database trying to implement DR setup with asynchronous DB Mirroring.
Total Server RAM Size is 16GB.
14GB is assigned to SQL Server.
Please let me know whether we need to suggest add more RAM. If yes how much and justification.
Thank you
Thank You.
Regards,
Raghavender Chavva
October 10, 2014 at 6:07 am
I'd suggest looking at a few more pieces of information. What are your wait statistics like. And, check this article for a few more[/url]. Note, the query that shows you out of memory messages needs to be adjusted for 2008. There's a post with the fix in the comments.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply