Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sks198117
Starting Member
46 Posts |
 Posted - 2010-09-13 : 08:34:02
|
| Hi,I have a server with following configuratios==============================================Microsoft SQL Server 2008 (SP1) - 10.0.2714.0 (X64) May 14 2009 16:08:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) OS Name: Microsoftr Windows Serverr 2008 Enterprise OS Version: 6.0.6002 Service Pack 2 Build 6002OS Manufacturer: Microsoft CorporationOS Configuration: Member ServerOS Build Type: Multiprocessor FreeProcessor(s): 4 Processor(s) Installed. [01]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2400 Mhz [02]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2400 Mhz [03]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2400 Mhz [04]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2400 MhzTotal Physical Memory: 32,764 MB===================================================I am not able to get the best performance by server as expected and I can see the high memory utilization on server.Can anyone please suggest me what configurations I should change for better performance?Presently SQL server is running under default config setting as installed.Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sks198117
Starting Member
46 Posts |
Posted - 2010-09-13 : 11:17:50
|
| Ok Tara..Thanks for your reply..Here its more explanationI have a DB with size approx 150 GB...DB is being used for analysis servicesWhenever I run the packages..memory utilization goes upto 31-32 GB(Almost 100%) and cause slow query..Moreever when packages executed successfully memory utilization deos not goes down.When I have checked the window processes "msmdsrv.exe" is on top process which takes high memory.here is the output for top 10 consumers of memory from Buffer Pooltype SPA Mem, Kb------------------------------------------------------------ --------------------OBJECTSTORE_LOCK_MANAGER 90008CACHESTORE_OBJCP 34800CACHESTORE_SQLCP 11872USERSTORE_SCHEMAMGR 5808CACHESTORE_PHDR 5672MEMORYCLERK_SQLGENERAL 5264MEMORYCLERK_SQLSTORENG 3728USERSTORE_DBMETADATA 2456USERSTORE_TOKENPERM 1688USERSTORE_OBJPERM 1496Hope this will help Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Memory configuration