Any way to reduce background polling?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Any way to reduce background polling?

Postby EQXDev » Mon Jul 25, 2011 4:44 pm

We are currently evaluating SQL Source Control for use in our enterprise. One issue that our DBA identified was the massive amount of CPU and I/O this product uses on the SQL Server.

I assume this is due to the background polling that it uses to determine changes, however it would appear that this product is polling far too often for our needs. Is it possible to reduce the amount of polling this product performs? If not, we will not be able to use it in our environment.

Thanks.
EQXDev
 
Posts: 2
Joined: Mon Jul 25, 2011 4:41 pm

Postby james.billings » Mon Jul 25, 2011 8:24 pm

It is.
There is a post here detailing what needs to be done, and the downside of doing so.
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby EQXDev » Mon Jul 25, 2011 10:22 pm

Thanks James! That's exactly what I was looking for!
EQXDev
 
Posts: 2
Joined: Mon Jul 25, 2011 4:41 pm

Postby aolcot » Tue Jul 26, 2011 8:53 am

Nice one James! That has helped me out as well as I did find using profiler without setting a filter a touch more annoying as all the events were from SSC.

It would be nice to make this "easier" to configure from within the GUI though as I'm sure many others would want to fine tune/disable polling.
aolcot
 
Posts: 25
Joined: Tue Jun 28, 2011 3:13 pm


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests