Post reply

SQL Agent90.exe

  • February 22, 2011 at 6:56 am

    #232432

    Is it necessary to have a 10 SQLAGENT running for each SQL 10 instance in a SQL 2008 environment. Also running are 10 sqlservr.exe.

    Does this have a bad effect on the overall performance of SQL and if so is there anything I can do you try and put it right?

  • February 22, 2011 at 7:05 am

    #1289840

    I dont understand the question. But looks like you have also a sql 2005 instance running if you have a 90 agent

  • February 22, 2011 at 7:27 am

    #1289848

    You will need the agent if you want to run scheduled job under a particular instance. If there is no need for any scheduled jobs, such as maintenance jobs, to be run for an instance, you may not require agent for that instance. With that said, you can run some scheduled jobs via agent of other instance with scripting.

  • February 22, 2011 at 7:32 am

    #1289853

    Yes your right...2005...slip of the keyboard.

    Sorry, these are images running in the Windows Task Manager. For each instance there is an aimage running...is this normal?

  • February 22, 2011 at 7:36 am

    #1289857

    yep every sql instance has it own sqlserv.exe and his own sqlagentxx.exe running

  • February 22, 2011 at 8:08 am

    #1289871

    Thank you all for your help...it now makes sense

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply