Use of performance monitoring tools:
SQL server ships with many tools like Profiler,Database Engine Tuning Advisor,Index Tuning Wizard,PerfMon,SysMon.Make use of these tools to moniter the performance of your query and take the nessesary actions,if required.
Well, with this post we come to an end of our series of Performance Tuning Steps.I hope its helpful to you to you and we will discuss each steps in detail in coming days.
1 comments:
Yes. This series was really helpful. Keep it up. Performance monitoring becomes very essential when we deal with a large volume of data. It will be great if you can give us some glimpse of Profiler with a practical example and steps involved using it.
Post a Comment