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.
|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