Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ].
Same in the series Amit Bansal, SQL Server MVP from India and myself had a brief chalk-talk online session on query tuning techniques and also brief tips on how you can fine tune a query performance problem. Amit highlights the best usage of query hints to take advantage on performance tuning and I have given brief insight on how you can go about resolving a database performance problem.
Check it out the talk from here: Tech-Ed_Online Talk - Performance-Tuning_Techniques
(You may not open the video if you click on above link, rather you may save locally on your machine and open the same with your media browser)
Hope this will help you to set a baseline your performance techniques.
Format: asx
Duration: --:--
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.