Monitoring Availability Groups—New Tools from Solarwinds

存储架构 2017-03-16

Monitoring Availability Groups—New Tools from Solarwinds

March 15, 2017 Leave a comment

As I mentioned in my post a couple of weeks ago, monitoring the plan cache on a readable secondary replica can be a challenge. My customer was seeing dramatically different performance, depending on whether a node was primary or secondary. As amazing as the Query Store in SQL Server 2016 is, it does not allow you to view statistics from the readable secondary. So that leaves you writing xQuery to mine the plan cache DMVs for the query information you are trying to identify.

My friends at Solarwinds (Lawyers: see disclaimer at bottom of post) introduced version 11.0 of Database Performance Analyzer (DPA, a product you may remember as Ignite) which has full support for Availability Group monitoring. As you can see in the screenshot below, DPA gives a nice overview of the status of your AG, and also lets you dig into the performance on each node.

There are a host of other features in their new releases, which you can check out some of their new hybrid features in their flagship product Orion . Amongst these features, a couple jumped out at me—there is now support for Amazon RDS and Azure SQL Database in DPA, and there is some really cool correlation data that will let your compare performance across your infrastructure. So, when you the DBA is arguing with the SAN, network, and VM teams about where the root cause of the performance problem, this tool can quickly isolate the root cause of the issue. With less fighting. These are great products, give them a look.

Disclaimer: I was not paid for this post, but I do paid work for SolarWinds on a regular basis.


Placement Container Playground 2 This is a brief followup to placement container playground , wherein I've been using sticking placement into a container with the smallest footpri...
ADS-B skygrazing This is a followup to my previous post about bringing life back to an oldMacintosh Classic II. Having an iconic Mac with a Raspberry Pi inside do...
Distributed Databases Should Work More Like CDNs Optimizing distributed database performance is complicated––with tons of moving parts, it’s a difficult knot to begin untangling. While there are many...
性能场景之数据 在性能测试过程中,最简单的系统架构图也大概就是这样了。 在数据这一方面,有几个地方是要注意的。 DB中的,包含各种类型的数据库;2. Cache中的,包含各种类型的cache;3. 压力工具中的,参数化数据。 在执行场景之前,需要知道前两个里面的数...
十年莽撞 IT 路 按:博文视点周筠老师多次叮嘱我写点关于个人成长的心得,颇感压力。回首在 IT 这个行业也差不多有 10 年了,在互联网也有 7 年之久,没做成什么惊人的事业,也没什么赚到大把的钞票,如果冒充什么成功导师大谈人生感悟岂不是会被读者朋友笑掉大牙,当然引来板砖也说不定。如果说有可取的,恐怕也就是自己莽撞的...
The SQL Herald

责编内容来自:The SQL Herald (本文源链)
本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。