Application Insights Database Dependency Command Invalid

Question

I am using Application Insights on a web application and it is logging SQL dependencies, but the command listed is not a valid SQL command (AFAICT).

The WebApp is targeting .net 4.6.1 and I'm using Application Insights for Web version 2.1.0. It is collecting data points no problem, but the database dependencies are crazy.

The Command is shown as 'Server | Database'. Here is a copy paste of the Dependency Properties screen.

Dependency Properties
Event time         7/26/2016, 3:08:05 PM
Dependency type    SQL
Successful call    true
Result code        <empty>
Duration           1.66 ms

Command
my-db-servername | my-db-name

Related Items
Request in which this dependency call was made    1
Failed or slow calls to remote dependencies       1
All available telemetry for this operation        2
All available telemetry 5 minutes before and after this event    507

When I try to apply this 'command' using SSMS > new query, it says it is invalid.

We are using Sitefinity for part of the application and it is making 100s to 1000s of calls to the database, each lasting < 1 ms (~500us) and listing the above command as the database command.

At this point I'm not sure whether it is an app insights thing, a sitefinity thing, or something else all together.

However, I'm really interested in why that command is listed as such.

John Gardner · Accepted Answer · 2016-08-02 21:03:22Z

1

Application Insights command is not a command text. It is concatenated from multiple parameters like this:

If you run stored procedures (4.6+ or (4.0+ StatusMonitor)): server name , pipe, database name, pipe, SPROC name.
If you use StatusMonitor and you run command text: server name , pipe, database name, pipe, command text
If you do not use StatusMontior but have 4.6+ and you run command text: server name , pipe, database name.

I assume your case is 3.

edited Aug 2, 2016 at 21:03

John Gardner

25.3k5 gold badges65 silver badges78 bronze badges

answered Jul 29, 2016 at 19:52

Anastasia Black

1,90011 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mathias Rönnlund Over a year ago

Should I install Status Monitor on the web server of the database server?

Anastasia Black Over a year ago

StatusMonitor should be installed on the box that you monitor is running. It installs profiler that is attached on application start.

Mathias Rönnlund Over a year ago

To clarify, at the moment we have case nr 3. What exactly should I do to see the sql queries in the command text?

Anastasia Black Over a year ago

Sorry. I meant to write "box where app is running", not "monitor". You need to login to the box where your application is deployed, install StatusMonitor and restart IIS.

Collectives™ on Stack Overflow

Application Insights Database Dependency Command Invalid

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related