There are a number of performance monitoring and tuning tools available for third-party vendors. Here, we list a few that we have some personal experience with:
SQLYZER—From Precise, SQLYZER for SQL Server database and query tuning is one of the best out there. It’s a bit pricey, but for larger organizations that have vast implementations, investing in this type of holistic toolset can pay dividends. See http://www.precise.com for a current release of database and J2EE monitoring capabilities.