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)
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 ?😅
Some comments may only be visible to logged-in visitors. Sign in to view all comments.