This topic has not yet been rated - Rate this topic

Monitoring (Integration Services)

SQL Server 2008

Other Versions

SQL Server 2008 R2

SQL Server Integration Services includes features for monitoring packages and their performance.

Integration Services includes logging features for capturing run-time information about a package and the package objects. For example, Integration Services can log the time that a package starts and stops running.
Integration Services also includes a set of performance counters for monitoring the performance of the data flow engine. For example, Integration Services can monitor the number of rows that a source produces. For more information, see Monitoring the Performance of the Data Flow Engine.

In This Section

Logging Package Execution: Describes the Integration Services logging features.
Understanding Events Logged by the Integration Services Service: Describes the common event messages that the Integration Services service logs to the Application event log.
Understanding Events Logged by an Integration Services Package: Describes the common event messages that an Integration Services package logs to the Application event log.
Monitoring How-to Topics (Integration Services): Lists the available how-to topics on logging the activity of Integration Services packages.

Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD