Top 10 Expensive Queries

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Top 10 Expensive Queries

Postby DBdave » Fri Jan 31, 2014 3:33 pm

Top 1 execution count query on my DB:

insert into @ValueTable ( [Value]) Values (@NextString)
5,000,000 calls a day.

Where is this being called from?

Posts: 8
Joined: Thu Oct 03, 2013 11:21 am

Postby chriskelly » Mon Feb 03, 2014 12:02 pm

I'm sorry, but there is not enough information to make any kind of judgement.

If you think that this query is being generated by SQL Monitor then please send the SQL Monitor error log files to quoting the ticket number #12329 in the subject line.

However, if this query is simply listed in the Top 10 Queries field of the tool, then all the available information is included there. Assuming that you are using version 4.0 then you should be able to click on the query and find out more information about it.
Chris Kelly
Technical Support Engineer
Posts: 368
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: Bing [Bot] and 0 guests