Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Performance Tools

This topic provides information on tools you can use to evaluate the performance of a BizTalk Server solution. The tools described in this topic have different purposes; some are designed to evaluate end-to-end performance while others focus on evaluating performance of a particular aspect of a BizTalk Server solution.

The BizTalk Server Orchestration Profiler is used to view orchestration tracking data for a specified period of time and is useful for determining where performance bottlenecks exist in orchestrations.

For more information about the BizTalk Server Orchestration Profiler, see BizTalk Server 2006 Orchestration Profiler (http://go.microsoft.com/fwlink/?LinkId=102209).

Ee377051.note(en-US,BTS.10).gifNote
Use of this tool is not supported by Microsoft, and Microsoft makes no guarantees about the suitability of this programs. Use of this program is entirely at your own risk. Also note that this utility was designed to work with BizTalk Server 2006 and therefore may not work as expected on BizTalk Server 2009.

BizUnit is a framework designed for automated testing of BizTalk solutions. BizUnit is an excellent tool for testing end-to-end BizTalk Server scenarios. Performing automated testing of BizTalk solutions with BizUnit is the primary focus of the Implementing Automated Testing section of this guide. For more information about BizUnit 3.0, see BizUnit - Framework for Automated Testing of Distributed Systems (http://go.microsoft.com/fwlink/?LinkID=85168).

BizUnit Designer is a GUI that allows for rapid creation of BizUnit test cases that can be used for unit testing or system testing distributed applications. The tool is available at BizUnit Designer (http://go.microsoft.com/fwlink/?LinkID=117917).

Ee377051.Important(en-US,BTS.10).gifImportant
As of the writing of this guide, the test cases generated by BizUnit Designer 1.x are only compatible with BizUnit 2.x.

Ee377051.note(en-US,BTS.10).gifNote
Use of this tool is not supported by Microsoft, and Microsoft makes no guarantees about the suitability of this programs. Use of this program is entirely at your own risk.

IOMeter is an open source tool used for measuring disk I/O performance. For more information about IOMeter, see http://www.iometer.org (http://go.microsoft.com/fwlink/?LinkId=122412).

Ee377051.note(en-US,BTS.10).gifNote
Use of this tool is not supported by Microsoft, and Microsoft makes no guarantees about the suitability of this programs. Use of this program is entirely at your own risk.

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. Log Parser is available for download at Log Parser 2.2 (http://go.microsoft.com/fwlink/?LinkID=100882).

BizTalk LoadGen 2007 is a load generation tool used to run performance and stress tests against BizTalk Server 2009.

For more information about the Microsoft BizTalk LoadGen 2007 tool, see Microsoft BizTalk LoadGen 2007 Tools (http://go.microsoft.com/fwlink/?LinkId=59841).

Pathping provides information about possible data loss at one or more router hops on the way to a target host. To do so, pathping sends Internet Control Message Protocol (ICMP) packets to each router in the path. Pathping.exe is available with all versions of Windows since Windows 2000 Server.

The PAL tool is used to generate an HTML-based report that graphically charts important performance counters and generates alerts when thresholds for these counters are exceeded. PAL is an excellent tool for identifying bottlenecks in a BizTalk Server solution to facilitate the appropriate allocation of resources when optimizing the performance of the solution.

For more information about the Performance Analysis of Logs (PAL) tool, see Performance Analysis of Logs (PAL) Tool (http://go.microsoft.com/fwlink/?LinkID=98098).

Ee377051.note(en-US,BTS.10).gifNote
Use of this tool is not supported by Microsoft, and Microsoft makes no guarantees about the suitability of this programs. Use of this program is entirely at your own risk.

Performance Monitor provides a visual display of built-in Windows performance counters, either in real time or as a way to review historical data.

The Relog utility is used to extract performance counters from logs created by Performance Monitor and convert the data into other formats, such as tab-delimited text files (text-TSV), comma-delimited text files (text-CSV), binary files, and SQL databases. This data can then be analyzed and queried using other tools, such as Log Parser, to generate statistics for key performance indicators (KPIs). The Relog utility is provided with Windows Server 2003 and subsequent versions.

The Visual Studio Team System (VSTS) 2008 provides functionality for creating and running load tests. For more information about working with load tests see Visual Studio Team System: Working with Load Tests (http://go.microsoft.com/fwlink/?LinkId=141486).

Windows Performance Tools are designed for analysis of a wide range of performance problems including application start times, boot issues, deferred procedure calls and interrupt activity (DPCs and ISRs), system responsiveness issues, application resource usage, and interrupt storms.

For more information about the Windows Performance Analysis Tools, see Windows Performance Analysis (http://go.microsoft.com/fwlink/?LinkId=139763).

SQL Server provides several tools for monitoring events in SQL Server and for tuning the physical database design. These tools are described in the SQL Server Books Online topic Tools for Performance Monitoring and Tuning (http://go.microsoft.com/fwlink/?LinkId=146357). Information about specific tools used for SQL Server performance monitoring and tuning is provided below:

SQL Profiler

Microsoft SQL Server Profiler can be used to capture Transact-SQL statements that are sent to SQL Server and the SQL Server result sets from these statements. Because SQL Server is tightly integrated with SQL Server, the analysis of a SQL Server Profile trace can be a useful tool for analyzing problems that may occur in BizTalk Server when reading from and writing to SQL Server databases. For information about how to use SQL Server Profiler, see the SQL Server 2008 Books Online topic Using SQL Server Profiler (http://go.microsoft.com/fwlink/?linkid=104423).

Ee377051.Important(en-US,BTS.10).gifImportant
There is considerable overhead associated with running SQL Profiler. Therefore SQL Profiler is best suited for use in test or development environments. If using SQL Profiler to troubleshoot a production environment, be aware of the associated overhead costs and limit the use of SQL Profiler accordingly.

Ee377051.note(en-US,BTS.10).gifNote
When using SQL Profiler to capture Transact-SQL statements, configure SQL Profiler to generate output to a local drive rather than a drive located on a remote network share or other slow device, for example, a local USB memory stick.

SQL Trace

SQL Server provides Transact-SQL system stored procedures to create traces on an instance of the SQL Server Database Engine. These system stored procedures can be used from within your own applications to create traces manually, instead of using SQL Server Profiler. This allows you to write custom applications specific to the needs of your enterprise. For more information about using SQL Trace, see the SQL Server 2008 Books Online topic Introducing SQL Trace (http://go.microsoft.com/fwlink/?LinkId=146354).

Ee377051.note(en-US,BTS.10).gifNote
When using SQL Trace to capture Transact-SQL statements, configure SQL Trace to generate output to a local drive rather than a drive located on a remote network share or other slow device, such as a USB flash drive.

SQL Activity Monitor

SQL Server 2008 Activity Monitor provides information about SQL Server processes and how these processes affect the current instance of SQL Server. For more information about SQL Server 2008 Activity Monitor, see the SQL Server 2008 Books Online topic Activity Monitor (http://go.microsoft.com/fwlink/?LinkId=146355). For information about how to open Activity Monitor from SQL Server Management Studio, see the SQL Server 2008 Books Online topic How to: Open Activity Monitor (SQL Server Management Studio) (http://go.microsoft.com/fwlink/?LinkId=135094).

SQL Server 2008 Data Collection

SQL Server 2008 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 2008. For more information about implementing SQL Server 2008 data collection, see the SQL Server 2008 Books Online topic Data Collection (http://go.microsoft.com/fwlink/?LinkId=146356).

SQL Server 2005 Performance Dashboard Reports

SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. For more information about SQL Server 2005 Performance Dashboard Reports, see SQL Server 2005 Performance Dashboard Reports (http://go.microsoft.com/fwlink/?LinkID=118673).

SQLIO

The SQLIO tool was developed by Microsoft to evaluate the I/O capacity of a given configuration. As the name of the tool implies, SQLIO is a valuable tool for measuring the impact of file system I/O on SQL Server performance. SQLIO can be downloaded from SQLIO Disk Subsystem Benchmark Tool (http://go.microsoft.com/fwlink/?LinkId=115176).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.