Database Reference
In-Depth Information
Figure 18-16.
An example of an SSRS report query captured with SQL Server Profiler
Database administrators can use this tool to monitor traffic between the SSIS, SSAS, and SSRS servers to
look for queries that have the highest duration and target them for additional tuning. During development,
there are no users with activity to track. Therefore, developers use this tool to identify the current performance
of statements between the three servers and try to improve performance by making changes to the current BI
solution by adding indexes or modifying queries.
WhY IS thIS MY prOBLeM?
You may find your development team scratching their head asking, “Why is this my problem?” it seems as if
this would be something the database administrators should be tasked with. But consider an analogy. let's
say that an automobile manufacturer saves money and time by not tuning their cars at the factory. instead,
they require their dealers to tune the cars before they are sold. As many of us know, the professionalism of
each automobile dealer varies quite a bit, so you can expect that the initial experience of the new car owners
would also vary. still even though it was the dealer's responsibility to tune the car, the owner associates their
care with both the dealer
and
the manufacturer. owners of a poorly tuned car would believe that the car was
of poor quality and unprofessionally built by the manufacturer.
using this analogy, we can see that tuning the Bi solution before it is released is a much more professional
approach than releasing it with instructions that the new owners are responsible for making all adjustments
as they see fit.
