Microsoft SQL Server Performance Monitoring and Tuning

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Tricks for using the SQL Server Index Tuning Wizard

    Learn how to improve overall SQL Server 2000 performance with these Indexing Tuning Wizard tricks from Edgewood Solutions' Jeremy Kadlec.  Tip

  • Checklist: Maximize SQL Server backup performance

    Improve the I/O throughput of your SQL Server backups with the steps in this checklist by Edgewood Solutions' Greg Robidoux. It includes optimal backup configuration and scheduling options.  Tip

  • SQL Server Clinic: Stop locking and blocking

    Locking ensures SQL Server properly processes transactions, but too much locking can bring transactions to a grinding halt. This SQL Server Clinic walks you through a typical locking scenario and the steps needed to address locking and blocking probl...  Tip

  • Tuning your SQL Server 2005 database engine

    Installing SQL Server 2005 is not your greatest challenge; it's ensuring that the new DBMS meets high-performance demands of your business and IT departments. Edgewood Solutions' Jeremy Kadlec explains how to tune your new system using the Database E...  Tip

  • Creating an index with Index Tuning Wizard

    Get steps to create an index with Index Tuning Wizard in this book excerpt from "MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation."  Book Excerpt

  • Quick steps: 12 indexing tips in 12 minutes

    This collection of "quick steps" -- or mini step-by-step tutorials -- will help get your SQL Server 2000 indexing efforts up and running in a jiffy, whether you want to create, view, query or rebuild indexes.  Book Excerpt

  • Stored procedure: Easily filter for SQL Server connections

    In monitoring usage patterns on SQL Server connections, you need a tool to filter for connections of interest. Enterprise Manager has a basic tool to list connections, but it's not particularly flexible or convenient. The sp_ListConnections routine m...  Tip

  • SQL Profiler: Features, functions and setup in SQL Server 2005

    SQL Profiler is often considered the best native SQL Server resource because, for one thing, it understands micro-level processing on any SQL Server. Edgewood Solutions' Jeremy Kadlec introduces you to SQL Server 2005 Profiler and explains how to set...  Tip

  • Letters to the editor: Educating database end users

    As a SQL Server DBA or developer, what knowledge would you pass along to end users to help ease your burdens in the new year? Read what your peers have to say.  Letters to the Editor

  • Step-by-Step Guide: How to spec your SQL Server hardware needs

    When purchasing and sizing hardware to meet SQL Server workload demands over time, many factors must be taken into account. Contributor Hilary Cotter breaks down key considerations and offers advice for optimal hardware selection, sizing and performa...  Step-by-Step Guide

Back to top