"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
Enterprise-grade ITSM, for every business Icon
Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity.

Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Try it 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

System Administrators, Developers, Other Audience

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