February 7, 2006 at 5:37 am
While using the sp_who2, result shows msdb database taking lot of memory. Please advice me why this happen, and how it will be solved.
Manish Sharma
February 7, 2006 at 7:47 am
generally all activity related to MSDB is due to SQL Server Agent tasks. It is not uncommon to see large amounts of CPU and DISK IO utilization as these are cumulative values you are looking at and reset once Agent is restarted or SQL Server is restarted in some manner. Look at the ProgramName column and you will see most likely SQLAgent - Generic Refresher and SQLAgent - Alert Engine. Keep in mind these values are cumulative so the longer the server is up the higher your values will appear, they are not based on a single interaction.
February 9, 2006 at 2:12 pm
are you running sp_who2 or sp_who2 active?
October 31, 2006 at 9:49 am
So...The longer the server is running the more ram the generic refresher, and other sql agents will take up?
What do these agent processes, namely the generic refresher do?
Sorry for the generality of this question.
November 1, 2006 at 2:41 pm
It is for barsuk. What does sp_who2 active mean?
Many thanks in advance.
November 7, 2006 at 11:54 am
sp_who2 active shows the list of active t/a's, processes and connections running on your server
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply