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


MS Sql Server LazyDBA home page