Top 10 Expensive Queries

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

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?

Thanks
Dave
DBdave
 
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 support@red-gate.com 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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests