SQLServer性能测试诊断分析与优化

发布时间：2020-12-12 14:33:30 所属栏目：MsSql教程来源：网络整理

导读：查询和分析存储过程性能的T-SQL Some Transact SQL Queries to Analyze Stored Procedure Performance http://www.perfwolf.com/The_Load ... lyzespperforman.HTM 常用SQL性能计数器： Understanding SQL Performance Counters http://www.extremeexperts.c

查询和分析存储过程性能的T-SQL
Some Transact SQL Queries to Analyze Stored Procedure Performance
http://www.perfwolf.com/The_Load ... lyzespperforman.HTM

常用SQL性能计数器：
Understanding SQL Performance Counters
http://www.extremeexperts.com/sql/articles/sqlcounters.aspx

LoadRunner监控SQLServer：
http://blog.csdn.net/Testing_is_ ... 286548.aspx#1526223

《HP Performance Monitoring Best Practices 》Database Resources Monitoring - MS SQL Server Monitoring

监视SQLServer性能：
Using Performance Monitor
http://www.sql-server-performanc ... tor_general_p1.aspx

SQLServer监控工具 - SQL Response
http://www.red-gate.com/products/SQL_Response/index.htm

免费的SQLServer性能监控工具 - SQL Check
https://www.idera.com/Products/Free-Tools/SQL-check/

索引优化：
《Performance Testing Microsoft.NET Web Applications》 Chapter8

SQLServer性能优化提示：
General SQL Server Performance Tuning Tips
http://www.sql-server-performance.com/tips/gen_tips_p1.aspx

如何减少SQLServer的阻塞：
How to Minimize SQL Server Blocking
http://www.sql-server-performance.com/tips/blocking_p1.aspx

如何减少SQLServer的死锁：
Reducing SQL Server Deadlocks
http://www.sql-server-performance.com/tips/deadlocks_p1.aspx

如何减少SQLServer锁？
Reducing SQL Server Locks
http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx

SQLServer查询执行计划的分析：
SQL Server Query Execution Plan Analysis
http://www.sql-server-performanc ... an_analysis_p1.aspx

SQLServer查询分析器的使用：
Using SQL Server Query Analyzer
http://www.sql-server-performance.com/tips/query_analyzer_p1.aspx

SQLServer计数器的提示：
Tips for Using SQL Server Performance Monitor Counters
http://www.sql-server-performanc ... or_coutners_p1.aspx

通过网络计数器诊断网络瓶颈：
Tips for Using Performance Monitor Network Counters
http://www.sql-server-performanc ... rk_counters_p1.aspx

通过内存计数器诊断内存瓶颈：
Tips for Using Performance Monitor Memory Counters
http://www.sql-server-performanc ... ory_counter_p1.aspx

通过I/O计数器诊断I/O瓶颈：
Tips for Using Performance Monitor I/O Counters
http://www.sql-server-performanc ... io_counters_p1.aspx

通过CPU计数器诊断CPU瓶颈：
Tips for Using Performance Monitor CPU Counters
http://www.sql-server-performanc ... cpu_counter_p1.aspx

SQL Server性能调优案例分析：
SQL Server Performance Case Studies
http://www.sql-server-performance.com/tips/case_studies_p1.aspx

SQLSever事件探查器跟踪文件的查询方法：
the following query returns all events with greater than 1000 milliseconds duration from trace.trc file in a table format:
SELECT * FROM ::fn_trace_gettable(‘c:trace.trc’,default) WHERE Duration > 1000
For more information,see "fn_trace_gettable" in SQL Server Books Online.

RML Utilities：
RML（Replay Markup Language）是MS SQL Server产品支持服务团队内部开发使用的一个Trace分析工具
http://blogs.msdn.com/b/psssql/a ... erver-released.aspx
http://www.cnblogs.com/danling/archive/2010/05/12/1733279.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!