A customer has experienced with their production SQL Servers that query traffic from the Analytics engine seems to build up large amounts of memory usage. This has created a performance issue in their PROD. Is there a way that they can schedule queries better or anyway to reduce this memory and log build up?

Their Environmental Structure (Site Admin is pointing to multiple Farms):

SQL for SP 2010 = Active Passive SQL 2008 cluster
SQL for SP 2013 = Active Passive SQL 2012 cluster
SharePoint 2010 Enterprise Farm 1 = 2 Load Balanced WFE, 1 Central Admin App Server
SharePoint 2010 Enterprise Farm 2 = 3 Load Balanced WFE, 1 Central Admin, 1 App Server
SharePoint 2013 Enterprise Farm 1 = 2 Load Balanced WFE, 1 Central Admin App Server
SharePoint Project Server 2010 Enterprise Farm 1 = 2 Load Balanced WFE, 1 Central Admin App Server

Thanks! Alessandro