Lock Pages was enabled by default for the account the SQL is running on 🙁
I've also found the Dynamic Cache Service but nothing changed, SQL server still uses 20-200Mb memory and pages every few mins thou there are more than 4G free RAM
You have been going back and forth for days on this issue now. Way past time to get a performance tuning professional on board to help you find a solution.
Best, Kevin G. Boles SQL Server Consultant SQL MVP 2007-2012 TheSQLGuru on googles mail service
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply