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 |
|
AgaK
Yak Posting Veteran
86 Posts |
 Posted - 2010-03-22 : 13:08:35
|
| HiI have SQL Server 2005 SP2 installed on a server with SSAS. The server has 24GB of RAM. The CPU usage is low and Memory as well (highest Mem Usage msmdsrv 636MB and sqlserv 145MB) however the Page File Usage is 22GB. Any ideas what can cause that situation?Thank youAK |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AgaK
Yak Posting Veteran
86 Posts |
Posted - 2010-03-22 : 13:28:48
|
| The initial size is 4096 MB (D drive) and 2046 MB (C drive). Does sounds reasonable, doesn't it? Thank you, AK |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Page File Udage High