Blog & Company Updates

Overview of Analysis Services Monitoring

Do you want to learn how to monitor the health of Azure Analysis Services servers? In a recent webinar with Principal Consultant, Alan Faulkner, he explores several different monitoring tools that range from monitoring the health of Azure Analysis Services servers to profiling data for SQL Server Analysis Services events.

There are many events that you can monitor and a variety of different monitoring tools. Choosing the right tool is based on the type of monitoring that needs to be done, as well what platform you’re focused on such as multi-dimensional, tabular or Azure Analysis Services.

Monitoring option available are:

  • Azure Metrics Explorer – a free tool in the Azure portal that helps you monitor the performance and health of your Azure Analysis Services servers.
  • Azure Diagnostics – used to monitor and log Azure Analysis Services server performance.
  • SQL Server Profiler – tracks engine process events and captures data about those events enabling you to monitor database and server activity.
  • Extended Events – a lightweight tracing and monitoring system that uses very few system resources, making it an ideal tool for diagnosing problems on production and test servers.
  • Trace Events – follows the activity of an Analysis Services instance by capturing and analyzing trace events and are typically grouped to find related trace events more easily.
  • Dynamic Management Views (DMVs) – queries that return information about model objects, server operations and server health.
  • Performance Counters *
  • Log Operations*

*The bottom two are more specific to Analysis Services multi-dimensional and are not focused on in this presentation.

This webinar will focus on and demo Azure Metrics Explorer, Azure Diagnostics and SQL Server Profiler. If you’re interested in learning more about these monitoring tools, you can watch the complete webinar below.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

 

Author

  • 3Cloud is a “born in the cloud” Gold-certified Microsoft Azure technology consulting firm and Azure Expert Managed Services Provider that provides cloud strategy, design, implementation, and managed services to clients across multiple industries. Founded by former Microsoft technology leaders, 3Cloud combines a team of highly experienced cloud architects and technologists with a strong network of Microsoft sales and engineering relationships to deliver the ultimate Azure experience for clients. 3Cloud is headquartered in Chicago, Illinois with offices in Dallas, Texas and Pittsburgh, Pennsylvania and supports clients throughout North America and Europe. To learn more, visit www.3cloudsolutions.com.

3CloudOverview of Analysis Services Monitoring