Home > IT Answers > Microsoft Windows > Proccess keep running. Cant find a solution
Ileanab
0 pts.
 Proccess keep running. Cant find a solution
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Hi, I have SQL Server 2000 SP4 running on a server with 2GB RAM , 18GB free in the DB disk and 2.3 GB free in the OS disk. It was running normally til 2 days ago. Now I have processes (dtss and jobs) running for 2 days. I tried to stop sqlServerAgent, but it happened again. What may be wrong? How can I solve it?

Software/Hardware used:
ASKED: January 16, 2007  8:26 AM
UPDATED: January 19, 2007  9:02 AM
RELATED QUESTIONS
Answer Wiki:
Hello, You mentioned restarting just the sql agent, have you tried completely rebooting the server? The problem may not be directly related to DTSs or Jobs but possibly a malfunctioning dependent process. Good luck!
Last Wiki Answer Submitted:  January 16, 2007  9:43 am  by  Petroleumman   0 pts.
All Answer Wiki Contributors:  Petroleumman   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

yes, I tried that too, and it does not work…. Any suggestions?

Ileanab
 0 pts.
 

Have you checked the OS event logs, SQLServer and SQL Server Agent logs for errors?
Have you checked the current activity to determine if anything is blocking your jobs?
Have you ran profiler to see if it offers any answers?

Charlie
http://www.SQLSIG.org

ChasTheDataGuy
 0 pts.
 

I checked the current activity and there are no blocked process. I use the profiler too, but i did not find nothing wrong. Maybe I’m not considering the correct event classes.
I checked the OS event logs too. The application event log has a lot of MSSQLSERVER entries like: “No se encuentra la descripcion del Id. de suceso ( 17055 ) en el origen ( MSSQLSERVER ). Es posible que el equipo local no tenga la informacion de Registro o archivos DLL de mensajes necesarios para mostrar mensajes desde un equipo remoto. La siguiente informacion es par 19013″ or “No se encuentra la descripcion del Id. de suceso ( 17055 ) en el origen ( MSSQLSERVER ). Es posible que el equipo local no tenga la informacion de Registro o archivos DLL de mensajes necesarios para mostrar mensajes desde un equipo remoto. La siguiente informacion es par 8128, Using ‘xpstar.dll’ version ’2000.80.194′ to execute extended stored procedure
‘xp_sqlagent_monitor’.”

Any ideas? ;(

Ileanab
 0 pts.
 

My Spanish isn’t that good but it appears that you may have a corrupt SQL install.
Since you have ne error’s other than the one you mentioned you may want to
contact Microsoft support.

Charlie.

ChasTheDataGuy
 0 pts.
 

Sorry about the spanish part :)

Thanks for your advice… I’ll be checking the installation and getting more info about the application log events.

Ileanab
 0 pts.
 

Hello,

I’d have to agree after seeing the error message displayed in Spanish that you may have a corrupt install of SQL. If your data is in tact back up your databases and then reinstall SQL and when prompted, allow SQL to overwrite any existing files. Once SQL is installed you can restore your databases from backup. That should fix things.

Good luck!

Petroleumman
 0 pts.
 

Hi Everybody!

I finally can fix the problem reinstalling the sp4 and some other fixes. So far so good… :)

Thanks all of you for your help!

Ileanab
 0 pts.