Wednesday, April 21, 2004

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

1 Comments:

Blogger penisenlargement4male said...

It is best to participate in a contest for among the best blogs on the web. I'll recommend this website!
Vimax Pills Enhance VigRX Plus metropathies Male Extra Amp Do Vimax pills really work mastoidal
More Info:
Penis Enlargement|Penis Enlargement Pills|Vimax Pills|Male Extra Pills |VigRX Plus

5:55 AM  

Post a Comment

<< Home