Power Up with SQL Server: SQL Server Performance
Here's a list of additional resources for attendees of the SQL Server Performance session from today's Power Up with SQL Server Event.
Feel free to contact me if you're looking for a specific resource, or had additional questions that weren't answered in our session.
Performance Background
B-Trees (Wikipedia)
http://en.wikipedia.org/wiki/B-tree
SQL Server Indexing Basics
http://www.sqlteam.com/article/sql-server-indexes-the-basics
http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/
http://msdn.microsoft.com/en-us/library/aa964133%28SQL.90%29.aspx
Clustered Indexes vs Heaps
http://sqlcat.com/whitepapers/archive/2007/12/16/comparing-tables-organized-with-clustered-indexes-versus-heaps.aspx
The Benefits of Clustered Indexes
http://www.sqlservercentral.com/articles/Performance+Tuning/clusterthatindex/952/
Index Fragmentation
http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-1-the-basics/
http://www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx
BookMark Lookups
http://www.sqlservercentral.com/articles/Performance+Tuning/bookmarklookups/1899/
http://sqlblog.com/blogs/linchi_shea/archive/2008/07/06/performance-impact-bookmark-lookup-is-expensive-even-in-memory.aspx
Performance Troubleshooting
Generic KB for Performance Troubleshooting
http://support.microsoft.com/?id=298475
Troubleshooting SQL Server 2008 Performance Problems
http://sqlcat.com/whitepapers/archive/2009/04/14/troubleshooting-performance-problems-in-sql-server-2008.aspx
Troubleshooting SQL Server 2005 Performance Problems
Performance Monitor
Setting up Traces (on Win2000,2003)
http://www.sqlserveraudits.com/instructions/perfmon.aspx
Trace Templates
http://www.sqlserveraudits.com/instructions/PerfmonTraceTemplates.zip
Analyzing Performance Counters
http://msdn.microsoft.com/en-us/library/ms998579.aspx
Distilled version of above counters:
http://www.sqlserveraudits.com/instructions/PerformanceCounters.doc
SQL Server Profiler
Using SQL Server Profiler
http://msdn.microsoft.com/en-us/library/ms187929.aspx
http://www.sql-server-performance.com/tips/sql_server_profiler_tips_p1.aspx
Establishing a baseline
http://www.sqlserveraudits.com/instructions/BaseLine.sql.txt
Finding Top Offenders
http://www.sqlserveraudits.com/instructions/TopOffenders.sql.txt
ClearTrace
http://www.cleardata.biz/cleartrace/
Index Tuning Problems
SARGability
http://weblogs.sqlteam.com/dang/archive/2009/03/07/Low-Hanging-Fruit-of-Sargable-Expressions.aspx
http://www.sqlmag.com/articles/index.cfm?articleid=99148&
Index Selectivity
http://www.sql-server-performance.com/articles/per/index_not_equal_p1.aspx
Index Selectivity and Column Order
http://sqlserverpedia.com/wiki/Index_Selectivity_and_Column_Order
Comments
Loading Comments...