SQL Server CPU Load
Mike78
Posts: 5 Bronze 1
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
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
Comments
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?