I am running sql server 2000 on a windows 2000 server computer. The computer has 2gb ram, dual processors, raid 5 array with 4 physical disks.
Before installing sql I had the pagefiles set up as:
c: drive - min 2mb, max 2mb
d: drive - min 1500mb, max 3020 mb
After installing sql and having performance problems, I noticed that the pagefile on the c: drive was running at 100% all the time. I increased sizes of the c: drive to min 200mb, max 500mb. (I have about 1.5 gb of free space on the c: drive)
This improved performance, but the pagefile on the c: drive continues to be highly used, while the pagefile on the d: drive is showing about 4% utilization.
Is it possible to either eliminate the pagefile on the c: drive or force sql to use the pagefile on the d: drive? (or if you have other suggestions they will be welcome!)
Before installing sql I had the pagefiles set up as:
c: drive - min 2mb, max 2mb
d: drive - min 1500mb, max 3020 mb
After installing sql and having performance problems, I noticed that the pagefile on the c: drive was running at 100% all the time. I increased sizes of the c: drive to min 200mb, max 500mb. (I have about 1.5 gb of free space on the c: drive)
This improved performance, but the pagefile on the c: drive continues to be highly used, while the pagefile on the d: drive is showing about 4% utilization.
Is it possible to either eliminate the pagefile on the c: drive or force sql to use the pagefile on the d: drive? (or if you have other suggestions they will be welcome!)
