views:

15

answers:

0

I use visual studio 2008 with sql server 2008 and all my applications and databases are installed on my desktop. No server priviledges as yet. I noticed for the first time and probably since my apps are a little different now; but when running 6 apps at one that all access the same database but different tables with some accessing the same table as well..that sqlserv.exe appears twice in task manager and the cpu usage is going crazy causing my pc to crawl; it doesnt seem to be using a lot of memory though compared to other processses I have a dual core [email protected] Ghz with 2 GB of Ram. Is there someway I can reduce the cpu usage; perhaps configure something in sql server config management or is this t ypical of this kind of usage when running many visual studio apps with sql server 2008.

related questions