To ensure the availability and performance of SQL Server resources from the perspective of an end user, install the ResponseTime for SQL module at carefully selected network locations.
If AppManager agents are distributed geographically and topologically on the network, installing the ResponseTime for SQL module on these agents can help you determine whether problems are related to the geographical location of the user, or whether the problem is related to the user’s network connection. A WAN link is quite often the source of slower response times and should be included in your planning before you decide where to install the managed objects. Pay particular attention to the back-end resources that support your Web site, which needs rapid response from SQL Server.
Installing the module on computers using connections of different types and speeds, such as DSL or various types of modems, will determine how accessible critical servers are from a range of client connections. For example, you may want to verify a rapid server access time for the slowest connection speed that you expect network users to have. Or you can compile a statistically averaged view of server response time from multiple, distributed agents.
When the ResponseTime for SQL module is deployed behind a firewall, it sends data and events back to the AppManager management server, which forwards the data to the AppManager repository. The management server can be located behind the firewall, or outside the firewall.