sqlserver.exe use 100% cpu

[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

 

[William \(Bill\) Vaughn]

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.
__________________________________