http://www.sqlservercentral.com/Content tagged SQL Server 6.5, Performance Tuning and Scaling posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries. http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/2005/12/23http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips. http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/2005/07/15http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use. http://www.sqlservercentral.com/redirect/articles/73/2004/09/24http://www.sqlservercentral.com/redirect/articles/73/One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries. http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/2005/12/23http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned. http://www.sqlservercentral.com/articles/Performance+Tuning/savingspace/208/2003/02/21http://www.sqlservercentral.com/articles/Performance+Tuning/savingspace/208/One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips. http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/2005/07/15http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/An alternative procedure for viewing locks based on sp_lock. http://www.sqlservercentral.com/articles/Performance+Tuning/lockview/297/2001/07/24http://www.sqlservercentral.com/articles/Performance+Tuning/lockview/297/In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.http://www.sqlservercentral.com/redirect/articles/146/2001/05/02http://www.sqlservercentral.com/redirect/articles/146/Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use. http://www.sqlservercentral.com/redirect/articles/73/2004/09/24http://www.sqlservercentral.com/redirect/articles/73/