I have a number of servers that are monitored by both SQL DM and BI Manager. SQL DM will not report any signs of server stress but SQL BI will regularly report that the SSAS CPU is 130%+ and the Context Switching is 7000+ per/sec on some of my SSAS Servers. How is BI Manager coming up with its numbers?
This sounds like it may be a bug in SQL BI Manager, especially if DM is not showing the same values. If you could send any screenshots of the behavior that you could to vicky dot harp at idera dot com I will be sure that the engineering team takes a look.
Powered by IDERA