August 14, 2009 at 2:38 am
Hi
Our reporting server runs SQL 2008 and SQL 2008 Reporting Services. The server itself runs Windows server 2007 SP2, it has a Intel Xeon X3220 @ 2.4 Ghz (4 cpu's), and has 4Gb of memory.
When looking at the performance tab in task manager the Memory utilization is constantly sitting at 3.82Gb. When looking at the processes, the 'ReportingServicesService.exe' is using the most memory and 2nd is the sqlservr.exe process. When i stop the sqlserver service the memory usage goes down considerably.
SQL itself is configured to use Min 0 and Max 3Gb with AWE enabled (64-bit system). There is not much activity itself on the server, my question is why is sql using so much memory.....
August 14, 2009 at 6:02 am
See when you are setting the max memory setting the service will pick the max mem. at the time of startup, no matters whether it needs it or not.
whereas if you set SQL Server to dynamically manage mem. then the usage will be acc. to the workload on the server.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
August 14, 2009 at 7:18 am
ok, thanks, but in SQL 2008 there is no option to configure the memory to be allocated dynamically.
August 14, 2009 at 7:48 am
AWE enabled (64-bit system)?? AWE, /PAE, 3GB and /USERVA are only for 32 bit. Correct me if I am wrong.
-LK
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply