Find and fix SQL Server 2000 performance issues

Finding and fixing SQL Server 2000 performance issues step-by-step, such as where to look for bottlenecks, is explained by Edgewood Solutions' Jeremy Kadlec.

Finding the root cause of a SQL Server 2000 performance issue can be difficult to say the least, but not knowing...

where to start and what to look for increases the difficultly tenfold. Here I will outline many common SQL Server 2000 performance-tuning issues and offer suggestions on how to address them with free tools and code.


Hunt down SQL Server performance problems

 Home: Introduction
 Step 1: CPU usage
 Step 2: Disk IO queuing
 Step 3: Memory consumption
 Step 4: Network bandwidth
 Step 5: Transaction-level performance

ABOUT THE AUTHOR:   
Jeremy Kadlec
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the SearchSQLServer.com Performance Tuning expert. Ask him a question here.
Copyright 2005 TechTarget

More information from SearchSQLServer.com

  • Tip: Top 10 Performance Monitor counters
  • FAQ: SQL Server performance boosters

  • Tip: SQL Server performance-tuning worst practices

  • This was last published in December 2005

    Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

    PRO+

    Content

    Find more PRO+ content and other member only offers, here.

    Start the conversation

    Send me notifications when other members comment.

    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

    Please create a username to comment.

    -ADS BY GOOGLE

    SearchBusinessAnalytics

    SearchDataCenter

    SearchDataManagement

    SearchAWS

    SearchOracle

    SearchContentManagement

    SearchWindowsServer

    Close