Database systems are widely used because of the integrative,sharable,independent character of its data and unitive management and control,and increasing number of applications and data size makes the operation and maintainance of information system more and more important.Power user electric energy data acquire system,which is supported by smart meters and communication networks,gathers various kinds of electrical data which provides precise massive statistics for the operation management,and becomes the kernel component of the Smart Grid.With full coverage of smart meters and deepen application of the system,smart meters access quickly,power user electric energy data acquire system master bears the increasing pressure from many aspects such as debugging,access and acquisition,the load of production database servers maintained high or even broke down,which has a strong impact on its operation life and brings baneful effects on the application and indicators of escalation electric acquisition business.Operation indicators monitoring and performance analysis methods are provided in this paper after presenting physical framework,expositing arisen problems,and analyzing and summarizing server logs and database workload repositories of the system master,so as to promote operation and maintenance efficiency,and guarantee the stability of the system.Meanwhile,Corresponding methods of system performance optimization from multiple dimensions are given in this paper.The effect of reducing the system load is significant,which establishes a solid foundation to promote management efficiency,guarantee application security and deepen massive data mining of the acquire system. |