SQLServer性能诊断与调优
以下是PrefTest工作室收集的关于SQLServer数据库性能诊断与优化方面的资源列表:
查询和分析存储过程性能的T-SQL
Some Transact SQL Queries to Analyze Stored Procedure Performance
常用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://www.cnblogs.com/danling/archive/2010/05/12/1733279.html
Preftest性能测试工作室为您提供SQLServer数据库性能问题诊断、分析和调优服务。
http://www.cnblogs.com/preftest