Red Gate forums :: View topic - Top 10 Expensive Queries
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Top 10 Expensive Queries

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DBdave



Joined: 03 Oct 2013
Posts: 5

PostPosted: Fri Jan 31, 2014 3:33 pm    Post subject: Top 10 Expensive Queries Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Mon Feb 03, 2014 12:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group