DTSrun.exe consuming high memory. 1

[robonix]

I have a SQL database residing on a server with 2GB RAM,36GB Harddisk and Windows NT OS.The database version is SQL 7.0.
Its a call centre environment where agents use a front end tool which connects to this database residing on the server.
As of now the speed of accessing this database is drastically decreased.On having a close look on the server I found a process called "Dtsrun.exe" consuming large amount of memory and even the CPU time.
In any manner if I can control this process in order to boost the speed and to mantain a smoother access to this database..

Thanks

robonix.........

 

[tlbroadbent]

DTSRUN.exe is used to execute DTS packages. These can be performing maintenance, importing/exporting data, querying the database, executing stored procedures and myriad other tasks. Usually they are started by a SQL Agent job. You and/or the system administrator (or DBA) should analyze the jobs and packages on the server.

You may find server and database maintenance runs scheduled during peak usage hours. These should be run during off hours.

The packages may be running SQL queries or stored procedures that are not optimized. Some tuning of queries, procedures, views and tables may be required. Also, examine tables to make sure necessary indexes exist and statisitcs are updated regularly. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.