July 22, 2013 at 12:06 pm
hi soory for stupid question but whats difference between sql server and sql server agent ???
arent both windows services .if yes then why can we allocate memory to sql server but not agent
does lack of memory to OS can cause sql server agent to stop
July 22, 2013 at 2:23 pm
anoop.mig29 (7/22/2013)
hi soory for stupid question but whats difference between sql server and sql server agent ???arent both windows services .if yes then why can we allocate memory to sql server but not agent
does lack of memory to OS can cause sql server agent to stop
Eg. Because the sql server use much more memory than the sql agent.
Like all services and programs lack of memory (Windows out of memory error) can cause sql agent to stop working.
July 23, 2013 at 1:52 am
Yes they are both windows services but the Agent will use very little memory. You should always leave 4GB for the OS. The SQL service can take the rest. The Agent will then use a section of the memory of what is left.
July 23, 2013 at 3:16 am
Also , SQL server Agent is responsible and take care for all the sql jobs and maintenance plan jobs that occur in the server. So if you have a scheduled job make sure SQL Server agent is started and running.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply