Have option to Pause polling of database especially if user wants to use Sql Profiler.
If user wants to run sql profiler, and doesn't want all of this background database activity there should be an option in Red Gate to pause the source control polling it is constanly performing on the linked database.
We currently don’t have an option to pause polling in the tool, but you can confiugre an XML file. Please contact support@red-gate.com for details. This file would need to be set for each user.
You could also add a “Column Filter” in SQL Profiler’s Trace Properties’ Events Selection where “Application Name” is “Not like” “Red Gate%.” That should filter out the polling in your trace.
I hope this helps!
-
There's more detail on how to do this here: http://www.red-gate.com/MessageBoard/viewtopic.php?t=12837
Ideally this should be a project-level option, but please try this in the meantime. -
Micky
commented
Or at least slow it down. Does it really need to connect every second? (I don't know how often it connects, but it seems like a lot!)
