Red Gate forums :: View topic - Problem with SQL Profiler and Sql Prompt
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Problem with SQL Profiler and Sql Prompt

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
grothag



Joined: 29 Jun 2012
Posts: 1

PostPosted: Fri Jun 29, 2012 8:38 pm    Post subject: Problem with SQL Profiler and Sql Prompt Reply with quote

I am trying to run trace on a database, but there are so many queries from Sql Prompt that I can't use trace at all (repeating same queries all the time, 3-5 queries per second). Why is Sql Prompt querying database so much ? How can I turn that off ? Turning off management studio is not an option.
Back to top
View user's profile Send private message
chriskelly



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

PostPosted: Mon Jul 02, 2012 8:16 pm    Post subject: Reply with quote

SQL Prompt is refreshing the local cache of information so that the Code Completion and Expand Wildcard features can give you the most accurate results.

The simple way to turn this off is by disabling SQL Prompt. Simple navigate to the SQL Prompt menu and select "Disable Code Suggestions".
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
chriskelly



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

PostPosted: Mon Jul 02, 2012 8:22 pm    Post subject: Reply with quote

Additionally, there is a SQL Prompt labs feature which allows you to disable the refresh. This means that the various functionality remains enabled, but that you have to manually refresh the local cache.

http://sqlprompt.posterous.com/auto-refresh-suggestions-72662
_________________
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