7 Generic TSQL Scripts to Troubleshoot SQL Performance Problems
"It's not a tool, which fixes a problem, but the fool using it!" (Jörg Stryk)
The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks
and to develop/implement appropriate solutions.
"With great power comes great responsibility" (Uncle Ben)
2 smart Stored Procedures to handle "Missing Indexes" in SQL Server
<<Why Did It Have to Be Snakes?>> (Indiana Jones)
This "Ix Adder" is deadly venomous for "Expensive Queries"!
It taps from SQL Server's "Missing Index" proposals and cleans them up sufficiently before installing them automatically.
IXA balances the Cost/Benefit of an Index to significantly improve READ performance while not degrading WRITE performance.
But take care: used in a wrong way this viper could also bite your very own butt!
"Ix Adder"'s little pal is "Ix Strictor" which...
Kokpit-db is an integrated monitoring, comparison and performance analysis software for Oracle databases. It can compare and monitor versions 8i, 9i, 10g and 11g. Supports standby databases and ASM instances. GUI and command line interfaces available
DBPrism is a framework to generate dynamic XML from a database, it provides an high performance DBGenerator for Cocoon2. Also is a J2EE replacement for Oracle mod_plsql. This project also includes a Restlet-Oracle connector exam. and Lucene Domain In
Unlock call analytics that provide actionable insights with our call tracking software, empowering you to identify what's working and what's not.
Every customer interaction is vital to your business success and revenue growth. With Jiminny’s AI-powered conversation intelligence software, we take recording, capturing, and meticulous analysis of call recordings to the next level. Unlock call analytics that provide actionable insights with our call tracking software, empowering you to identify what's working and what's not. Seamlessly support your biggest objectives across the entire business landscape with our innovative call tracking system.
PASQL is a collection of SQL queries helpful in anaylzing trends and resolving problems using data in BMC Performance Advisor. These are verified to run on a DB2 for z/OS Ver. 8 or Ver. 9 created with BMC’s SQL Performance for DB2 Ver. 6.2+
DB Guardian is a Java-based database diagnostic performance tool for Oracle 10g. This tool helps the database administrator (DBA) to monitor and detect problems related to performance in your environments.