| Author |
Message |
grothag
Joined: 29 Jun 2012
Posts: 1
|
 Posted: Fri Jun 29, 2012 8:38 pm Post subject: 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. |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Mon Jul 02, 2012 8:16 pm Post subject: |
|
|
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 |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Mon Jul 02, 2012 8:22 pm Post subject: |
|
|
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 |
|
|
|
|
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
