Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

memory leak advice needed Expand / Collapse
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: Thursday, August 27, 2015 3:32 AM
Points: 48, Visits: 154
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


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

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

Post #1425594
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse