SQL Server CPU Load

Ingeniously simple database development in Visual Studio

Moderators: David Atkinson, Paul Stephenson, GrahamH, james.allison

SQL Server CPU Load

Postby Mike78 » Fri Jun 29, 2012 7:39 pm

Hello,

When working in VS2010 with the SQL Connect extension enabled I notice a significant increase in CPU workload on the sql server (sqlservr.exe) where the load is somewhere between 3 and 7% all the time. This does not happen when the extension is disabled. In my setup I have a database project which connects to a SQL server 2005 instance.

Any ideas as to why the sql server is constantly used even if no database related activity is performed within VS2010?

Thanks,

Mike
Mike78
 
Posts: 1
Joined: Fri Jun 29, 2012 7:34 pm

Postby chriskelly » Mon Jul 02, 2012 7:16 pm

Thank you for your post.

SQL Connect will be checking for changes (polling), so that when another developer commits a change then it is picked up. This helps you ensure that you are always using the latest version of the database in your local project.

Do you find this usage concerning?
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Connect

Who is online

Users browsing this forum: No registered users and 0 guests