Wednesday, April 21, 2004

Performance tuning as commisioned by my best fren----Vishwanath


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

Other helpful links

· Inside SQL Server 2000/7.0 by Kalen Delaney,

· The Guru's Guide to Transact-SQL,

· SQL Server Performance and Scalability References,

· Understanding Performance Testing,

· 224587 INF: Troubleshooting Application Performance with SQL Server

· 243586 INF: Troubleshooting Stored Procedure Recompilation

· 298475 INF: Information Required to Successfully Troubleshoot Application

· 175658 How To Gather Information for Effective Troubleshooting of Performance

· 319942 HOW TO: Determine Proper SQL Server Configuration Settings

· 297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5

· 314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO

· 311826 INF: Index Tuning Wizard Best Practices

· Index Tuning Wizard 2000,

· Index Tuning Wizard 7.0,

· Troubleshooting the Index Tuning Wizard,

· 195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work

· 197297 INF: Comparison of Join Techniques

· 139609 PerfMon: High Number of Pages/Sec Not Necessarily Low Memory

· 268343 Umdhtools.exe: How to Use Umdh.exe to Find Memory Leaks

· 286350 HOWTO: Use Autodump+ to Troubleshoot "Hangs" and "Crashes"

· 316365 INFO: ROADMAP for How to Use the .NET Performance Counters

· 150934 How to Create a Performance Monitor Log for NT Troubleshooting

· 130926 Using Performance Monitor to Identify a Pool Leak

· 146005 Optimizing Windows NT for Performance

· 248345 How to Create a Log Using System Monitor in Windows 2000

· 275685 INF: Importing Performance Monitor Logs into SQL Server





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