memory leak advice needed

  • Guys I'm seeing a memory leak with SQL Server 2008 analysis services I am a newbie at analysis services. So with that said what would cause analysis services to start sucking down memory? The server is Windows 2008 R2 standard and it has 8 gigs of ram installed also the sql service pack level is listed below.

    Microsoft SQL Server 2008 (SP3) - 10.0.5775.0 (X64) Mar 8 2012 01:33:49 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)

  • What makes you think it is a memeory leak?

    SSAS will start to cache queries in order to improve the performance of the queries (this is good!). There are settings to control the memory & SSAS's ability to flush the cache

    http://duncansutcliffe.wordpress.com/2010/06/04/memory-settings-on-sql-server-and-analysis-services/

    The other thing I would say is that 8Gb is a modest amount of memory for SSAS if your cubes are big

    Mack

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply