Learn More





DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

Understanding the need for Application Insights Analytics

As systems become more interconnected and consist of many small parts over a monolithic mass, one of the difficulties becomes understanding how they are running and where issues might be appearing.  For our OnDemand product, we have a combination of individual customer installations coupled with our management systems.   Each individual system runs on dynamic cloud resources, and log files and metrics are generated at the hardware, OS, database, web server and application level. 

Distributed systems have their benefits but when investigating issues the distributed log and metric streams make it hard to tie together a coherent picture.

Through our working relationship with Microsoft Azure, we started to work with Application Insights.  By working to integrate the various log streams of our systems into Application Insights we could gain a point-in-time view of requests, exceptions, metrics and more.  The Application Insights UI in the Azure Portal can provide this data in graph view or in text format using search and filtering.

While Application Insights has proved an invaluable resource for looking at the performance of an application, what it lacks is a way of performing deeper analysis of that data in a more powerful way.  Microsoft introduced us to a new feature of Application Insights called Analytics, which gives us access to the Application Insights data, but in a way where we can write our own queries, perform visualizations and export to Business Insights for further analysis. 

Application Insights Analytics provided us with the missing part of the equation for being able to combine, sort, query and filter data as we needed.  Allowing our team to use their own ingenuity and experience to find data with a powerful query language has allowed us to find insights and solve problems we didn’t even know we had.  The query language available with Application Insights Analytics is similar to SQL Queries.   A lot of interesting answers come from the questions starting with ‘I wonder if…’ – when you can write a query to express that question against the data, you will get the interesting answer to match.  Sometimes the relationships might not be plain until you visualize them, so being able to transform those interesting answers into interesting graphs with a single click provides another dimension.

A concrete example of this was when we were faced with an issue where a site was performing badly at or around a specific time of day.   If faced with diverse log file locations and formats and buried metrics data, this would be a difficult situation to catch and solve.  By constructing a query which combined CPU metrics, Server Instances, Web Requests and the Dnn Event log into a single results set, we could isolate the types of requests and exceptions occurring along a specific timeframe.  It was then a case of understanding the type of traffic that was creating the exceptions which led to high CPU.  Drilling into this traffic it became apparent that Synthetic (i.e., bot) traffic was hitting a series of URLs that a third party component was handling badly and throwing exceptions. 

The following example shows the Application Insights Analytics interface, running a query on the assembled log data and graphing it to gain insights.  The graphical representation shown here shows a distinct decrease in performance for a period of time, quickly alerting to a timeframe requiring further investigation.  By filtering down this time period and combining with exceptions, trace and metrics a much clearer view of the issue can be made.



Above : Screenshot of Application Insights Analytics showing a Bar Chart generated from an query result set

The value of instrumenting your Azure application to output to Application Insights is already clear.  Having Application Insights Analytics has provided our DevOps team with a method for filtering, querying and sorting data to gain the true picture of what is happening with our distributed systems.  When you’ve become used to looking at all your data in the one place with a single query system, any previous attempt at understanding your system will feel primitive.


There are currently no comments, be the first to post one.

Comment Form

Only registered users may post comments.


2sic Daniel Mettler (124)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (21)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (269)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?