Back In October, we wrote a post regarding the Event ID 333 Errors and how to troubleshoot them. At the end of that post, we mentioned the "Lock Pages in Memory" user right. One of the things we mentioned was that if you have an x64 system, you should not enable this right. Over the last few months, we have seen a number of cases where x64 SQL servers have been exhibiting performance issues - either within the Operating System or within SQL. It's not always the Event ID 333 messages that we've been seeing either, so today we're going to give you the lowdown on Lock Pages in Memory - and whether or not you really need it. So, let's get started ...
|