SQL Server Health Check

SQL Server Health Check

Are your Microsoft SQL servers healthy and operating at full capacity or do you just need to have detail status documents on your server?  A new service offered by OTT, Inc. is a ‘SQL Server Health Check’; with this service we will run a full diagnostic check on your SQL server, as well as provide detailed status reports.

What do you get with this service?

  1. Basic Server Setting Details
  2. SQL Database Settings/Properties for all your user SQL databases
  3. Detailed Security Reports
    1. Security logins and access levels
    2. Security Audit
      1. Login Counts
      2. Accounts with System Admin rights
      3. Fixed Server Roles
      4. Fixed Database Roles
      5. Non-Fixed Database Roles
      6. Server Level Permission Details
      7. Database Level Permission Details
      8. Password Policy Details
      9. Orphan Logins
      10. Orphan Users
      11. Database Owner Details
  1. Backup Details
    1. List of databases with no resent backups
    2. List of databases with resent backups
  2. Database Growth Settings/Rates
  3. SQL Agent Jobs with Status
  4. SQL Backup Settings (per database)
  5. 30-60 Minute Session with OTT, Inc. Consultant to go over Results and Provide Recommendations