February 3, 2025 at 9:12 am
With no budget for some paid tools to monitor sql server service and sql agent service ; how can we send an email alert when they go down etc..what are the options ? I do not want processes where I have to run some piece of code(t-sql/powershell--I can set this up but is there a better way than this) constantly every minute to check those services status..Please advice
February 4, 2025 at 10:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 5, 2025 at 8:31 am
If there is no budget for monitoring tools that implies your business does not care if the service is up or down, it just wants things on a 'best-efforts' basis. Therefore do not worry or spend time trying to build something yourself.
Alternatively if your business does care about availability then your management needs to accept their responsibility. They need to ensure there are SLAs in place that meet the expectations for availability and tools that show the SLAs are kept. In short, if downtime has a cost, then it is mandates spending something to avoid it.
My experience is that building your own toolset, when cost of staff time is taken into account, is always more expensive than buying something. Also the home-grown tools will give inferior results to an appropriate third party tool. It is a poor use of DBA time to get them writing monitoring tools.
The key thing is the business cost of downtime. When the business can agree an approximate cost for downtime, then they should agree what percentage of that cost can be spent in avoiding it. You then have some budget for tools, and can look at what you can get for the money that will meet business needs.
In one place I worked, the business managers reckoned that if the systems were down for 12 hours we would permanently lose 10% of our customers. Five days of downtime would result in a near 100% customer loss. We had money for tools that would help avoid this.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply