September 17, 2025 at 7:02 am
i have sqlexpress on rds, is there any way i can get notifacation that my datatbas has crossed 8gb?
September 17, 2025 at 8:07 pm
The EASIEST way to do it is to download and install a SQL monitoring solution that watches for database growth.
If that isn't an option, you'd need something in place that "monitors" SQL. If you need realtime monitoring, you'd need something that can constantly monitor the database file on disk for when it exceeds 8 GB, or a process on the SQL instance that monitors for database growth events. As you say you have express, you don't get the luxury of SQL Agent for jobs, so you'd need to use the windows task scheduler to execute SQL to check the size of the database.
My opinion, get a SQL monitoring solution that watches for whatever you care about. Cacti (as an example) can monitor SQL stuff and I believe that database size is an option for it to monitor and alert you on and it is a free tool. I imagine there are others too.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 18, 2025 at 8:06 am
Schedule (task scheduler with express edition or sqlagent ) a powershell script that fetches all databases file sizes and reports ( send an email ) when your tresholds are met.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply