资源描述：
《著名外企 sql server performance dba必读》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、XSSCCGlobalSQLPerformanceforWGQ(SQLServer2000)Version1.0/2006.02SQLPerformance(SQLServer2000)日期:2006年2月5.1-9,,services,andmakethecitymoreattractive,strengtheningpublictransportinvestment,establishedasthebackboneoftheurbanrailtransitmulti-level,multi-functionalpublictransportsystem,thusprotecti
2、ngtheregionalpositionandachieveConfidentialPage25XSSCCGlobalSQLPerformanceforWGQ(SQLServer2000)Version1.0/2006.02版权本文档提供给XSSCCGlobal内部使用，不能作为商业用途。5.1-9,,services,andmakethecitymoreattractive,strengtheningpublictransportinvestment,establishedasthebackboneoftheurbanrailtransitmulti-level,multi-f
3、unctionalpublictransportsystem,thusprotectingtheregionalpositionandachieveConfidentialPage25XSSCCGlobalSQLPerformanceforWGQ(SQLServer2000)Version1.0/2006.02目录1前言52基线基本概念62.1计数器62.2主要监视对象62.3主要系统计数器63基线建立83.1检测条件设置83.2服务器硬件配置83.2.1Server:172.22.119.13783.2.2Server:172.22.119.14083.2.3Server:172
4、.22.120.893.3性能数据93.4内存性能分析103.4.1计数点103.4.2Server:172.22.119.137103.4.3Server:172.22.119.140113.4.4Server:172.22.120.8123.4.5小结133.5CPU性能分析133.5.1计数点133.5.2Server:172.22.119.137133.5.3Server:172.22.119.140133.5.4Server:172.22.120.8143.5.5小结143.6硬盘性能分析143.6.1计数点143.6.2Server:172.22.119.137143.
5、6.3Server:172.22.119.140153.6.4Server:172.22.120.8165.1-9,,services,andmakethecitymoreattractive,strengtheningpublictransportinvestment,establishedasthebackboneoftheurbanrailtransitmulti-level,multi-functionalpublictransportsystem,thusprotectingtheregionalpositionandachieveConfidentialPage25XS
6、SCCGlobalSQLPerformanceforWGQ(SQLServer2000)Version1.0/2006.023.6.5小结173.7SQL其他性能分析173.7.1计数点173.7.2Server:172.22.119.137173.7.3Server:172.22.119.140183.7.4Server:172.22.120.8203.7.5小结213.8总结214解决意见234.1磁盘234.1.1概念：234.1.2检测结果：234.1.3建议：234.2索引244.2.1概念：244.2.2检查结果：244.2.3建议：254.3数据库日志文件254.3.
7、1概念：254.3.2检查结果：254.3.3建议：255.1-9,,services,andmakethecitymoreattractive,strengtheningpublictransportinvestment,establishedasthebackboneoftheurbanrailtransitmulti-level,multi-functionalpublictransportsystem,thusprotectingtheregionalposi
