Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

memory leak advice needed Expand / Collapse
Author
Message
Posted Friday, March 1, 2013 9:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 7, 2014 4:56 AM
Points: 44, Visits: 144
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)
Post #1425590
Posted Friday, March 1, 2013 9:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
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
Post #1425594
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse