high memory usage on mssql2012

pehtsim

high Memory usage on server2008r2 when running mssql2012. the memory usage around 90-95%.
how to solve the issue?

flashang

to diagnostic the problem,
try to setup a similar server (may be vm)
same version windows server, same version mssql
use the same database.

check your task manager for mssql process memory usage,

you may also check your database size, shrink Your Database and Log File.

pehtsim

it is new. just install mssql2012(BI version) into server2008r2. the database is empty.
The task manager show the memory usage around 10GB+-. total is 16Gb on server. i have set the max memory to 10GB.
after i restart the mssql services, it drop to around 5 GB, few minute later the memory will growing up.

thanks.

gkheng2003

memory not release?

tried sql profiler?

flashang

You should check the system requirements before use it...



Hardware and Software Requirements for
Analysis Services Server in SharePoint Mode (SQL Server 2012 SP1)

http://msdn.microsoft.com/en-us/library/jj590636.aspx

(Minimum) 8 gigabytes of RAM
(Recommended) 64 gigabytes of RAM

=============================
Hardware and Software Requirements
(PowerPivot for SharePoint and
Reporting Services in SharePoint Mode)

http://msdn.microsoft.com/en-us/library/ee210640.aspx

Component	Minimum	Recommended
Processor	64-bit dual-core processor, 3 GHz	16 Cores
RAM	8 gigabytes of RAM [1]	128 gigabytes of RAM
Storage	80 gigabyte storage	80 gigabytes or more

                                      [1] 8 gigabytes of memory is sufficient for a single server test or development environment but
more than 8 gigabytes of memory is recommended for a production environment.


=============================
Hardware and Software Requirements for
Installing SQL Server 2012

http://msdn.microsoft.com/en-us/library/ms143506.aspx

Memory[1]
Minimum:
Express Editions: 512 MB
All other editions: 1 GB

Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and
should be increased as database size increases
to ensure optimal performance.

pehtsim

the server spec :
window server 2008r2
intel xeon CPU E5640 @2.67 2 processor
memory: 16GB
64 bit OS

the server meet the min requirement. but always high memory usage.

thanks.

fivefooteleven

unless you really need the Self-Service BI and Advanced Corporate BI. Otherwise just use the Standard Edition, which the memory reserved and loaded is far more smaller for Standard Edition.