Get Sprockit

Download the latest version of Sprockit here!

SQL Server 2008 R2 or later (SQL 2012 if you want to schedule SSIS packages from the catalog)
SQL Server Agent

Create a new database on your SQL Server.
Download the Sprockit install script.
Open the downloaded script file in SSMS, connect to your Sprockit database, then run it.
Schedule the new 'Run Sprockit…' agent job as required. (This is Sprockit's process manager).

Backup your existing Sprockit database!
Download the Sprockit install script.
Open the downloaded script file in SSMS, connect to your Sprockit database, then run it.

Upgrading from a prior version uses the same script as a brand new install.

The current version of Sprockit is v1.5.4.

Follow me on Twitter for notification of new releases!

Version history

Added sprockit.usp__Rewind and sprockit.usp__LogExecutionEvent
Added sprockit.SqlActivity (replaces [sprockit].[ExecutionActivity]) and SqlActivityRetentionPeriod property
Added sprockit.SsisPerformanceCounters and SsisPerfmonRetentionPeriod property
Added sprockit.uvw_Execution for convenient batch inspection and comparison
Added process 'SprockitIndexMaintenance' to manage internal index maintenance
Added management of high-severity SQL errors thrown to handlers. High-severity (>=20) SQL errors are uncatchable and cause a handler to crash. From this release the process manager detects crashed handlers, cleans them up and marks the the hard-failed process Errored in the same way as a lower-severity error.
Refined calculation of process average duration and branch weight to improve process selection.
Added RollingAverageBatchDays property
Improved performance of sprockit.uvw_ProcessDependency by eliminating references to sprockit.uvw_Process
Changed to three-part version numbers

Release of sprockitviz for interactive ETL pipeline visualisation.
Delay removal of process reservations after successful completion until start of next batch (release on completion may allow process re-execution of very short duration processes on severely under-resourced SQL instances).

Added ETL process lineage tracking and custom logging support
Added ability to prevent automatic log trimming (by setting LogRetentionPeriod to -1)
Renamed utility SPs with sprockit.usp__ (double underscore) prefix
Added utility SP sprockit.usp__ScriptProcessConfiguration
Added confirmation message at end of installation script
Added sprockit.Batch.[SprockitConfiguration]
Added sprockit.Execution.[ExecutionConfiguration]
Added sprockit.ExecutionActivity.[SqlServerSessionId], [IsDirect], [SqlBatchStart], [WaitType], [WaitDurationSecs], [BlockedBy] & [RequestedMemoryMB]
Added sprockit.uvw_Resource.[FqProcessName] & [ResourceUid]

Added sprockit.uvw_Process.[IsStoredQuery]
Removed bootstrap job (process manager now scheduled directly, restarted at step 2)

Added automatic index maintenance
Extended XML process configuration to support partial specification of process resources
Added sprockit.Process.[IsEnabled]
Added ProcessManagerJobName property

Bug in circular dependency detection (trg_DetectCircularDependency) fixed
usp_ConfigureProcess fixed to report error with poorly-formatted resources (rather than failing silently)
Property install fixed to prevent existing configuration from being overwritten