sqlserver.exe use 100% cpu

  • Thread starter Thread starter Chi Tang
  • Start date Start date
C

Chi Tang

Hi,

I just found that after I run a ADO.NET application couple times my machine
cpu usage increase to 100%. From TaskManager I see the sqlserver.exe
process causes the cpu usage. Do I need to call some api to close the
connection or the Garbage Collection will do something later? Thanks for
any help,

CT
 
It's not "normal" for SQL Server to use this % of the CPU. Without knowing
more about what you're doing, it's hard to say what to do. However, I doubt
if closing connections or running the GC will solve anything.

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top