Re: Explain TSQL running

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Just D. (no_at_spam.please)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 10:41:54 -0700

Hi RADl0PASlV,

>> The question is why is ISQLW so busy. What is it doing ? I thought it
>> just
>> submitted the batch and sat back waiting got the result. And it doesn't
>> really improve when you put this into a Stored Procedure.
>
> It's really interesting. It must be something with DBNETLIB dlls.

Not only that is interesting. I stopped all computers and connections around
and started this test on my machine - the CPU load is 1-2% and that's all!
Why? If I want to do something, then why this MSSQLServer decides itself how
it should use my resources? I have 3.2 HT processor and I allow MSSQL Server
to use both sub-processors, but it doesn't.

Anyway, that's very strange. Placing the same code to the SP doesn't help,
same result, same duration, same CPU Load.

Just D.

Relevant Pages

  • Re: Explain TSQL running
    ... >> submitted the batch and sat back waiting got the result. ... >> really improve when you put this into a Stored Procedure. ... and started this test on my machine - the CPU load is 1-2% and that's all! ...
    (microsoft.public.sqlserver.clients)
  • Re: Explain TSQL running
    ... >> submitted the batch and sat back waiting got the result. ... >> really improve when you put this into a Stored Procedure. ... and started this test on my machine - the CPU load is 1-2% and that's all! ...
    (microsoft.public.sqlserver.programming)
  • RE: Serial communication causes high cpu load
    ... introduced some busy waiting, if the communication got too fast -- in order ... to work around some problems of my embedded device. ... serial communication on WIN32 is no cpu hog! ... > causes a cpu load of about 2 %! ...
    (microsoft.public.win32.programmer.kernel)