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

  • Avoid database auto-resizing to resolve access dilemmas

    Don't use a percentile growth model on databases that are multiple gigabytes in size -- unless you're prepared for database access attempts to slow to a crawl.  Tip

  • Undocumented DBCC: Command to track memory usage

    This DBCC gives you the top 20 cached items in SQL Server at any given time to help you analyze which objects are spending the most time in or out of the cache.  Tip

  • Pitfalls of using T-SQL cursors

    Cursors have a bad reputation: They're considered poor performers, resource hogs and a favorite tool of every inexperienced DBA. But they do have a place. Contributor Hilary Cotter explains how cursors work and their pros and cons.  Feature

  • SQL Server cursors pros and cons

    SQL Server cursors can be useful despite their reputation as poor performers, resource hogs and an overused tool by junior developers. This tip explains how cursors work and their pros and cons.  Tip

  • All-in-One Guide: SQL Server backup and recovery

    Find out how to successfully back up and recover SQL Server data with this collection of tips and expert advice. Our three categories include Basics, Restore Procedures, and Maintenance and Troubleshooting, with tips on selecting a SQL Server backup ...  Learning Guide

  • Tracking query execution with SQL Server 2005 Profiler

    Analyzing SQL Server Profiler results can help you fine-tune query performance. Edgewood Solutions' Jeremy Kadlec explains how based on two different scenarios.  Tip

  • SQL Server 2005 DMVs: Exposing the state of your server

    It was never a simple task to determine which T-SQL connections were blocking others in SQL Server -- until SQL Server 2005 Database Management Views came along.  Tip

  • When to update index statistics

    SQL Server 2005 expert Adam Machanic explains why it is not necessary to update statistics after rebuilding indexes.  Ask the Expert

  • Indexing Guide: The art and science of SQL Server indexing

    You can greatly improve your SQL Server 2000 performance through indexing, but only if you know how to choose the proper indexes for your business situation. Here, Jeremy Kadlec offers indexing dos and don'ts, and provides Index Tuning Wizard tricks....  Guide

  • SQL Server 2000 indexing dos and don'ts

    In the second part of this three-part feature, Edgewood Solutions' Jeremy Kadlec outlines best and worst practices for indexing in SQL Server 2000.  Tip

Back to top