How can we help you today? How can we help you today?

Problem with SQL Profiler and Sql Prompt

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.
grothag
0

Comments

2 comments

Sort by
  • chriskelly
    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".
    chriskelly
    0
  • chriskelly
    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-ref ... ions-72662
    chriskelly
    0

Add comment

Please sign in to leave a comment.