Ingeniously simple database development in Visual Studio
Moderators: David Atkinson, Paul Stephenson, GrahamH, james.allison
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?
- Posts: 1
- Joined: Fri Jun 29, 2012 7:34 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?
Technical Support Engineer
- 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