February 20, 2024 at 9:49 am
HI ALL,
what are the best sites to get sqlserver automation of scripts and alerts configurations
My requirement is to set alerts in sqlserver to get notifications and also
1.get daily health report
2. backups report
3. disk reports
4.log (ldf) increase alert
5. database growth report
6. backup failures alert
7. db long running sessions
8. blocking alerts
9. cpu and memory increase alerts which caused sql is slow connectivity issues from application
10. index fragmentation and index usage report
11. get auditing alerts
12 .get sql server error logs
13. always on database alerts
14. sqlserver restart alert
15. sqlserver database online offline alert
Thanks
Naga.Rohitkumar
February 20, 2024 at 10:26 am
Stick "SQL Server Monitoring Software" into your favourite search engine, you'll be presented with a abundance of results.
What you are asking for here is a monitoring piece of software, not a set of scripts as you want historic information also not just the "now".
Paid - Red-Gate, Idera, Quest, Solarwinds
Free - SQLWatch, Ajay's SQL Monitor (http://ajaydwivedi.com/demo/sqlmonitor), DBADash
February 20, 2024 at 6:21 pm
Go ahead. A google search will bring you the results you are looking for.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply