March 1, 2013 at 9:37 am
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)
March 1, 2013 at 9:47 am
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