SQL Server Intelligence Pack
SQL Server is one of the most valuable and popular workloads in the world so I"m desperately asking you to build SQL Server Intelligent Pack. Now SQL Server monitoring is only available as SCOM MP, but it has poor data analysis and reporting capabilities. I assume that SC Advisor must be great platform to fill this gap. Another issue of SQL MP is complex configuration (e.g. when you have many DBs or Clustered SQL and, of course, security configuration...). Intelligent pack will be able to solve all these problems! Regarding the most critical monitoring scenarios I'm thinking about space monitoring (Hah! It's still a big pain!), configuration and security monitoring.
We have just enabled a ‘SQL Assessment’ Intelligence Pack – around ‘adherence to best practices’ for SQL configuration/risk assessment.
This is the first of a set of ‘vertical’ assessment IPs for specific technologies/workloads (i.e. SQL, AD, etc) – as opposed to the uber ‘Configuration Assessment’ that was already in the old Advisor.
This has proven to be a successful approach and format for enterprise customers who have been using Microsoft Premier support – programs such as RAP (risk assessment program) tailored around specific technologies have been very successful.
Not currently focused on real-time ‘monitoring’ scenarios by workload at the moment; that will come as we get more ‘real time’ with the service. In that regard, we believe the right approach is ‘Log Management’ – where you can configure your own log collection. As we add Performance Counter collection too
http://feedback.azure.com/forums/267889-azure-operations-insights/suggestions/6519061-collect-custom-windows-performance-counters , coupled with dashboards http://blogs.technet.com/b/momteam/archive/2014/10/16/custom-dashboard-in-advisor.aspx you see how this allows to define something like an alerting criteria based on a search query, that the tile can visualize.
I don't get why configuring monitoring of Always on Availability group should be that difficult. Mirocost provided solution to add into your home page called 'SQL assessment' which display the result of best practices on SQL servers are they followed or not. In order to create your own you have to create new Tile/Own View and then you have to type some wired query which is useless because can be easily replaced by drop down many to choose from your available sources. And the query is with syntax 1 of a kind it is not PowerShell it is not C# it is not SQL. From other side other companies like redgate offer for low coast solutions you just add your server and automatically detect all the disks is it clustered or not all the resources and everything and you just choose what you don't want to see.
reality people are interested are their critical job which is doing important ETL or data changes runned successfully. Was their some blocking in the last 1 hour (some diagram maybe), Free space ,Critical error, Cluster resources, Latency of that problematic replication, Availability group.