BIT Database Indexer Script - .net/Razor
![](/global/images/placeholder_1px.png)
Index Status Page
BIT Database indexer admin interface uses your selected data source and provides details on your database.
With a .net and Razor UI, this can be purchased open source or as a dll you can include in your current project.
Options are included to use our built in login, or add this to your own system.
The Index status page lists table name, index name, fragmented percent and has a rebuild link.
When the rebuild link is clicked, the index is rebuilt by MS SQL Script.
This makes managing your database fragmentation level easy!
The rebuild process is also included as a custom tag tag can be configured to run in the background of any page you select on your web site.
The script will email your address on file with updates as it has completed rebuilds.
![](/global/images/placeholder_1px.png)
The table size page provides a simple list of tables in your selected database. With row count, and size of each table this provides a easy way to see details on your database.
![](/global/images/placeholder_1px.png)
The database table and index list shows details about your database tables.
- Total number of tables found
- Number of tables with indexes
- Number of tables with multiple indexes
- Number of tables with no index
This page also lets you go into details about each table to see the columns ad field types.
![](/global/images/placeholder_1px.png)
The database action logs show all updates completed using the Bit AI database index script. Logs will show here if the action was taken in the admin section, or if it was performed by the AI script during a background rebuild.
This will also show the tables that had the most rebuilds, so you can check the table and related code to see if any process is causing the fragmentation.
Overview
DBTools is a web-based tool for managing index fragmentation in databases. The platform is developed as a .NET 8 Razor UI Class Library and is intended to be used in a Razor UI Web Application.
The Razor UI Class Library implements a series of Razor UI pages that will automatically be accessible in your Razor UI web application once installed.
Authentication
There are three authentication modes supported by the DBTools library.
- No Authentication – Any user with authorization to use the hosting site, can access the DBTools pages.
- Internal Authentication – Users will be required to provide a username and password to access the DBTools pages. The username and password are stored in the hosting applications configuration.
- Host Controlled Authentication – A valid dbtools authentication context can be created by the hosting application’s user authentication process, so when a user logs into the hosting application, the application creates a dbtool authentication context with a similar expiration. This process allows for a seamless authentication for the user.
Notifications
The DBTools system can send email notifications using a supplied SMTP username/password/server/port/from and to addresses. If email notifications are not wanted then it can be disabled but the DI service must still be registered.
Authentication Installation
The class library can be added as a Nuget package or directly as source code.
Once installed, register, and configure the DI services in your Razor application. Start by adding the “DbToolPages.Services” namespace.
The Bit database index script has versions under development in ASP.net and Ruby on Rails.
If you are interested in node js, Ruby on Rails or another version, please contact Us and let us know.