MysteryJimbo (1/2/2014)
Here's a couple of articles for you to look into it.http://bradmcgehee.com/2011/03/10/do-you-enable-lock-pages-in-memory/[/url]
https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/[/url]
In my case, the only reason this option wasn't enabled was based on a MS article at the time saying it was no longer required. As it turns out it was.
FWIW the SQLCAT team now recommend this be enabled as standard. If you do need to enable this setting, ensure you set you MAX Server memory to allow for enough OS space and any other over heads the system has.
Lock Pages is a good start.
If this truly impacts only Sales Orders in your ERP, has anything come up in a trace when you run a query?
And any unusual disk activity at this time?
Restarting clearing up the issue would tend to be a memory issue.
Only SQL on the machine, no SSAS, correct?