SQL Dependency query text

Question

I have noticed that on one of my old asp.net applications (running on Azure now and now using SQL azure database) that I get the SQL txt for all queries run against the database contained within the SQL Dependency telemetry. This is great and has helped me target queries to optomise.

I have a newer app (running in a raskspace data centre) that is also showing SQL telemetry, but the query txt is missing.

Do I need to be running within Azure for the query txt to be included, or is there something that I can do to enable this feature?

Thanks for all your help.

Dmitry Matveev · Accepted Answer · 2016-01-16 02:03:04Z

1

I might be mistaken here, but I remember that when one uses AI Status Monitor to collect dependencies - the command text is collected, when one uses .NET 4.5.2 and no AI Status Monitor - then the embedded .NET collection does not extract the command text.

This might be your case if the old asp.net app you mention is .NET 4.0 and AI Status Monitor is installed on that box, while the new app is 4.5+ without the AI Status Monitor on the box (which might be expected for the data center).

answered Jan 16, 2016 at 2:03

Dmitry Matveev

2,70414 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

SQL Dependency query text

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related