none
How to clear the MemToLeave area of SQL Server without restarting the service? RRS feed

  • 问题

  • Dears,

    Our developers implemented SQLCLR objects recently in our production SQL Server, and now due to the SQLCLR implementation, the linked servers and database mails all stop working due to "run out of memory" issue.

    Now I don't want the CLR to hold the MemToLeave, we want Linked servers and Database mails to be work as previously. I know that a service restart should solve the problem, but it's a critical server so I would like to know if there is a way to accomplish this without restarting the SQL Server.

    I tried all of below but don't help:
    DBCC DROPCLEANBUFFERS
    DBCC FREEPROCCACHE
    DBCC FREESYSTEMCACHE('ALL')

    Any idea would be appreciated a lot!

    Thanks!

    2010年6月9日 9:42

全部回复