Having a problem where my SQL Server 2012 SP2 Enterprise server says that most of SQL Server's memory has been paged out to disk but there's over 100GB free (of 256GB).
From there system performance drops to the point where it starts dropping network connections.
Looking in Resource Monitor I see a large amount of Modified memory and lots of disk activity to the page file.
I just don't understand why it's paging if there is a lot of free memory available.
I've tried the Lock Pages in Memory setting which didn't seem to work (about to try again).
Googling the problem only seems to return hits talking about Lock Pages in Memory or situations where there actually was a memory pressure problem.
Any help or suggestions would be appreciated. Thank you!