db性能指标（DB performance index）.doc

db性能指标（DB performance index） SQL Server Note: the following indicators are taken from the performance counters provided by SQL Server itself. Index name, index description, index range, index unit The performance counters included in the 1.SQL Server access method (Access, Methods) object Full table scan / sec (Full Scans/sec) refers to the number of full table scans per second. A full table scan can be either a basic table scan or a full index scan. Since full table scans require a lot of time, the full table scan frequency is too high, which can affect performance. If the value of this index is higher than 1 or 2, the query designed should be analyzed to determine whether the full table scan is really necessary and whether the SQL query can be optimized. Times per second The performance counters included in the buffer manager (Buffer, Manager) object in 2.SQL Server Buffer cache hit rate (Buffer Cache) "Hit Ratio%" means the percentage of pages found in the cache cache that do not need to be read from disk. The ratio is the ratio of the total number of cache hits to the total number of cache lookups. After a long period of time, the rate has changed little. Since the amount of data read from the cache is much less expensive than the data read from the disk, the rate is generally expected to be higher. The value of the index is best to be 90% or higher. You can usually increase the value of the index by increasing the amount of memory available to the SQL Server. Increase the memory until the value of this indicator is consistently above 90%, indicating that more than 90% of the data requests can obtain the required data from the data buffer. % Page / sec read (Page Reads/sec) refers to the number of physical database page reads per second. This index mainly examines the frequency of data reading from disk. Since physical I/O can take a lot of time, physical I/O should be reduced as much as possible to improve performance. The value of this indicator should be as s