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.
App provides key insights on disk, memory, database health, table sizes, fragmentation, backup/restore history, schema object definition, error logs, extracts raw sql objects and tracking events for locks, deadlocks, and overall monitor sessions on your MSSQL.
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?launch=abemon
🧑🚀 Check the app on my GitHub:
abeamar
/
AbeMon
App created using Visual Studio, C#, WinForms, T-SQL, WMI. This App is for Light DBA everyday work on monitoring and troubleshooting.
AbeMon App 0.1.5
App created using Visual Studio, C#, WinForms, T-SQL, PowerShell, WMI. This App is for Light DBA everyday work on monitoring and troubleshooting on MSSQL.
1. About
2. Options
2.1. System
2.2. Errors
2.3. Sessions
2.4. Locks
2.5. Export
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 was made not just as a showcase but also as a fully functional tool.
I've also implemented in the app to run as a trial version, after 30 days the login button will stop working. Feel free to contact me if you like what you see.
Below are some of the product screens.
🐔 AbeMon Install options:
https://github.com/abeamar/abeApp/blob/main/abeSetup.msi
or
https://github.com/abeamar/abeApp/tree/main/abeSetup
Demo App preview
Video link on Vimeo
2. Options
The App is divided in few forms; System…
Cheers,
Amar.