Monitor MSSQL performance with this custom app
Ever had to dig through multiple tools just to debug a failed MSSQL backup or trace an error switching from multiple MS SQL Instances ? 😥🤯
That’s why I built a small tool in Visual Studio, using C#, WinForms, Powershell, T-SQL, WMI to monitor SQL Server health, logs, and performance stats in one place.
The primary focus of my project was to make an app that will have all the necessary tools for database administrator in their everyday monitoring work.
What this tool monitors:
- Disk usage and growth
- Memory and CPU utilization
- Database health and size
- Backup and restore history
- Active backup and restore operations
- Table sizes and index fragmentation
- SQL Server error logs
- SQL Agent job failures
- Schema object definitions
- Raw SQL object extraction
- Active sessions and blocking queries
- Deadlock tracking
- Custom session-level monitoring for your SQL Server instance
Feel free to contact me if you like what you see or have ideas what to improve or add....
I'd love to hear your feedback! 🤞
Video link: https://vimeo.com/1124492178
I've published the app also on,
https://www.producthunt.com/products/abemon
🧑🚀 Check the app on my GitHub:
abeamar
/
AbeMON
This App is for DBA everyday work on monitoring and troubleshooting on MSSQL. App created using Visual Studio, C#, WinForms, T-SQL, WMI.
AbeMon App 1.0.0
This App is for Light DBA everyday work on monitoring and troubleshooting on MSSQL.
App created using Visual Studio, C#, WinForms, T-SQL, PowerShell, WMI.
1. About
2. Options
2.1. System
2.2. Errors
2.3. Sessions
2.4. Locks
2.5. Export
2.6. Debug
3. Conclusion
1. About
The primary focus of this project is to make an App that will have all the necessary tools for database administrator in their everyday monitoring work. This app is a fully functional tool.
The app is provided as a trial for 30 days, allowing you to experience its full functionality. Feel free to contact me if you like what you see. This App is designed to deliver smooth performance while using minimal system resources, consuming just 10-20MB of RAM.
Full Article on dev.to: https://dev.to/abeamar/abemon-ms-sql-tool-v100-monitor-and-debug-60m
🐔 AbeMon Install options:
git clone "https://github.com/abeamar/AbeMon.git"Important
Choose the installation method that works best for you!
- Using the…
Cheers,
Amar.
Top comments (4)
Hi @amir_abedi_222ad74caaa786 ,
Thanks for the reply. I made a comment earlier, but it was hidden by the platform filter, so I am writing it again.
With a custom design and the right ideas, you can really do a lot with WinForms. I also had to overcome DPI and performance issues to get it right with this app.
Regarding your idea for customizable dashboards, it's a great thought, but I see this more as a tool with a predefined layout built for quick interaction and debugging not for monitoring.
This is the final version of the AbeMON app, optimized after further performance tuning to use minimal system resources, consuming just 15-20MB of RAM.
👉 AbeMON MS SQL Tool on DEV
Hi @amir_abedi_222ad74caaa786
Thanks for the reply, I like your ideas 😎
WinForms is a great way to build tools, but it definitely takes a lot of trial and error to get it right. Even for this app, I had to completely recreate the forms and rewrite the code from scratch to optimize both the speed and the DPI scaling.
This is the final product after refactoring everything. Now, it runs incredibly lean, consuming just around 20MB of RAM, with the rendering speed and DPI structure fully optimized.
dev.to/abeamar/abemon-ms-sql-tool-...
I made sure to explicitly close background forms, clear the cache at key moments, and implement UI rendering optimizations.
This is a great example of where WinForms still makes a lot of sense. For an internal monitoring tool like this, having direct access to SQL Server, WMI, PowerShell and Windows APIs can be a real advantage.
I also like the idea of bringing all those monitoring tasks into a single application instead of making DBAs switch between multiple tools.
One thing I’d be interested to see in a future version is customizable dashboards or widgets, so users could choose which metrics and monitoring panels are visible on the main screen. That could make the tool even more useful for different DBA workflows.
Nice work! The combination of WinForms with T-SQL and PowerShell is particularly interesting.
Would love to hear your thoughts is WinForms still a valid choice in 2025, or am I just being nostalgic ?😅