关闭

SQL SERVER内存压力判断

492人阅读 评论(0) 收藏 举报

通常情况下都是参考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压力或者碎片明显的服务器响应敏感。
1
0

猜你在找
【直播】计算机视觉原理及实战——屈教授
【套餐】深度学习入门视频课程——唐宇迪
【套餐】Hadoop生态系统零基础入门
【套餐】嵌入式Linux C编程基础
【套餐】2017软考系统集成项目——任铄
【套餐】Android 5.x顶级视频课程——李宁
【直播】广义线性模型及其应用——李科
【直播】从0到1 区块链的概念到实践
【直播】机器学习之凸优化——马博士
【套餐】微信订阅号+服务号Java版 v2.0--翟东平
查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:47377次
    • 积分:865
    • 等级:
    • 排名:千里之外
    • 原创:38篇
    • 转载:2篇
    • 译文:0篇
    • 评论:5条
    文章分类
    最新评论