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

 

 

 

 

posted on 2010-09-06 15:58  preftest  阅读(1972)  评论(0编辑  收藏  举报

导航