Object	Performance Counters	Value	Reference	Comment
Memory	Memory: Available MBytes		>256	Available Mbytes stands for free unallocated RAM and displays the amount of physical memory, in MB, available to processes running on the computer
Memory	Memory: Pages/sec		Should not always more than 0	Pages/sec is the number of pages read from the disk or written to the disk to resolve memory references to pages that were not in memory at the time of the reference.
Buffer	SQL Server: Buffer Manager: Buffer Cache Hit Ratio		>90%	This counter is an indication of how many page requests were found in the buffer pool
	SQL Server: Buffer Manager: Free Pages		>500	This counter indicates how many free pages SQL Server has for new page requests.
	Sql Server：Buffer Manger:Page Life Expectancy		>300	This counter provides an indication of the time, in seconds, that a page is expected to remain in the buffer pool before being flushed to disk
	SQL Server Access Methods:Page Splits/sec		<20%	Number of page splits per second that occur as the result of overflowing index pages.
CPU	Processor: %Processor Time		Less than 90%	This counter determines the percentage of time each processor is busy.
CPU	System: Processor Queue Length		Should not more than 2	The processor queue length is a measure of how many threads are sitting in a ready state waiting on a processor to become available to run them
Physical Disk	PhysicalDisk: Avg. Disk sec/Read		Less than 0.02	The counter gives information about average value on how fast your disk operates under read activity.
	PhysicalDisk: Avg. Disk sec/Read		Less than 0.02	The counter gives information about average value on how fast your disk operates under write activity.
	PhysicalDisk: %Disk Time		Less than 90%	monitors the percentage of time that the disk is busy with read/write activity
	PhysicalDisk: Current Disk Queue Length		Less than 1.5 to 2 times the number of spindles that make up the physical disk	Check how many system requests are waiting for disk access.

ITPub博客

常用的性能计数器监控以及指标

最新文章