Performance tuning as commisioned by my best fren----Vishwanath
Hi
From MUGH and SQLCON we would like to thank all who participated in the yesterday discussion.
Am attaching few links which where part of our discussion and other helpful links that could be useful for performance tuning.
Join Hints
http://www.mssqlcity.com/Articles/General/NestLoop.htm
http://www.mssqlcity.com/Articles/General/HashJoins.htm
http://www.mssqlcity.com/Articles/General/mergeJoins.htm
Other helpful links
· Inside SQL Server 2000/7.0 by Kalen Delaney, http://www.insidesqlserver.com
· The Guru's Guide to Transact-SQL, http://www.khen.com/books.htm
· SQL Server Performance and Scalability References, http://www.microsoft.com/sql/evaluation/compare/performance.asp
· Understanding Performance Testing, http://msdn.microsoft.com/library/techart/d5dplyover.htm
· 224587 INF: Troubleshooting Application Performance with SQL Server http://support.microsoft.com/?id=224587
· 243586 INF: Troubleshooting Stored Procedure Recompilation http://support.microsoft.com/?id=243586
· 298475 INF: Information Required to Successfully Troubleshoot Application http://support.microsoft.com/?id=298475
· 175658 How To Gather Information for Effective Troubleshooting of Performance http://support.microsoft.com/?id=175658
· 319942 HOW TO: Determine Proper SQL Server Configuration Settings http://support.microsoft.com/?id=319942
· 297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5 http://support.microsoft.com/?id=297864
· 314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO http://support.microsoft.com/?id=314648
· 311826 INF: Index Tuning Wizard Best Practices http://support.microsoft.com/?id=311826
· Index Tuning Wizard 2000, http://msdn.microsoft.com/library/techart/itwforsql.htm
· Index Tuning Wizard 7.0, http://msdn.microsoft.com/library/techart/msdn_sqlindex.htm
· Troubleshooting the Index Tuning Wizard, http://msdn.microsoft.com/library/psdk/sql/tr_servtools_48ro.htm
· 195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work http://support.microsoft.com/?id=195565
· 197297 INF: Comparison of Join Techniques http://support.microsoft.com/?id=197297
· 139609 PerfMon: High Number of Pages/Sec Not Necessarily Low Memory http://support.microsoft.com/?id=139609
· 268343 Umdhtools.exe: How to Use Umdh.exe to Find Memory Leaks http://support.microsoft.com/?id=268343
· 286350 HOWTO: Use Autodump+ to Troubleshoot "Hangs" and "Crashes" http://support.microsoft.com/?id=286350
· 316365 INFO: ROADMAP for How to Use the .NET Performance Counters http://support.microsoft.com/?id=316365
· 150934 How to Create a Performance Monitor Log for NT Troubleshooting http://support.microsoft.com/?id=150934
· 130926 Using Performance Monitor to Identify a Pool Leak http://support.microsoft.com/?id=130926
· 146005 Optimizing Windows NT for Performance http://support.microsoft.com/?id=146005
· 248345 How to Create a Log Using System Monitor in Windows 2000 http://support.microsoft.com/?id=248345
· 275685 INF: Importing Performance Monitor Logs into SQL Server http://support.microsoft.com/?id=275685
Regards,
Viswanath
MUGH Home Page http://www.mugh.net SQLCON http://www.mugh.net/sql
