0

Newbie here..

Hello Searching online and I could not find any articles/blogs that pointed, related or had any opinions regarding SQL Server and SQL Server Alerts installed/running on virtual machines. Question is, how important, or relevant are SQL Server Alerts (19-25,823,824, or 825) if the environment SQL is installed on is running as a guest on a a VM? Are there other solutions.

Regards,

4
  • I don't understand why you think hardware failures might be less important on a VM. The disks can still go bad, and you probably want to know about it. I'd prefer multiple alerts to 0. May 2, 2014 at 21:12
  • I agree. However, if alerts are configured on a VM running SQL, if the Host's hardware begins to fail would said alerts capture those faults? My concern are SQL alerts configured on the VM would not capture faults on Host hardware but only capture faults on the virtual hardware. Or am I wrong?
    – a_Texas
    May 5, 2014 at 12:30
  • nowhere did I say you should have alerts on the VM but NOT on the host. May 5, 2014 at 12:39
  • we decided to go with Nagios monitoring.
    – a_Texas
    May 12, 2014 at 18:09

1 Answer 1

2

I would suggest that they are equally important on physical or VMs.

suggest you to create all critical alerts as highlighted by Glenn Berry.

4
  • thanks.. but we decided to go with Nagios
    – a_Texas
    May 12, 2014 at 18:10
  • Nagios is a monitoring/alerting software. I highly recommend to create SQL Server alerts (as I highlighted above)- as they are tightly integrated with SQL OS.
    – Kin Shah
    May 12, 2014 at 18:44
  • Agreed, but if SQL is installed on a guest VM, will SQL alerts recognize if the HOST hardware begins to report errors?
    – a_Texas
    May 13, 2014 at 19:44
  • If the host hardware begins to report errors, then SQL server running on the VM will report errors as the VM will be affected. Prevention is better than cure and hence my recommendation. Also, even if HOST is fine, but the disks on VM becomes corrupted, then these alerts will be life saving for you.
    – Kin Shah
    May 13, 2014 at 20:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.