Software Product Datasheet Overview

Nibiru Software Product Datasheet and Features

SQL Database Defragmenter™ — Launch FAQ

General

What is SQL Database Defragmenter (SQL DBD)?

SQL Database Defragmenter is a patent-pending utility for Microsoft SQL Server that analyzes and remediates both primary database file (PDF) and index fragmentation using a policy-driven, automated approach.

Who is this product for?

SQL DBD is designed for:

  • SQL Server Database Administrators (DBAs)
  • Performance and Tuning specialists
  • Infrastructure and operations teams
  • Enterprises managing performance-sensitive SQL Server environments

Technical Capabilities

How is SQL Database Defragmenter different from traditional index maintenance tools?

Most tools focus exclusively on index fragmentation. SQL DBD also detects and remediates physical fragmentation at the PDF file level, which can significantly impact I/O and query performance but is often overlooked.

What types of fragmentation does SQL DBD analyze?

  • PDF (Primary Data File) physical fragmentation
  • Index fragmentation

Does SQL DBD require scripts or manual intervention?

No. SQL DBD is fully automated and policy-driven. Once thresholds and schedules are defined, the system operates with a true set-and-forget model.

What happens during PDF defragmentation?

When defined thresholds are exceeded, SQL DBD:

  1. Validates system readiness (checks for database connections)
  2. Invokes native SQL Server backup utilities (optional but recommended)
  3. Detaches the PDF file
  4. Performs file-level defragmentation
  5. Reattaches the file
  6. Rebuilds indexes
  7. Updates statistics
  8. Recompiles stored procedures

Safety and Best Practices

Is it safe to detach database files automatically?

Yes. SQL DBD performs proactive contention and readiness checks, analyzing multiple system resource conditions before executing any operation. Defragmentation only proceeds when it is deemed safe.

Can SQL DBD integrate with existing backup strategies?

Yes. SQL DBD can invoke native SQL Server backup utilities prior to defragmentation, aligning with industry best practices.

Does SQL DBD support scheduling?

Yes. Both real-time monitoring and scheduled maintenance windows are supported.

Beta Program

What is included in the public beta?

The public beta provides access to:

  • PDF and index fragmentation analysis
  • Policy-based thresholds
  • Automated defragmentation workflows
  • Scheduling and monitoring via the web dashboard

Who can participate in the beta?

All SQL Server DBAs and organizations running supported SQL Server versions are eligible to participate.

How do I register for the beta?

Is feedback expected from beta participants?

Yes. Feedback from real-world DBA environments is critical and will directly influence final product refinements and future features.

Intellectual Property

Why is SQL Database Defragmenter marked “Patent Pending”?

SQL DBD incorporates proprietary methods for detecting and remediating MDF and index fragmentation. Patent-pending status reflects formal filings intended to protect these innovations.

Availability and Roadmap

When will the GA (General Availability) release occur?

General availability timing will be announced following completion of the public beta and evaluation of feedback.

Is this Nibiru Software’s first product?

Yes. SQL Database Defragmenter is Nibiru Software’s inaugural product and the foundation of a broader roadmap of DBA-focused infrastructure utilities.

Support and Contact

How can I get support during the beta?

Support details and feedback channels are provided after registration.