原创 2013年12月02日 16:46:19

通常情况下都是参考SQLServer:Buffer Manager\Buffer Cache Hit Ratio的数值。

SQLServer:Buffer Manager\Buffer Cache Hit Ratio:

"Percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups over the last few thousand page accesses. After a long period of time, the ratio moves very little. Because reading from the cache is much less expensive than reading from disk, you want this ratio to be high. Generally, you can increase the buffer cache hit ratio by increasing the amount of memory available to SQL Server."

但是某些时候SQLServer:Buffer Manager\Buffer Cache Hit Ratio并不能正确反映内存压力,我们必须借助于其它参数来进行判断。

  • Page reads/secNumber of physical database page reads that are issued per second. This statistic displays the total number of physical page reads across all databases. Because physical I/O is expensive, you may be able to minimize the cost, either by using a larger data cache, intelligent indexes, and more efficient queries, or by changing the database design
  • Free PagesTotal number of pages on all free lists (free lists track all of the pages in the buffer pool that are not currently allocate to a data page, and are therefore available for usage immediately)
  • Page Life ExpectancyNumber of seconds a page will stay in the buffer pool without references
  • Free List Stalls/secNumber of requests per second that had to wait for a free page


因为SQL SERVER预读机制的存在,通常情况下SQLServer:Buffer Manager\Buffer Cache Hit Ratio只是对存在明显I/O压力或者碎片明显的服务器响应敏感。

SqlServer内存瓶颈分析--SQLServer:Buffer Manager

SELECT TOP 312 * FROM sys.dm_os_performance_counters where object_name ='SQLServer:Buffer Manager' ...

SQL Server 性能调优(方法论)

SQL Server 性能调优(方法论)     目录 确定思路 wait event的基本troubleshooting 虚拟文件信息(virtual file Statistics...

Sql Server CPU压力(读书笔记)

确认CPU瓶颈 System-Processor Queue Length 处理器的任何对列豆浆影响到用户体验,任何对列都将不可避免的影响总体性能。如果对列长度平均值大于3,则可以将之视为一个相关原...


  • 2017年03月02日 14:22
  • 56KB
  • 下载

sql server (awe)大内存配置办法

通过网络查找资料以及测试整理,现将sql server 大内存配置办法贴出来。SQL服务使用的内存一般默认不会超过1.8G,因此就算你的服务器有N个G的内存,也未见访问会变快很多。这就是很多由于数据大...
  • galen26
  • galen26
  • 2011年01月19日 15:52
  • 337

剑儿SQL Server内存释放器 V3.3

  • 2012年08月11日 11:20
  • 180KB
  • 下载

sql server实例内存使用统计

SQL SERVER内存按存放数据的类型,大概可以分为三类: 1、buffer pool,存放数据页面的缓冲区,sql server数据都是存放在一个个8K的页面里,当用户需要使用这个页面上的数据时...

SQL Server 2005内存调优

  • 2008年03月17日 20:42
  • 882KB
  • 下载
您举报文章:SQL SERVER内存压力判断