Hi All,
I made new sql server in windows 2000 server and SQL server standard edition
with 1gb memory.
The query speed is better compare than before.
But when I execute a DTS pkg in a particular task I using ActiveXscript to
read a file a write the same file. This pkg was running fine in the other
sql server but here takes I lot of time to read this file. In the task
manager the MMC.exe use 98% of the CPU and made other process slow down.
Can anyone explain to me what's going on?
How can I improve this situation?
How can I help the mmc to run better?
Tks for you help.
Johnny...