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,

  • 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. – Aaron Bertrand May 2 '14 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 '14 at 12:30
  • nowhere did I say you should have alerts on the VM but NOT on the host. – Aaron Bertrand May 5 '14 at 12:39
  • we decided to go with Nagios monitoring. – a_Texas May 12 '14 at 18:09
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.

  • thanks.. but we decided to go with Nagios – a_Texas May 12 '14 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 '14 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 '14 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 '14 at 20:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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