"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
MongoDB Atlas runs apps anywhere Icon
MongoDB Atlas runs apps anywhere

Deploy in 115+ regions with the modern database for every enterprise.

MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
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