Sequenchel can create a database that is filled with useful procedures to assist you in your work as DBA. With these procedures you can:
- Monitor all SQL servers in your network from a single location
- Monitor all databases and their most important properties
- Monitor your backups and see if they are not too old
- Monitor SQL Server errorlogs and filter important messages
- Monitor dataspaces to see if your databases are (almost) full
- Monitor diskspaces to see if your databases can grow
- Monitor object owners to prevent inaccesible databases
- Monitor logins and users on all servers and databases
All monitor procedures email the changes or the important results to the predefined email address so there is no need to start Sequenchel first thing in the morning.
Defragmentation of indexes
Sequenchel has a procedure that can defragment indexes of a database based on fragmentation level and the date of the last defragmentation. There are 3 levels:
- Low fragmentation: no action is taken
- Medium fragmentation: the index is defragmented
- High fragmentation: the index is re-indexed
The results are logged in a table in the Sequenchel database, however, a Sequenchel database must exist on the local server for this. With Sequenchel, you can create as many Sequenchel databases as you like on every SQL Server.
If there are many indexes and there is not enough time to defragment them all in 1 run, Sequenchel will log when the index was last defragmented. The indexes that have not yet been defragmented or that have the oldest timestamp will be defragmented first. This way, in time, all indexes will be handled instead of the same indexes every night.