I work at a school district and this involves a student information server where about 20 people attach using terminal services and about 150 teachers using web portals for grade input.
I have a virtual machine running Windows Server 2008 and SQL Server 2008. The CPU is spiking because a IIS worker process is writing huge amounts to page file instead of using RAM.
The server has 4 Xeons assigned to it and 16GB of RAM and again it's virtual. We find that if we recycle the pool for this site the CPU drops way down and levels out, but starts building up again... We can tell it to recycle the pool every 30 minutes, but wondering if teachers will lose data while they are entering grades when that recycle happens.
Is there anything anyone can recommend to make this server run smoother? A way to get that process to use RAM instead of the page file. Is the recycling the best option?
Thanks for any advice.