Have you tried out Database Health Monitor and the Quick Scan report?
The Quick Scan report does a quick check (sometimes not so quick depending on the system). It checks for server best practice recommendations, and security and performance recommendations as suggested by Database Health Monitor.
You can get to the Quick Scan report from the “Instance Reports” section of the Server Overview page.
Once you run the Quick Scan report take a look at the list of suggestions and recommendations for your specific SQL Server, then can range from simple improvements to gigantic security flaws. Take a look at the report and see what is recommended for your SQL Server. It might look something like this:
Scroll through the list of results and see what is being recommended for your server. You might be surprised.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!