Red Gate forums :: View topic - SQL Server CPU Load
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Connect
SQL Connect forum

SQL Server CPU Load

 Search in SQL Connect forum
Post new topic   Reply to topic
Jump to:  
Author Message
Mike78



Joined: 29 Jun 2012
Posts: 1
PostPosted: Fri Jun 29, 2012 7:39 pm    Post subject: SQL Server CPU Load Reply with quote
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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 251
Location: Cambridge, UK
PostPosted: Mon Jul 02, 2012 7:16 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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