Proccess keep running. Cant find a solution

pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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!

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ileanab
    yes, I tried that too, and it does not work.... Any suggestions?
    0 pointsBadges:
    report
  • ChasTheDataGuy
    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 www.SQLSIG.org
    0 pointsBadges:
    report
  • Ileanab
    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? ;(
    0 pointsBadges:
    report
  • ChasTheDataGuy
    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.
    0 pointsBadges:
    report
  • Ileanab
    Sorry about the spanish part :) Thanks for your advice... I'll be checking the installation and getting more info about the application log events.
    0 pointsBadges:
    report
  • Petroleumman
    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!
    0 pointsBadges:
    report
  • Ileanab
    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!
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following