Performance Counter on Memoery, IO, CPU

http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx

http://www.sql-server-performance.com/tips/monitor_io_counters_p1.aspx

http://www.sql-server-performance.com/tips/performance_monitor_cpu_counter_p1.aspx

 

 

Issue

Performance Counter

Monitor Type

Normal Value

Solution

the number of pages per second that are paged out of RAM to disk, or paged into RAM from disk.

Memory Object: Pages/Sec

Memory

paging will average near zero.

The more RAM a server has, the less paging it has to perform.

check to see if your SQL Server has enough physical RAM

Memory Object: Available Bytes counter.

Memory

 

This value should be greater than 5MB. If not, then your SQL Server needs more physical RAM.

how much the mssqlserver service is currently using

SQLServer:Memory Manager: Total Server Memory (KB)

Memory

 

 

how much memory SQL Server would like to have in order to operate efficiently

SQLServer:Memory Manager: Target Server Memory (KB) .

Memory

 

 

each disk array

 

if you have an array of 6 physical disks, and the Avg. Disk Queue Length is 10 for a particular array, then the actual Avg. Disk Queue Length for each drive is 1.66 (10/6=1.66), which is within the recommended 2 per physical disk.

PhysicalDisk Object: Avg. Disk Queue Length

I/O

If the Avg. Disk Queue Length exceeds 2 for continuous periods (over 10 minutes or so) for each individual disk drive in an array, then you probably have an I/O bottleneck for that array

If your server has an I/O bottleneck, consider these potential solutions: adding drives to an array (if you can), getting faster drives, adding cache memory to the controller card (if you can), using a different version of RAID, getting a faster controller, or reducing the load on the server.

how busy a physical array is (not a logical partition or individual disks in an array)

Physical Disk Object: % Disk Time counter

 

% Disk Read Time counter

 

% Disk Write Time

I/O

the % Disk Time counter should run less than 55%. If this counter exceeds 55% for continuous periods (over 10 minutes or so), then your SQL Server may be experiencing an I/O bottleneck.

 

the utilization of each individual CPU

Process Object: % Processor Time

CPU

if the total CPU utilization of your server exceeds 80% for continuous periods (over 10 minutes or so), then you may have a CPU bottleneck.

 

Processor Queue Length

System Object: Processor Queue Length

CPU

If the Processor Queue Length exceeds 2 per CPU for continuous periods (over 10 minutes or so), then you probably have a CPU bottleneck.

 

 

System: % Total Privileged Time

 

If you notice that the System: % Total Privileged Time counter is running at greater than 20%, this is an indication that your server's I/O may be bottlenecked.

 

 

(一)系统功能说明 1、  用户管理系统主要功能:普通用户和管理员用户功能。 2、  普通用户:可以查看全部用户信息,按用户年龄查看个人信息、修改自己的信息;可以尝试增加按照名字查看个人信息。 3、  管理员:删除用户、增加用户、修改用户、按ID查看用户、查看全部信息。可以尝试增加按照名字查看个人信息。 4、  用户的实体类的特征:用户ID编号、用户名、用户密码、家庭地址、年龄、电话等 (二)实现说明: 1.定义User类,用户ID编号、用户名、用户密码、家庭地址、年龄、电话、是否管理员。定义有参和无参的两个构造方法,定义toString()方法方便打印对象信息。 2.系统中定义UserDAO类,定义密码错误次数属性成员;定义以下成员方法:查看全部用户信息、按用户年龄查看个人信息、按名字查看用户信息、按照ID查看信息、根据用户名以及密码修改用户的信息、根据用户编号修改信息、删除用户、增加用户、根据用户名和密码登陆的功能。 3、模拟数据存储使用类Memoery中的userlist数组实现。该类中定义长度为100的User类型的静态数据成员,用于存放数据信息;定义用于描述数组中元素个数的静态数据成员;为了模拟实现数据存储,定义不含参数的构造函数,实现通过定义若干用户对象初始化数组成员中的一部分,其余成员也初始化为user对象,仅为对象是否管理员赋值为false。 4.定义Test类,在main方法中实现功能操作。要注意能循环操作,即输入用户名和密码一次,能进行多种功能。使用循环语句实现。
06-11
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值