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 on SQL Server, Business Intelligence and .NET

SSIS Dashboard v 0.6.1

Yesterday I’ve released the latest SSIS Dashboard update. There quite a lot of new features included that I found to very useful when you have a server full of packages and logs. Here the complete list: Highlighted the feature I think worth the most:

  • Updated Morris.js to v 0.5.1
  • Updated MetisMenu to v 1.1.1
  • Added information on "Child" Packages
  • Added more detail to the "Package Execution History" page. Also added an estimated end time / elapsed time for running packages, using a moving average of 7 steps.
  • Added navigation sidebar in the main page that shows available folders and projects
  • Added support for folders and project filtering
  • Changed configuration file in order to comply with Python/Flask standards
  • Cleaned Up code in order to follow Python best practices (still a lot to do :))

Have you had a chance to give it a try? What features you’d like to see added?

My plans for the next releases is to

  • Add a configuration page so that you can choose the maximum number of rows return (now set to 15) and the time interval you want to analyze (not set to 72 hours in the config file)
  • Use a EWMA instead of the simple Moving Average
  • Do a video to show how to install and use the Dashboard
  • Package everything in only one executable file / directory / VM (I want to be able to offer a xcopy deplyment “all-included”…not only the .py files)
  • Include additional information taken from [event_message_context], [executable_statistics], [execution_parameters_values]
  • Fix the layout for small / medium screens (smartphones / tablet)
  • Add historical / average elapsed time also for Child Packages and Executables
  • Include DataFlow informations

Once all those things will be do, version 1.0 will be ready

If you want to help, fork the code from Github:

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

if you want to try it go here

http://ssis-dashboard.azurewebsites.net/

Published Friday, August 29, 2014 11:53 AM 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

 

Roberto G. said:

Good Job Mauro!

August 31, 2014 9:53 AM
 

Mahesh said:

This only works with SSISDB right? What about packages stored and run from MSDB?

October 11, 2014 10:16 PM

Leave a Comment

(required) 
(required) 
Submit

About Davide Mauri

Davide Mauri - MCP, MCAD, MCDBA, MCT, MVP on SQL Server - has worked with SQL Server since version 6.5, and his interests cover the whole platform, from the Relational Engine to Analysis Services, from architecture definition to performance tuning. He also has a strong knowledge of XML, .NET and the Object Oriented Design principles, which allows him to have the correct vision and experience to handle development of complex business intelligence solutions. Having worked as a Microsoft Certified Teacher for many years, Davide is able to pass all his knowledge to his co-workers, allowing his team to deliver high-quality solutions. He currently works as a Mentor for SolidQ and can be found speaking in many Italian and internationals events.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement