PROBLEM WITH THREADS - WIN 2003

Hi

We have a application with Framework 1.1 and Vs .NET 2003.
the application has a service with pooling; like a
File system Watcher, but works.

the system works fine in the development enviroment with
a performance very good; but production not.
-------------------------------------------------------------------------------------------

SAMPLE CODE
-------------------------------------------------------------------------------------------

using Microsoft.Appli cationBlocks.Da ta;
using System.Data.Sql Client;
using System;
using System.ServiceP rocess;
using System.Diagnost ics;
using System.Configur ation;
using System.Threadin g;
using System.Runtime. Remoting;
using System.IO;
using System.Data;
using LibreriasCIV.Pr oyectos;
using CLSutilidades.U tilidades;
using System.Enterpri seServices;

public class CIVmonitor : System.ServiceP rocess.ServiceB ase
{
private DateTime timeStart; //Used to note the start time of the service
private DateTime timeEnd; //Used to note the end time of the service
private TimeSpan timeElapsed = new TimeSpan(0); //' Initialize to 0;
// Used to calculate difference between timeEnd and TimeStart
private TimeSpan timeDifference;
private bool isPaused = false; // Notes whether the service is paused;
//ManualResetEven t b = new ManualResetEven t(false);
private bool INICIAR;
private DataSet DSproyectos ;
CLSutilidades.U tilidades.cUtil idadesSeguimien to OBJutil= new
CLSutilidades.U tilidades.cUtil idadesSeguimien to();//PARA TRABAJAR LOS ARCHIVOS
#region " Component Designer generated code ";

public CIVmonitor()
{
// This call is required by the Component Designer.
InitializeCompo nent();
// Add any initialization after the InitializeCompo nent() call
}
//UserService overrides dispose to clean up the component list.
protected override void Dispose(bool disposing)
{
if (disposing)
{
if (components != null)
{
components.Disp ose();
}
}
base.Dispose(di sposing);
}
// The main entry point for the process
static void Main()
{
System.Runtime. Remoting.Remoti ngConfiguration .Configure(AppD omain.CurrentDo main.SetupInfor mation.Configur ationFile);
System.ServiceP rocess.ServiceB ase[] ServicesToRun;
// More than one NT Service may run within the same process. To add
// another service to this process, change the following line to
// create a second service object. For example,
ServicesToRun = new System.ServiceP rocess.ServiceB ase[] {new CIVmonitor()};
System.ServiceP rocess.ServiceB ase.Run(Service sToRun);
}

//Required by the Component Designer
private System.Componen tModel.IContain er components = null;
// NOTE: The following procedure is required by the Component Designer
// It can be modified using the Component Designer.
// Do not modify it using the code editor.
private void InitializeCompo nent()
{
//
// CIVmonitor
//
this.CanPauseAn dContinue = true;
this.CanShutdow n = true;
this.ServiceNam e = "CIVmonitor ";

}

#endregion
// OnContinue occurs when the user asks a paused Service to continue. In
order
// for this method to be called the CanPauseAndCont inue property must be
// set to true. (It is false by default.)
protected override void OnContinue()
{
// Begin measuring the elapsed time. This means setting the
// timeStart back to the current time, and resetting isPaused
// to false
CrearTabla();
if (isPaused)
{
timeStart = DateTime.Now;
}
isPaused = false;
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"","CIVmonito r Reanudo Operación ","CIVMONITOR", "ProcessDir ");

}

// OnPause occurs when the user asks a running Service to pause. In order
// for this method to be called the CanPauseAndCont inue property must be
// set to true. (It is false by default.)
protected override void OnPause()
{
timeEnd = DateTime.Now;
DSproyectos = null;

if (! isPaused)
{
timeDifference = timeEnd.Subtrac t(timeStart);
timeElapsed = timeElapsed.Add (timeDifference );
}
isPaused = true;

OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"","CIVmonito r Pausado ","CIVMONITOR", "ProcessDir ");
}

// OnShutdown occurs when the computer is powered off and the
// Service has not been stopped. In order for this method to be called
// the CanShutdown property must be set to true. (It is false by default.)
protected override void OnShutdown()
{
this.OnStop();
DSproyectos = null;
}

// OnStart is called whenever the service is started.
protected override void OnStart(string[] args)
{
System.Threadin g.Thread.Curren tThread.Name = "GESTOR INTEGRAL DE ARCHIVOS
CIV";
System.Threadin g.Thread.Curren tThread.Priorit y=
System.Threadin g.ThreadPriorit y.Highest;

timeElapsed = new TimeSpan(0);
// Initialize the Start time
timeStart = DateTime.Now;
isPaused = false;
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"","CIVmonito r Iniciado "+timeElapsed," CIVMONITOR","Pr ocessDir");
INICIAR = true;
Debug.Write("IN ICIO");
CrearTabla(); //CREAR DATASET CON CADA UNO DE LOS PROYECTOS ACTIVOS, ESTOS
SON LOS QUE SE MONITOREARAN
Pickup (); //DISPARAR LA FUNCION QUE MONITOREARA ARCHIVOS
Debug.Write("IN ICIO");
}

// OnStop is called whenever the service is stopped.
protected override void OnStop()
{
timeEnd = DateTime.Now;
if (! isPaused)
{
timeDifference = timeEnd.Subtrac t(timeStart);
timeElapsed = timeElapsed.Add (timeDifference );
}
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"","CIVMONITO R DETENIDO "+timeDifferenc e,"CIVMONITOR", "ProcessDir ");
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"","CIVmonito r Detenido por "+timeElapsed," CIVMONITOR","Pr ocessDir");
DSproyectos=nul l; //LIMPIAR DS
INICIAR =false; //BANDERA A FALSE PARA QUE NO ITERE MAS
}

private void ProcessDir()
{
//
// Processes the files in that directory
//
try
{
while(INICIAR)
{
Debug.WriteLine (" ITERANDO ");
//ITERAR POR CADA UNO DE LOS ELEMENTOS DEL DATASET
if(DSproyectos. Tables.Count > 0 )
{
if(DSproyectos. Tables[0].Rows.Count > 0)
{
//foreach(DataRow dr in DSproyectos.Tab les[0].Rows) // LOS ARCHIVOS SE
ALMACENAN UNO A UNO EN UN VECTOR
for(int index=0;index<D Sproyectos.Tabl es[0].Rows.Count;ind ex++)
{
//LLAMAR AL OBJETO QUE VIGILA CARPETAS
CLScontroladora .Controladora.c Control OBJcontroladora = new
CLScontroladora .Controladora.c Control(
DSproyectos.Tab les[0].Rows[index].ItemArray[0].ToString(),
//CLInombre
DSproyectos.Tab les[0].Rows[index].ItemArray[1].ToString(),
//PROnombre
DSproyectos.Tab les[0].Rows[index].ItemArray[2].ToString(), //PROalias
DSproyectos.Tab les[0].Rows[index].ItemArray[3].ToString(),
//PROentrada
DSproyectos.Tab les[0].Rows[index].ItemArray[4].ToString(), //PROlog
DSproyectos.Tab les[0].Rows[index].ItemArray[5].ToString(),
//PRObackup
DSproyectos.Tab les[0].Rows[index].ItemArray[6].ToString(),
//PROsalida
DSproyectos.Tab les[0].Rows[index].ItemArray[7].ToString(),
//PROextension
DSproyectos.Tab les[0].Rows[index].ItemArray[8].ToString(), //PROftp
ConfigurationSe ttings.AppSetti ngs.Get("Conexi on").ToString() );
//CONEXION DB
OBJcontroladora .ClasificarData ();
}
Thread.Sleep(in t.Parse(Configu rationSettings. AppSettings["Pausa"].ToString())); //PAUSA EN MS PARA QUE NO SE COMA EL SERVICIO LA MAQUINA
}
}

}
}
catch(Exception exp)
{
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"",exp.Messag e,"CIVMONITOR", "ProcessDir ");
}
}

private void CrearTabla()
{
SqlConnection connection = null;// SqlConnection that will be used to
execute the sql commands
DSproyectos = new DataSet("Proyec tos"); // SAVE PROYECS
try
{
try
{
Debug.WriteLine ("INICIALIZA NDO CADENA DE CONEXION");
connection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["Conexion"]);
}
catch
{
Debug.WriteLine ("ERROR");
CLSutilidades.U tilidades.cUtil idadesSeguimien to OBJutil= new
CLSutilidades.U tilidades.cUtil idadesSeguimien to();//PARA TRABAJAR LOS ARCHIVOS
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"","NO SE PUDO CONECTAR A LA DB","CIVMONITOR ","CrearTabla") ;
return;
}
DSproyectos = SqlHelper.Execu teDataset(conne ction,
CommandType.Sto redProcedure, "SpGetProyectos ", new SqlParameter("@ Estado",
"ACT") );
Debug.WriteLine ("SE RECUPERO EL DATASET
"+DSproyectos.T ables[0].Rows.Count);
}
catch(Exception exp)
{
string errMessage = "";
for( Exception tempException = exp; tempException != null ; tempException
= tempException.I nnerException )
{
errMessage += tempException.M essage + Environment.New Line +
Environment.New Line;
}
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"","ERROR
AL TRATAR DE CONSULTAR INFORMACION DE CLIENTES/PROYECTOS EN LA DATABASE -
"+exp.Message," CIVMONITOR","Pr ocessDir");
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"",exp.Messag e,"CIVMONITOR", "ProcessDir ");
}
finally
{
if(connection != null)
connection.Disp ose();
}

}
private void Pickup ()
{
try
{
System.Threadin g.Thread.Curren tThread.Name = "Monitor CIV";
Thread objThread= new Thread(new ThreadStart(Pro cessDir));
objThread.Name = "Gestor Directorios";
objThread.Prior ity = System.Threadin g.ThreadPriorit y.Highest;
objThread.Start ();
Debug.WriteLine ("PASO POR PICKUP ");
}

catch(ThreadAbo rtException exp)
{
OBJutil.WriteLO G(Configuration Settings.AppSet tings.Get("LOGp ath").ToString( ),"",exp.Messag e,"CIVMONITOR", "ProcessDir ");

}

}

}

We changed machine.config and nothing.

The performance in production is very slow, the system is WIN 2003.
DEVELOPMENT ENVIROMENT: WIN2000 - SQL SERVER 2000

PRODUCTION ENVIROMENT: WIN2003 - SQL SERVER 2000

What can i do?

Ideas

The application has a service with MultiThreading. For each task
starts a Thread.