Magic 7

"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)

Features

1_QuickCheck_generic.sql
2_QEP_MissingIndexes_generic.sql
3_ReScript_Indexes_generic.sql
4_IndexUsage_generic.sql
5_Current_Blocks_generic.sql
6_Locks_Blocks_generic.sql
7_TraceCheck_generic.sql

Project Samples

Project Activity

See All Activity >

License

GNU General Public License version 3.0 (GPLv3)

Follow Magic 7

Magic 7 Web Site

Other Useful Business Software

Forever Free Full-Stack Observability | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.

Create free account

Rate This Project

User Reviews

Be the first to post a review of Magic 7!

Additional Project Details

Intended Audience

Developers, Other Audience, System Administrators

Programming Language

PL/SQL

Database Environment

Microsoft SQL Server

Related Categories

PL/SQL Database Engines Servers, PL/SQL Profiling Software, PL/SQL Performance Testing Software

Registered

2019-08-01

Similar Business Software

PathSolutions TotalView

PathSolutions TotalView network monitoring and troubleshooting software bridges the gap between NETWORK MONITORING and TROUBLESHOOTING RESOLUTION telling you WHEN, WHERE and WHY network errors occur. PathSolutions TotalView continuously monitors and tracks the performance of every device and...

See Software
Atera

Atera, the first and only Agentic AI platform for IT management, offers IT teams and MSPs a digital workforce of AI agents to preemptively and autonomously manage their entire IT operations. Its all-in-one platform combines RMM, helpdesk, ticketing, and automation to reduce downtime, improve...

See Software
Apify

Apify is a full-stack web scraping and automation platform helping anyone get value from the web. At its core is Apify Store, a marketplace with over 10,000 Actors where developers build, publish, and monetize automation tools. Actors are serverless cloud programs that extract data, automate...

See Software
ManageEngine OpManager

OpManager is a network management tool geared to monitor your entire network. Ensure all devices operate at peak health, performance, and availability. The extensive network monitoring capabilities lets you track performance of switches, routers, LANs, WLCs, IP addresses, and...

See Software
DbVisualizer

DbVisualizer is a universal database client for developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

See Software
Parasoft

Parasoft helps organizations continuously deliver high-quality software with its AI-powered software testing platform and automated test solutions. Supporting embedded and enterprise markets, Parasoft’s proven technologies reduce the time, effort, and cost of delivering secure, reliable, and...

See Software