Of course you realize 2 procs hyperthreaded to 4 isn't equal to 4 real
processors! Based on what I've read it would be a little less than 3. I
thought hyperthreading was only officially supported on W2K3?
Did this same behavior happen without hyperthreading
What process are you running that is launching the NTVDM.exe?
Thanks,
Ralph W. Davis
working from home
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: Priyantha Karunadasa
[mailto:mssqldba-ezmlmshield-x54048638.[Email address protected]
Sent: Saturday, July 30, 2005 8:36 AM
To: LazyDBA Discussion
Subject: 100% CPU utilized for NTVDM.EXE when it called from SQL Server
Agent Jobs
Dear All,
There is a new issue I have faced in my server (Two 1.5G Hyper threading
Processors, 2 GB RAM, 80GB 5 Disk RAID, Windows 2K SP4, SQL 2K SP3). When
the scheduled SQL JOBS are called it starts using 100% of all 4 hyper
threaded processors. This started from last Thursday morning onwards. The
reason is when these JOBS are called SQL loads the windows NTVDM.EXE to run
it on command mode. Now when the NTVDM.EXE is called for the first instance
it utilizes 25% of all four logical processors (2 physical processors) and
does not use the same NTVDM's WOW extension for the other called instances,
instead it opens another instance of the same NTVDM.EXE. Likewise when it
reaches four instances CPU usage becomes 25% * 4 = 100% and the server
freezes. We need to find out why it creates multi instances of the NTVDM.EXE
and recover the server ASAP. For the time being I have disabled all the SQL
Jobs for the users to work with the system. But these jobs are required to
process the polled sales and transfers done at the outlets.
Matter of fact we were running all these sql jobs before for the past one
year without having any similar issues and nothing is changed on the server
side (H/W or S/W) components or configurations prior to the problem.
Seek immediate expert help on this matter.
Best Regards,
Priyantha Karunadasa AACS
Project Manager - FM
iOM (Pte) Ltd./ RSH-ME LLC
Mobile: +971 50 2517323
Office : +971 4 3966676 - Ext.338
E-mail : [Email address protected]
URL : http://www.iomworld.com, http://www.retailigence.com
Yahoo/MSN: a_priyan
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and delete
the material from any computer.
MS Sql Server LazyDBA home page