yorek / Ssis Queries
A set of queries useful to easily extract monitoring and package performance data from SSISDB database
Stars: ✭ 79
Labels
Projects that are alternatives of or similar to Ssis Queries
Pg Clone Schema
Postgres clone schema utility without need of going outside of database. Makes developers life easy by running single function to clone schema with all objects. It is very handy on Postgres RDS. Utility is sponsored by http://elephas.io/
Stars: ✭ 59 (-25.32%)
Mutual labels: plpgsql
Postgrest Example
Migrations for an example conference API
Stars: ✭ 69 (-12.66%)
Mutual labels: plpgsql
Pgulid
Universally Unique Lexicographically Sortable Identifier (ULID) for PostgreSQL
Stars: ✭ 56 (-29.11%)
Mutual labels: plpgsql
Docker Postgis
This repository contains Docker image builds for PostgreSQL / PostGIS
Stars: ✭ 62 (-21.52%)
Mutual labels: plpgsql
Synapse scripts
Tools for maintaining a matrix synapse chat server // SEEKING MAINTAINERS
Stars: ✭ 58 (-26.58%)
Mutual labels: plpgsql
Ms Sql Server Group Concat Sqlclr
SQL Server CLR user-defined aggregates that collectively offer similar functionality to the MySQL GROUP_CONCAT function. Specialized functions ensure the best performance based on required functionality. Aggregates implemented using C#; requires .NET Framework 3.5.
Stars: ✭ 54 (-31.65%)
Mutual labels: plpgsql
Pgformatter
A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/
Stars: ✭ 1,085 (+1273.42%)
Mutual labels: plpgsql
Code Or Die
Code or Die: A Game for Galactical Domination
Stars: ✭ 63 (-20.25%)
Mutual labels: plpgsql
Postgresql Functions
Custom PostgreSQL functions and extensions
Stars: ✭ 50 (-36.71%)
Mutual labels: plpgsql
Pgsql Tweaks
Contains PostgreSQL functions which I regularly needed.
Stars: ✭ 48 (-39.24%)
Mutual labels: plpgsql
R Server Hospital Length Of Stay
Hospital length of stay prediction solution with Microsoft R Server
Stars: ✭ 76 (-3.8%)
Mutual labels: plpgsql
Openmaptiles
OpenMapTiles Vector Tile Schema Implementation
Stars: ✭ 1,175 (+1387.34%)
Mutual labels: plpgsql
SQL Server Integration Services Monitor Queries
The purpose of this project is to provide a set of queries to easily extract data from SSISDB database, in order to get quick insight on:
- Running packages,
- Performance History
- Run outcome
- DataFlow statistics and performances
- Lookup component memory usage
- Lookup component duplicate warnings
- Errors
- Memory Warnings
The provided queries are also used in the ssis-dashboard project.
Release Notes
Available 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
- ssis-execution-parameter-values: Show execution parameter values
Version History
v 1.0
- First release
v 1.1
- Improved & fixed the "ssis-execution-log" query
v 1.2
- Added "ssis-execution-parameter-values" query
v 1.3
- Fixed null values in "ssis-execution-dataflow-info" query due to invalid CTE join on Message ID, added "duration_minutes" column alias
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].