We are having to keep track of the status of a number of servers and jobs on our network. Currently this is done via manual checks, notification emails, and disgruntled users. What I would like is a simple dashboard and perhaps a single daily status email giving us the status of a number of performance indicators.
Of primary concern is the status of our SQL servers and related jobs but I've put together a wish list below of things I would like to monitor via a single tool. We have a tight-to-nothing budget but are happy to do some development work internally given the right toolset. I'm looking for recommendations of affordable/free solutions that users have experience with managing a small network.
In case it is relevant we have a three locations each with an average of two Windows 2012/2008 servers and 50 clients running Windows 7 and Windows 8.
SQL Servers are up on three servers
SQL Agent service is running on three servers
SSRS service is running on two servers
SSIS service is running on two servers
SQL Jobs exist on three servers
SQL Jobs have run at scheduled time within scheduled window
SQL Replication publications available on two servers
SQL Replication subscriptions available on three servers
SQL Replication subscriptions have run at scheduled time within scheduled window
Size of DB and log files growing within limits
On each servers multiple databases exist and are online
Free disk available on three servers
Disk space growing growing within limits
IIS running on two servers
IIS application pools running
IIS websites exist & available
Shared folders exist on servers and security as expected
SMTP server working
Connectivity to two remote networks up link speeds within limits
File server shares, security and usage thresholds