| Author |
Topic |
|
california6
Starting Member
38 Posts |
 Posted - 2008-08-14 : 18:38:41
|
| On my production SQL Server - i see a paging file of 18 GB used. But my initial paging file is set to 2 GB minimum and a max file size is of 4 GB. i was wondering, how can it grow to 18 GB? Is task manager not a relevant source to rely on?Any reason why my paging file is so large on SQL Server? The server is with 22 GB memory and 18 is allocated to SQL Server. Additionally i could see 2 GB of memory available on the box as well.any suggestions?Cali |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-14 : 18:40:02
|
| What edition of SQL server? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-14 : 18:40:03
|
| What edition of SQL server? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-14 : 19:07:56
|
| SoDeep: It's SQL 2005-Enterprise edition.tkizer: My question was - why do i see high paging file on my task manager when initially i have only allocated 2 to 4 GB as max. For sure, I am not confusing myself with swap and memory. any suggestions as to why i see this?Cali |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-14 : 19:11:50
|
| Have you tried viewing the page file size in Performance Monitor so that you can compare the number with what Task Manager is showing?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-14 : 19:59:46
|
| I checked with the performance monitor and see the following values:Paging file %Usage - C:\Pagefile.sys value is 17%Paging file %usage Peak - C:\pagefile.sys value is like 32%does these values means, the file %usage is 17% and %usage peak was 32%? I.E 17% of the 4 GB page file?Cali |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-14 : 23:25:15
|
| Sounds it set to system managed size, and 18gb page file is normal on server with 22gb memory. |
|
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-15 : 01:25:06
|
| one more thing to mention: I noticed the moment i remove the sql service account from lock memory pages policy - the paging file is dropped to 3 GB. dont know how they are connected? any suggestions?Cali |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-16 : 18:44:11
|
| That may affect sql performance. |
|
|
|
|
Paging file