Home > Learning Guide: SQL Server performance tuning A to Z
Learning Guide:
EMAIL THIS LICENSING & REPRINTS

Learning Guide: SQL Server performance tuning A to Z

13 Apr 2006 | SearchSQLServer.com

Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

To ensure your SQL Server databases and applications run at their full potential, you must continually monitor and identify performance problems and quickly address bottlenecks. This guide will help you do all that and more. It covers everything SQL Server performance, from the very best to the very worst practices and performance-tuning myths. If you'd like to see a specific topic covered regarding SQL Server performance, send us an e-mail or ask expert Jeremy Kadlec for help.

TABLE OF CONTENTS
   Monitoring & testing
   Tuning & optimizing
   Troubleshooting
   Indexing
   Clustering
   Tools

  Monitoring & testing Return to Table of Contents

  • Checklist: Load testing -- the magic bullet for SQL Server performance tuning
  • Checklist: Prepare SQL Server for peak workloads
  • Tip: Develop a performance baseline
  • Tip: SQL Server 2005 DMVs: Exposing the state of your server
  • Tip: Stored procedure: Monitor SQL Server connections
  • Tip: Maintenance checks for SQL Server
  • Tip: SQL Server counters
  • Book excerpts: "SQL Server 2000 for experienced DBAs," Chapter 5, 'Monitoring and Tuning SQL Server'

      Tuning & optimizing Return to Table of Contents

  • Checklist: Ready, set, go! SQL Server performance-tuning checklist
  • FAQ: SQL Server performance boosters
  • Tip: Optimize SQL Server hardware performance
  • Tip: Unite people, processes and technology for performance tuning
  • Tip: Choosing a database partitioning method
  • Tip: Fire up your merge replication performance
  • Tip: Optimizing SQL Server 2000 settings
  • Expert response: SQL Server performance considerations when configuring a SAN
  • Expert response: Improve performance by spreading data
  • Expert response: Separate indexes from data for improved performance
  • Expert response: Is my SQL Server 2000 optimized?

    •   Troubleshooting Return to Table of Contents

  • Step-by-Step Guide: Hunt down SQL Server performance problems
  • SQL Server Clinic: T-SQL performance problems and solutions
  • SQL Server Clinic: Stop locking and blocking
  • Tip: SQL Server performance-tuning worst practices
  • Webcast: SQL Server performance-tuning myths
  • Expert response: Sluggish SQL Server 2000
  • Expert response: Long delay when application runs a query
  • Expert response: How to speed up a composite nonclustered index-based query
  • Expert response: Run sp_updatestats to recover performance
  • Expert response: Improve SQL Server performance by creating a transaction log file
  • Expert response: SQL Server 2000 jobs running for days

      Indexing Return to Table of Contents

  • Indexing Guide: The art and science of SQL Server indexing
  • Quick steps: 12 indexing tips in 12 minutes
  • Tip: Tricks for using the Index Tuning Wizard
  • Tip: Solving SQL Server 2000 index fragmentation
  • Expert response: Index types in SQL Server 2005
  • Expert response: When to upgrade index statistics
  • Expert response: How to speed up a composite nonclustered index-based query

      Clustering Return to Table of Contents

  • Tip: Why cluster
  • Tip: Setting up SQL Server clusters on a SAN
  • Expert response: Cluster index vs. non-cluster index
  • Expert response: How does failover clustering work in SQL Server 2005?
  • Expert response: Active/active vs. active/passive clustering

      Tools Return to Table of Contents

  • Tip: SQL Profiler: Features, functions and setup in SQL Server 2005
  • Tip: Database Engine Tuning Adviser: How to tune your new SQL Server 2005
  • Tip: Tricks for using the Index Tuning Wizard
  • Tip: Tracking query execution with SQL Server 2005 Profiler
  • Tip: Query Analyzer: 10 tricks for simple querying
  • Learning Guide: SQL Server tools

    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


    RELATED CONTENT
    SQL Server performance and tuning
    Virtual database storage for SQL Server: Friend or foe?
    Tutorial: SQL Server 2005 Analysis Services
    Tutorial: Migrating to SANs from local SQL Server disk storage
    SQL Server memory configurations for procedure cache and buffer cache
    Using the OUTPUT clause for practical SQL Server applications
    Check SQL Server database and log file size with this stored procedure
    SQL Server PerfMon counters for access methods and buffer manager
    Find size of SQL Server tables and other objects with stored procedure
    Monitor SQL Server disk I/O with PerfMon counters
    SQL Server tempdb best practices increase performance

    SQL Server clustering
    Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003
    SQL Server backups using SAN database snapshots
    Setting up SQL Server clusters on a SAN
    SQL Server Blog Watch
    SQL Server cluster design: One big cluster vs. small clusters
    FAQ: SQL Server comparison features
    SQL Server consolidation: Why, when and how to consolidate SQL Servers
    Active/Active clusters in SQL Server
    Avoiding SQL Server Sprawl with the PolyServe Database Utility
    Fast Guide: Clustering in SQL Server

    SQL Server 2005 (Yukon)
    How to use rank function in SQL Server 2005
    Manage traces in SQL Server 2005 Analysis Services with XMLA commands
    Tutorial: SQL Server 2005 Analysis Services
    Create a computed column in SQL Server using XML data
    Open SSIS packages without validation using these SQL properties
    Using the OUTPUT clause for practical SQL Server applications
    Create DDL table in SQL Server 2005 to audit DDL trigger activity
    How to process SQL Server 2005 Analysis Services for data availability
    Configure SQL Server Service Broker for sending stored procedure data
    SQL Server 2005 log shipping setup using the wizard
    SQL Server 2005 (Yukon) Research

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    contiguity  (SearchSQLServer.com)
    contiguous  (SearchSQLServer.com)
    drilldown  (SearchSQLServer.com)
    hashing  (SearchSQLServer.com)
    hybrid online analytical processing  (SearchSQLServer.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary


    • HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




    All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy     		  TechTarget - The IT Media ROI Experts