Monitor SQL Server Performance
SQL Server provides several tools for monitoring events in SQL Server and for tuning the physical database design. Tools for Performance Monitoring and Tuning describes these tools.
BizTalk Server is a database-intensive process. when troubleshooting BizTalk Server performance issues, it can be beneficial to also check the SQL Server performance. The following tools can help.
SQL Server Activity Monitor
SQL Server Activity Monitor provides information about SQL Server processes and how these processes affect the current instance of SQL Server. For more information, see Activity Monitor, and How to: Open Activity Monitor (SQL Server Management Studio.
SQL ServerData Collection
SQL Server provides a data collector that you can use to obtain and save data that is gathered from several sources. The data collector enables you to use data collection containers, which enable you to determine the scope and frequency of data collection on a computer that is running SQL Server. See Data Collection.