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-02 : 06:31:12
|
| I have SQL SERVER with following configurationsOS - Win 2008(x64)Memory - 32 GBSQL Server 2008 Enterprise editionI have a database of size 130 GB on which i am running SSIS and SSRS.Whenever I run the SSIS the server memory utilisation goes almost 32 GB but CPU utilisation is normal like 20-25 %.I tried to check which process is taking high memory and I found that msmdsrv.exe was on top.I stopeed the SSIS package and still memory utilisation was almost same and it does not goes down.Can anyone please guide me to troubleshoot the issue and what should i do to figure out the root cause?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
High memory utilization