All,
I will post in Q/A to give out points, but I need some eyes on this as soon as possible.
—-
Got a MS-SQL server with paging problems.
System info:
HP-DL380
2x Xeon 3.? GHz
3g RAM
SQL 7 sp4
NT 4 sp6
All drives are SCSI3 10K RPM.
Page file is on scratch drive
Temp DB is on separate scratch drive
Data is on raid 5.
SQL memory is set to dynamic.
Problem;
Dam thing is paging between 80/s and spiking to 1000+/s. Looking at processed etc. not overloaded server. Not virus. The queries and apps are bad, but not that bad. Databases are poorly optimized, some missing indexes etc., but again, just not that bad.
Looking, its SQL doing all the paging. I have seen too much memory going to SQL, and starving the OS. Watching the spikes, it seems like memory just not getting allocated. Tried setting static memory, and about the same result.
Any thoughts?
