I just joined a project which is live for the last 4 - 5 years.
This project is using SQL SERVER 2012 and on the server it has around 1500 databases.
I am noticing that SQL Server is consuming all the assigned memory (which is around 40GB).
Many time Transactions or query are getting timeout by SQL Server these days.
I checked and found that msdb file has grown to 68 GB in size. I am not sure that this is causing all these slow ness.
I tried to run the maintenance plan to clear out msdb but it just did not get ended. I tried it to run for two full days but then also it did not finished.
What I need to know is how can I clear this MSDB and is it one of the reason of this memory consumption by SQL Server