Report(数据库性能检测).docVIP

The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication and is subject to change at any time without notice to you. This document and its contents are provided AS IS without warranty of any kind, and should not be interpreted as an offer or commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT. The descriptions of other companies’ products in this document, if any, are provided only as a convenience to you. Any such references should not be considered an endorsement or support by Microsoft. Microsoft cannot guarantee their accuracy, and the products may change over time. Also, the descriptions are intended as brief highlights to aid understanding, rather than as thorough coverage. For authoritative descriptions of these products, please consult their respective manufacturers. This deliverable is provided AS IS without warranty of any kind and MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, OR OTHERWISE. All trademarks are the property of their respective companies. ?2009 Microsoft Corporation. All rights reserved. Microsoft and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. Page PAGE \* roman ii TITLE 广东联通数据库性能检查报告 SUBJECT Prepared for 广东联通公司 2009年1月15日 Version 1.0 Prepared by 邱诗扬 DOCPROPERTY AuthorPosition Premier Field Engineer shiyang.qiu@  Page PAGE \* roman iii 目录 TOC \o 1-2 \h \z \u 1 总结 1 2 数据收集和分析工具 2 3 发现的问题与建议 3 3.1 内存不足 3 3.2 磁盘慢 3 3.3 编译，重编译过多 4 3.4 不成比例的连接数 4 3.5 过高的登录注销数 4 3.6 索引设计和维护 5 3.7 阻塞类型分析 5 3.8 在选择语句中使用用户函数 6 3.9 使用游标 7 3.10 JOIN没有使用ON从句 7 3.11 测试环境和生产环境的混合 7 3.12 不恰当的文件