Sqlserver Performance Diagnosis and Optimization

 

The following is a list of resources collected by preftest about sqlserver database performance diagnosis and optimization:

 

T-SQL for querying and analyzing stored procedure performance

Some transact SQL queries to analyze stored procedure performance

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

 

Common SQL Performance counters:

Understanding SQL Performance counters

Http://www.extremeexperts.com/ SQL /articles/sqlcounters.aspx

 

LoadRunner monitoring 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

 

Monitor sqlserver performance:

Using Performance Monitor

Http://www.sql-server-performance.com/tips/performance_monitor_general_p1.aspx

 

Sqlserver monitoring tool-SQL response

Http://www.red-gate.com/products/ SQL _Response/index.htm

 

Free sqlserver performance monitoring tool-SQL check

Https://www.idera.com/Products/Free-Tools/SQL-check/

 

Index optimization:

Performance testing Microsoft. NET web applications chapter8

 

SQL Server performance optimization tips:

General SQL server performance tuning tips

Http://www.sql-server-performance.com/tips/gen_tips_p1.aspx

 

How to Reduce the blocking of sqlserver:

How to minimize SQL Server Blocking

Http://www.sql-server-performance.com/tips/blocking_p1.aspx

 

How to Reduce the deadlock of sqlserver:

Cing SQL Server deadlocks

Http://www.sql-server-performance.com/tips/deadlocks_p1.aspx

 

How to Reduce the SQL Server lock?

Cing SQL Server locks

Http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx

 

SQL Server query execution plan analysis:

SQL Server query execution plan analysis

Http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx

 

SQL Server Query Analyzer:

Using SQL Server Query Analyzer

Http://www.sql-server-performance.com/tips/query_analyzer_p1.aspx

 

Sqlserver counter prompt:

Tips for using SQL Server Performance Monitor counters

Http://www.sql-server-performance.com/tips/ SQL _server_performance_monitor_coutners_p1.aspx

 

Use Network counters to diagnose network bottlenecks:

Tips for using performance monitor network counters

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

 

Use a memory counter to diagnose memory bottlenecks:

Tips for using performance monitor memory counters

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

 

Use an I/O counter to diagnose an I/O bottleneck:

Tips for using performance monitor I/O counters

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

 

Use a CPU counter to diagnose a CPU bottleneck:

Tips for using performance monitor CPU counters

Http://www.sql-server-performance.com/tips/performance_monitor_cpu_counter_p1.aspx

 

SQL Server Performance Tuning case analysis:

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) is a trace analysis tool developed and used by the ms SQL Server Product Support Service Team.

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 Studio provides you with SQL Server database performance problem diagnosis, analysis and optimization services.

Http://www.cnblogs.com/preftest