Microsoft is continuously releasing something new in database-related space and it is hard to keep up with what is new coming up. Every Sunday I will post all the new updates in the database and its related world. I will post here what is new every week and this post helps us as a ready reference. System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance.
This Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse (PDW) Appliance provides capabilities to discover, monitor, and manage your SQL Server PDW appliances. The management pack simplifies the monitoring process for PDW.
In addition to health monitoring capabilities, this monitoring pack includes a custom diagram view to visualize appliance health. The custom view has detailed knowledge about the health states for the hardware and software components. The custom view enables near real-time diagnosis and resolution of detected issues.
Note: Description is taken from the Microsoft page for System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance.
Here are a few recent blog posts on the same topic which you may find interesting:
- Slow Running Query – SQL in Sixty Seconds #146
- Sleeping vs Suspended Process – SQL in Sixty Seconds #122
- Recent Execution of Stored Procedure – SQL in Sixty Seconds #118
Let me know what you think of this blog post and if you want me to create a SQL in Sixty Seconds post for this video. If you have a similar script that you may find will be helpful to users, please do share it with me and I will post it on the blog with due credit to you.
Reference: Pinal Dave (https://blog.sqlauthority.com)