How can we improve Azure Log Analytics ?

New Requirments SQL assessment

Great solution and it's helping to complete the readiness in near real-time. We want to recommend folks check on the tool so it will help E2E validations easily.

Cluster checks:
1- Cluster checking for Quorum Voting Rights (QVR), Quorum Configuration, Split brain vulnerability, and current Possible owners for Cluster Group and SQL resources.
2- Need to scan all relevant clusters and remediate by moving the Cluster Group to the same node hosting the SQL group (No alerts will be sent).
a. No Auto remediation and it should show-up in the OMS.
3- Scan the cluster logs

SQL level Checks:
BigEye checks consist checking for a match across principal and replicas for:
• Server principals (logins)
• Jobs
• SQL Config - sp_configure settings
• SQL Server and Agent accounts
• Disks
• SQL Server Always sync and setup status

5 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Manoj Yarlagadda shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base