I’m going to call the series on System Center for the SQL Server DBA complete with this one last post today. First, here is the full series to date … my apologies for the lack of post naming consistency!!
What I wanted to point you all to is an update to my methodology of using SQL Server 2012 business intelligence leveraging in-memory analytical models to provide very important insights into your SQL Server environment with System Center Operations Manager. The link is here to my blog on this on SQL Server Pro Magazine.
By leveraging the SCOM data warehouse, you can create compelling reports quickly with a semantic model that includes SQL Server performance counters, server health and history for long-term history and trends. Use this to create your server performance baselines, alerts, trends, etc.
The take away for SQL Server DBAs is that it is very, very important to gain that level of insight into your databases.