dbTalk Databases Forums  

SQL Server 2005 AS -- Memory Issue

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SQL Server 2005 AS -- Memory Issue in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Abraham
 
Posts: n/a

Default SQL Server 2005 AS -- Memory Issue - 06-15-2006 , 04:55 PM






Using SQL Server 2005 Standard Edition 9.0.1399

My msmdsrv.exe is not releasing memory and not reusing it.
From Process explorer this is what I see .
when usage increases the Working Set of msmdsrv.exe increases along with
Private Bytes. When usage reduces Working set goes down but Private Bytes
remains the maximun used memory.
Later when usage again increases Working Set keep growing. this time Private
Bytes also grows .
For example msmdsrv.exe)

Working set went to 6 GB , Private Bytes also to 6GB. Task Manager shows 6
GB memory usage ( msmdsrv.exe = 6 gb)

Working set went to 2 GB , Private Bytes is still 6 GB. Total Task Manager
memory usage shows 6 GB memory usage ( msmdsrv.exe = 2 gb)

Working set went to 8 GB , Private Bytes is 6+8= 14 GB. Total Task Manager
memory usage shows 14 GB memory usage ( msmdsrv.exe = 6 gb)

In this case server starts paging for additional RAM requirement .
Not sure why msmdsrv.exe Private Byte show all these RAM.
Anybody faced this issue or got any idea/solution.
Any help is much appreciated.

Thanks
Binu



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.