Easy to master the way of database management--one of operation and maintenance patrol (server status and hardware indicators)

Objective

To do daily inspection is an important step of database management and maintenance, and it is necessary to register each inspection date and result, and may need to make a inspection report.

SQL Expert Cloud (www.zhuancloud.com) makes it easy to master the path of database management

This series is designed to address some common problems:

• I don't know what to patrol.

• Don't know how to get a quick checkup

• Machine Too much physical examination trouble

• Difficult to generate reports, no visual rendering of results

The hardware of the server most of the situation will have a hardware group dedicated to patrol, but as a database Server Manager, we must always be vigilant, in case the hardware brother a little lazy, you manage the data server problems can not be found in time, or hardware configuration shrinkage caused by performance problems, This is also a necessary reason for hardware inspection.

Overview of the overall situation

1. In the "check"-"All" or "Environment" page you can view the overall system hardware resource usage. If there is a problem with the hardware that affects the database, the detection can cause alarm problems.

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116113631076-2061216236. PNG "style=" border:0px; "/>

2. On the System-hardware page, you can view detailed information such as processor, physical memory, disk, network card, and so on.

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116114050638-2018480648. PNG "width=" 990 "height=" 409 "style=" border:0px; "/>

Operating Environment and version

Viewing operating system Information and SQL Server information in system-software environment

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116142451951-1888778613. PNG "style=" border:0px; "/>

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116142626076-918974411. PNG "style=" border:0px; "/>

Disk usage

Disk space does not have to be too much to describe when disk space needs to be planned and cleaned up in time, it is necessary to plan the disk based on the incremental situation of the database (the inspection method of data increment will be introduced in the database patrol)

1. View disk space graphically on the "overview" page of the SQL expert cloud

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116112505560-485671093. PNG "style=" border:0px; "/>

2. Detailed information on disk usage and physical disk partitioning can be viewed in system-hardware-disk

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116113150607-713915538. PNG "width=" 960 "height=" 386 "style=" border:0px; "/>

3. Disk Pressure analysis

Disk pressure can be diagnosed by "performance counters" (See: System disk Stress analysis)

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116115020092-467433169. PNG "width=" "height=" "style=" border:0px; "/>

Memory usage

1. In the SQL Expert Cloud "Overview" page, you can graphically view the server's current available memory situation.

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116114430217-285134844. PNG "style=" border:0px; "/>

2. On the System-hardware page, you can view the physical memory details.

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116114050638-2018480648. PNG "width=" 990 "height=" 409 "style=" border:0px; "/>

3. Analyze Memory Pressure

Memory pressure can be diagnosed by "performance counters" (See: System Memory Pressure analysis)

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116114820013-922236045. PNG "width=" 1141 "height=" 510 "style=" border:0px; "/>

Processor condition

1. View the server CPU graphically in the "Overview" or "Performance counters" page of the SQL expert cloud.

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116115210248-565910844. PNG "style=" border:0px; "/>

Whether 2.CPU can be fully identified or used

The check items-all or environment page provides a holistic view of the system hardware resource usage. A warning occurs if the CPU cannot be CPU or the number of CPUs detected is less than the system configuration.

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116113631076-2061216236. PNG "style=" border:0px; "/>

Network environment

1. On the System-hardware page, you can view the details of the material card.

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116115544060-1189839223. PNG "width=" "height=" "style=" border:0px; "/>

2. On the Performance Counters page, view the system network pressure situation

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/832221/201611/832221-20161116115712326-822100112. PNG "width=" "height=" 577 "style=" border:0px; "/>

Summarize

Daily inspection is designed to detect system problems and potential risks in time, is any database administrator, operation and maintenance personnel necessary operations, personal recommendations of the core system at least once a month of detailed physical examination, auxiliary system every three months at least a physical examination, to ensure the normal operation of the system, eliminate the hidden danger, OPS personnel do not play the role of firefighters, It is no longer difficult for database operations management to start.

This article is from the "11768549" blog, please be sure to keep this source http://11778549.blog.51cto.com/11768549/1880647

Easy to master the way of database management--one of operation and maintenance patrol (server status and hardware indicators)