When SQL Server systems suffer any form of outage, the effects can be felt very far across a business. There are three basic areas that you need to be concerned with when it comes to keeping SQL running:

  • the operating system
  • SQL Server itself
  • and any automated jobs that run on the system.                                                                                                        

These represent the broad aspects of knowledge about your systems that you must have at your fingertips in order to prevent an outage.

In this essential guide, sponsored by Redgate, the aspects of these areas that are most important for monitoring SQL Server will be discussed in depth.