Database Details

This resource provides tools and details for the current database. The management tools may require Administrator access to use.

The tools use credentials entered when configuring the server for monitoring through Discovery or manually by adding to a node.

  • Management: This provides tools allowing you to more easily manage and troubleshoot the current application.
  • Database Name: Displays the name of the current database.
  • Performance Status: Displays the status of the current database.
  • Operational State: Displays whether or not the database is currently online.
  • Recovery Model: Displays the type of recovery model employed on the listed database. This can be either, Simple, Full, or Bulk-Logged. For more information, refer to the following MSDN article: http://msdn.microsoft.com/en-us/library/ms175987(v=sql.105).aspx
  • Collation: Displays the method of sorting used by the database. (In the above image, Latin1 means the server treats strings using Charset Latin 1, i.e. ASCII. CI means Case Insensitive. AS means Accent Sensitive ('ü' does not equal 'u')).
  • Compatibility Level: Displays the compatibility level of the current database. The value displayed in this field correlates to the bulleted table below:
    • 60 = SQL Server 6.0
    • 65 = SQL Server 6.5
    • 70 = SQL Server 7.0
    • 80 = SQL Server 2000 
    • 90 = SQL Server 2005 
    • 100 = SQL Server 2008 
    • 110 = SQL Server 2012
  • Last Backup: Displays the date and time of the last successful backup for the current database.
  • High Availability Group: Displays the database mirroring status and details of the mirrored database, if available.