"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

M7_0 Preparation M7_1 QuickCheck M7_2 MissingIndexes M7_3 ReScript M7_4 IndexUsage M7_5 Blocks

Project Activity

See All Activity >

Categories

Database Engines/Servers, Profiling, Performance Testing

License

GNU General Public License version 3.0 (GPLv3)

Follow Magic 7

Magic 7 Web Site

Other Useful Business Software
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

The database for AI-powered applications.

MongoDB Atlas is the developer-friendly database used to build, scale, and run gen AI and LLM-powered apps—without needing a separate vector database. Atlas offers built-in vector search, global availability across 115+ regions, and flexible document modeling. Start building AI apps faster, all in one place.
Start Free
Rate This Project
Login To 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
Report inappropriate content