SQLServer性能诊断与调优

 

以下是PrefTest工作室收集的关于SQLServer数据库性能诊断与优化方面的资源列表：

 

查询和分析存储过程性能的T-SQL

Some Transact SQL Queries to Analyze Stored Procedure Performance

http://www.perfwolf.com/The_Load_and_Performance_Teste/SQLQueriesToAnalyzeSPPerforman/sqlqueriestoanalyzespperforman.HTM

 

常用SQL性能计数器：

Understanding SQL Performance Counters

http://www.extremeexperts.com/sql/articles/sqlcounters.aspx

 

LoadRunner监控SQLServer：

http://blog.csdn.net/Testing_is_believing/archive/2010/02/03/5286548.aspx#1526223

 

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

 

监视SQLServer性能： 

Using Performance Monitor

http://www.sql-server-performance.com/tips/performance_monitor_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-performance.com/tips/query_execution_plan_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-performance.com/tips/sql_server_performance_monitor_coutners_p1.aspx

 

通过网络计数器诊断网络瓶颈：

Tips for Using Performance Monitor Network Counters

http://www.sql-server-performance.com/tips/performance_monitor_network_counters_p1.aspx

 

通过内存计数器诊断内存瓶颈：

Tips for Using Performance Monitor Memory Counters

http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx

 

通过I/O计数器诊断I/O瓶颈：

Tips for Using Performance Monitor I/O Counters

http://www.sql-server-performance.com/tips/monitor_io_counters_p1.aspx

 

通过CPU计数器诊断CPU瓶颈：

Tips for Using Performance Monitor CPU Counters

http://www.sql-server-performance.com/tips/performance_monitor_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/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx 

http://www.cnblogs.com/danling/archive/2010/05/12/1733279.html

 

 

 

 

Preftest性能测试工作室为您提供SQLServer数据库性能问题诊断、分析和调优服务。

http://www.cnblogs.com/preftest