[ Back to Sprockit home page ]
Get Sprockit
Download the latest version of Sprockit here!
Prerequisites
- SQL Server 2008 R2 or later (SQL 2012 if you want to schedule SSIS packages from the catalog)
- SQL Server Agent
Creating a new Sprockit install
- 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).
Upgrading an existing Sprockit install
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.
Download
The current version of Sprockit is v1.5.4.
Follow me on Twitter for notification of new releases!
Version history
v1.5
- 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
v1.410
- 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).
v1.400
- 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]
v1.301
- Added sprockit.uvw_Process.[IsStoredQuery]
- Removed bootstrap job (process manager now scheduled directly, restarted at step 2)
v1.300
- Added common execution parameters to sprockit.Execution as separate fields
- Confined all objects to
sprockit
schema - Added sprockit.Process.[Priority]
v1.213
- Extended XML process configuration to support partial specification of process resources
- Added sprockit.Process.[IsEnabled]
- Added
ProcessManagerJobName
property
v1.210
- 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