![]() The most important and helpful will be explained in the following. Fortunately there are a few tools which help us monitoring different parts of the system. So the identification can be very time consuming and, in worst case, goes round in circles and comes to no result. In most cases the root causes for those bottlenecks lie deep in the system’s architecture and are not visible at first sight. ![]() In order to achieve effective and goal-oriented performance tuning it is mandatory to know your system’s bottlenecks. Before I start I would like to say a special thank you to my colleague Christian Jurjut, who invested a lot of time in analyzing this area and put together this fantastic guideline. Now I’d like to talk about what we need to collect, what the tools are and how they work. In my first post about my tuning series I wrote about the general methodology how tuning works: SSIS Performance Tuning – Methodology and general approach
0 Comments
Leave a Reply. |