Cloud and Datacenter Management Blog

Microsoft Hybrid Cloud blogsite about Management

Do your #SQL Assessment with Microsoft OMS before your New Project Starts in Production #MSOMS

Leave a comment


OMS Dashboard

Microsoft Operations Management Suite (OMS) Dashboard Online

Lot of Enterprise Organizations do New Microsoft Projects on-premises in Datacenters installed by the IT Department or by external third party with a
Microsoft SQL instance solution configured. Before your New project is going into production for your customers, It’s very good to do a
Microsoft Operations Management Suite (OMS) SQL Assessment to see if your SQL Solution is installed and Configured well.

If you don’t have a Microsoft Operations Management Suite Plan, you can get one here

OMS Ebook

Installing MSOMS agents on your SQL Servers or get connected with SCOM first with this Free E-Book

SQL Assessment solution

When you Login to OMS, you have to add the SQL Assessment Solution

When the SQL Assessment Solution is activated, It can take a while because the assessment has to collect data of the SQL settings.

When It’s finished collecting data you will see this on your MSOMS Dashboard :

OMS SQL

Click on the SQL Assessment here

SQL Assessment dash

Here you see the SQL Assessment Dashboard

It does SQL Assessments on the following topics :

  • Security and Compliance
  • Availability and Business Continuity
  • Performance and Scalability
    Upgrade, Migration and Deployment
    Operations and Monitoring
    Change and Configuration Management

Here you see Microsoft Best Practices Advice for your SQL environment, but It’s also helping you to get the job done if configuration is needed
like in this example :

OMS SQL Recommendations

Here we get advice about Backup settings

OMS Recommendation

In this recommendation there is also a link to Recovery Models (SQL Server) to help you out

So Before your New Project goes into Production state for your Customers, It’s important to get fully in Control of the best practices with #MSOMS on
your Solution.

Try OMS

Get Started Today with Microsoft Operations Management Suite (OMS) here

Here you can find more Technical Documentation on MSOMS

And Follow Microsoft OMS and Microsoft MVP’s on Twitter Hashtag #MSOMS

Author: James van den Berg

I'm Microsoft Architect and ICT Specialist and Microsoft MVP Cloud and Datacenter Management Microsoft MVP Windows Insider Microsoft Tech Community Insider Microsoft Azure Advisor

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.