AbeMon is a powerful, lightweight toolkit designed for database administration, offering all the essential checks needed for troubleshooting and maintenance in your daily tasks.
Enjoy a 30 day free trial to explore its full potential and capabilities.
If you find it useful, feel free to get in touch.
This App is designed to deliver smooth performance while using minimal system resources, consuming just 15-20MB of RAM.
git clone "https://github.com/abeamar/AbeMon.git"
Choose the installation method that works best for you!
- Using the .exe or .msi Installer:
https://github.com/abeamar/AbeMon/main/AbeSetup.msi
https://github.com/abeamar/AbeMon/main/setup.exe
- Or Manual Installation (Copying the Folder abeSetup) After copying, you can run the application directly from that folder.
What this tool provides:
- Disk usage and growth
- Memory and CPU utilization
- Database health, security and size checks
- Backup and restore history checks
- Monitor active backup and restore operations with predictions
- Table sizes and index fragmentation checks
- SQL Server error logs
- Windows Events error logs
- SQL Agent job failures checks
- Schema object definitions
- Raw SQL object extraction
- Active sessions and blocking queries
- Deadlock, block tracking
- Custom session level monitoring for your SQL Server instance
This is a fully functional and very useful tool to have in your DBA arsenal.
😎
Stay tuned for regular updates as I dive deeper into how this tool can be used in various DBA scenarios. Whether you're troubleshooting issues or optimizing your SQL Server environment, this tool will be your best friend.
Example in Action:
- CASE: Tracking Restore & Backup Operations with Real Time Insights
Database restore is dragging on longer than expected, and you have no idea who initiated it or which backup was used. Or maybe you've got conflicting reports about when a restore actually happened, and you're stuck chasing down clues through endless logs.
With just a few clicks, you can access detailed restore history that shows exactly who performed the restore, which backup was used, and when it happened.
Or Instantly see who's performing restores, which backups are in use, and predict how long they'll take.
Whether it's active restores or ongoing backup jobs, this tool will provides the crucial data you need.
- CASE: Diagnosing long running transactions when resources are stuck
You show up to work, and your services are down. They are not processing anything. Maybe it’s just waiting for resources, or worse, it's hung up because your tempdb or transaction log is full. The usual suspects, but it's hard to figure out exactly where the bottleneck is.
That's where this tool comes in. One quick check will show you all the active sessions in your databases, sorted by execution time, so you can pinpoint the longest running transactions that might be blocking resources. But you don't have to stop there, you can combine this with other checks for tempdb usage, overall session activity, and transaction log health to get a full picture of what's happening and address it before it affects the rest of your system.
Sometimes the answer is hiding in plain sight, SQL Server logs and Windows Event logs often tell the full story once you know where to look.
- CASE: Handling Max Identity value reached in your production
Just a quick example of how this tool can save you from unexpected surprises. Imagine you're in production and service app suddenly can't insert data into a key table because your identity column (whether INT, BIGINT, or SMALLINT) has maxed out. It happens.
With one of the many checks the tool runs this is just one of the daily checks you would keep an eye on. For every table with incremental identity column in your databases you can get a heads up before that becomes a problem. If you know this early, you can take action, like altering the column to a bigger type or creating a new table, so things don't grind to a halt.
Always keep an eye on your table size.
In SQL Server, a well maintained index and table size go a long way in ensuring fast queries and low overhead.
Take it for a spin..
Download AbeMon and explore its full range of features at your own pace. From real time monitoring to detailed backup and restore insights, this tool is designed to make your workflow smoother. I am sure you'll appreciate the difference once you see it in action.
Top comments (0)