We have a win 2000 server with SQL Server 2K.
Over the weekend, they added 4GB of RAM to the existing 4GB.
They did not enable AWE, nor /PAE /3GB. THat is planned for after an upgrade to 2003, this was in theory just to get the hardware stuff out of the way.
When I left on friday, there was 3.5GB on our data drive, which is typical although much too low. (we are also adding space to the SAN next weekend)
The problem is, when I came in this morning, there was only 9MB left on our data drive. I did request that they run update useage on the main database, but that would only help matters, wouldn't it?
Could the disk space problem be due to the memory addition?
Physical memory is paged in and out from and to the paging file. If you system is setup so the paging file size is system managed, the paging file size will be ~150-300% of physical ram. Adding 4 GB of RAM would have increased the paging file size by quite a bit, hence the change in free disk space.|||IMO, a system with 8GB of memory should disable paging. That is not a widely-shared point of view, however. I disable paging on my 2GB dev. system.
No comments:
Post a Comment