基于VBA技术实现远程服务器性能监测  

Implementation on Remote Server Performance Monitoring Based on VBA Technology

作　　者：高子航 

机构地区：[1]石家庄市第二中学,河北石家庄051430

出　　处：《计算机与网络》2014年第23期64-67,共4页Computer & Network

摘　　要：针对远程服务器性能监测问题,对几种传统监测手段优缺点进行了比较,详细介绍了利用VBA编程技术调用Windows管理工具(WMI)对象的工作原理及具体实现。通过自动提取服务器性能参数及资源信息并汇总至Excel中,用Excel自身强大的计算统计功能并以图表的方式给出了服务器性能使用情况及资源利用率。应用实践表明,利用VBA技术可有效实现远程服务器性能监测。Aiming at the problems of remote server performance monitoring, this paper compares the advantages and disadvantages of several traditional monitoring methods, introduces in detail the operating principles and implementation for calling Windows Management Instrumentation （WMI） object by using VBA programming technology. By automatically extracting the server performance parameters and the resource information, summarizing to Excel and using Excel＇s powerful statistical calculation function, this paper gives the server perfromance usage situation and resource utihzation rate by the form of graph. The application practice shows that the remote server performance monitoring can be effectively implemented by using VBA technology.

关 键 词：VBA EXCEL 性能监测 资源利用率 WMI 

分 类 号：TP368.5[自动化与计算机技术—计算机系统结构]