tag:blogger.com,1999:blog-2154285972274878988.post2548087379289600010..comments2024-03-28T01:19:52.819-06:00Comments on DAX Dude - Dynamics 365/AX: AX Issue: Application very slow. SQL server not releasing memoryDAXDudehttp://www.blogger.com/profile/15490813518772863345noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2154285972274878988.post-36380511126675137912013-01-28T00:02:22.192-07:002013-01-28T00:02:22.192-07:00Vlad, Thanks for the link. The above worked for us...Vlad, Thanks for the link. The above worked for us in the DEV and TEST boxes so I didn't look too much into it past that but it looks like this could also be from a known bug with linked servers on SQL Server 2008. Upgrading to the latest service pack should resolve this. http://blogs.msdn.com/b/psssql/archive/2009/09/22/if-you-use-linked-server-queries-you-need-to-read-this.aspx <br /><br />Also of note, since an instance of SQL by default will try to consume as much memory as possible, if there is more than one instance of SQL running on a box, the settings above MUST be set or else each instance will compete each other creating a giant mess.DAXDudehttps://www.blogger.com/profile/15490813518772863345noreply@blogger.com