Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anoop_mig25
Starting Member
20 Posts |
 Posted - 2013-07-22 : 13:42:02
|
| hi 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-22 : 13:48:55
|
| sql server is the name of the product. It has various components implemented as services like database engine component denoted by SQL Server service, Reporting Services denoted by Reporting Services service etc. SQL Server Agent service denotes the scheduler component of SQL server called agent which is used for automated execution of scheduled tasks created on the SQL Server. It has no other function other than managing automatic execution of jobs as well as taking care of schedule etc. All the data/metadata required by agent are stored by itself in a system database called msdb. Thats why it doesnt require any memory by itself compared to database services etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Difference between sql server and sql agaent