监控SQLSERVER时,能增加度量。但是只有系统资源相关的度量有数据,而和sqlserver相关的度量却没有数据。
解决方法:
改为在System Resource Graphs中通过添加Windows Resources的方式添加SQLServer计数器则可以,添加的对象是SQLServer:General Statistics,计数器选User Connections
应该收集哪些SQLServer的性能指标?
一般需要监控以下指标:
1) SQLServer资源监控中指标缓存点击率(Cache Hit Ratio),该值越高越好。如果持续低于80%,应考虑增加内存。
2) 如果Full Scans/sec(全表扫描/秒)计数器显示的值比1或2高,则应分析你的查询以确定是否确实需要全表扫描,以及SQL查询是否可以被优化。
3) Number of Deadlocks/sec(死锁的数量/秒):死锁对应用程序的可伸缩性非常有害,并且会导致恶劣的用户体验。该计数器的值必须为0。
4) Lock Requests/sec(锁请求/秒),通过优化查询来减少读取次数,可以减少该计数器的值。
具体可参考:
1、Controller帮助文档:
The following table describes the default counters that can be monitored on version 6.5 of the SQL Server:
Measurement
Description
% Total Processor Time (NT)
The average percentage of time that all the processors on the system are busy executing non-idle threads. On a multi-processor system, if all processors are always busy, this is 100%, if all processors are 50% busy this is 50% and if 1/4 of the processors
are 100% busy this is 25%. It can be viewed as the fraction of the time spent doing useful work. Each processor is assigned an Idle thread in the Idle process which consumes those unproductive processor cycles not used by any other threads.
% Processor Time (Win 2000)
The percentage of time that the processor is executing a non-idle thread. This counter was designed as a primary indicator of processor activity. It is calculated by measuring the time that the processor spends executing the thread of the idle process in each
sample interval, and subtracting that value from 100%. (Each processor has an idle thread which consumes cycles when no other threads are ready to run). It can be viewed as the percentage of the sample interval spent doing useful work. This counter displays
the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time the service was inactive, and then subtracting that value from 100%.
Cache Hit Ratio
The percentage of time that a requested data page was found in the data cache (instead of being read from disk).
I/O - Batch Writes/sec
The number of 2K pages written to disk per second, using Batch I/O. The checkpoint thread is the primary user of Batch I/O.
I/O - Lazy Writes/sec
The number of 2K pages flushed to disk per second by the Lazy Writer.
I/O - Outstanding Reads
The number of physical reads pending.
I/O - Outstanding Writes
The number of physical writes pending.
I/O - Page Reads/sec
The number of physical page reads per second.
I/O - Transactions/sec
The number of Transact-SQL command batches executed per second.
User Connections
The number of open user connections.
2、《Performance Monitoring Best Practices》中的MS SQL Server Monitoring部分。
安装LR9.51补丁后可以在C:\Program Files\HP\LoadRunner\help目录中找到Monitoring_BP.pdf文件。
3、参考:
分享到:
相关推荐
LoadRunner对数据库的监控指标(sqlserver/oracle/db2)
使用LoadRunner监控Linux方法 使用LoadRunner监控Linux方法 使用LoadRunner监控Linux方法 使用LoadRunner监控Linux方法
使用Loadrunner监控DB2数据库.
介绍loadrunner监控 unix/linux所需要进程, 以及如何启动进程
loadrunner监控linux必备插件
loadrunner监控tomcat、监控 tomcat、监控web服务器, 利用loadrunner脚本监控tomcat。
loadrunner 监控Linux资源服务开启
LoadRunner监控window系统各项指标详解LoadRunner监控window系统各项指标详解
loadrunner监控windows和linux资源 loadrunner监控windows和linux资源
LoadRunner监控Linux与Windows方法
LoadRunner监控Linux rsh rpm安装包
Tomcat环境部署 Loadrunner 监控tomcat
利用loadrunner工具编写脚本,监控mysql,在场景运行中可以左证mysql的运行状态
LoadRunner监控Windows资源时,常常遇到无权限的问题,会报错显示不能链接等。本文档,帮助大家解决LoadRunner 监控Windows资源时无权限问题。希望对大家有所帮助。
自我总结LoadRunner监控UNIX(CentOS)系统资源过程
使用LoadRunner监控Apache的步骤使用LoadRunner监控Apache的步骤
LoadRunner监控Windows和Linux常见问题.doc LoadRunner监控Windows和Linux常见问题.doc LoadRunner监控Windows和Linux常见问题.doc
Loadrunner监控linux _ RSH_RPM安装包集合 ..
LoadRunner监控到的Linux服务器CPU的一些主要指标说明.pdf