Tag: Script

SSIS

Identifying Bottlenecks in SSIS Packages

Post author By Andy B.
Post date Jul 29, 2025
2 Comments on Identifying Bottlenecks in SSIS Packages

Performance issues in SSIS packages can be tough to track down. You know something is off but trawling through pages of SSIS reporting and the validation noise is frustrating. Adding your own logging is a nice idea but not feasible at scale. An alternative? Querying internal tables within the SSIS database is a quicker way […]

Tags Bottlenecks, Integration Services, Performance, Performance Tuning, Script, SSIS, Troubleshooting

SQL

Basic Table Metrics

Post author By Andy B.
Post date Sep 3, 2024
2 Comments on Basic Table Metrics

In Management Studio we can view object details by hitting F7 in Object Explorer. It gives us basic metrics but I find it very slow to load for the details I typically need. For that reason I though I’d share a script to turn to for metrics I commonly need. This query returns: Results for the AdventureWorks2022 […]

Tags Script, SQL, Storage, Tables, Tips