THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

SSISDB Monitoring Queries on GitHub

I’ve moved my SSISDB scripts from Gist to GitHub where I can maintain them more comfortably. So far, I’ve published 6 scripts:

  • ssis-execution-status: Latest executed packages
  • ssis-execution-breakdown: Execution breakdown for a specific execution
  • ssis-execution-dataflow-info: Data Flow information for a specific execution
  • ssis-execution-log: Information/Warning/Error messages found in the log for a specific execution
  • ssis-execution-lookup-cache-usage: Lookup usage for a specific package/execution
  • ssis-execution-package-history: Execution historical data

I used them almost every day when I need to have a quick glance to what’s going on on Integration Services and when I need to do some deep analysis of errors and problems.

You can find them here:

https://github.com/yorek/ssis-queries

If you’re also wondering what happened to the SSIS Dashboard project

https://github.com/yorek/ssis-dashboard

…don’t fear, it’s not dead. I’m still working on it, but since I’m working on it only in my free time, updates are taking much more time than expected.

PS

Funny enough, Andy Leonard published a script to analyze lookups just couple of hours before me. You may also want to take a look at his post: http://sqlblog.com/blogs/andy_leonard/archive/2015/01/16/advanced-ssis-parsing-ssis-catalog-messages-for-lookups.aspx

Published Monday, January 19, 2015 7:13 PM by Davide Mauri

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog

Syndication

Privacy Statement