Kristy Lanter (10/27/2009)
Yeah, but what I was wondering was if it was really needed. Back a few years ago I read someplace it wasn't necessary to set it up but I'm doing it anyhow. Just recently experiencing I/O messages. Thanks.
Personally, I always enable it. You don't say what the I/O messages say...?
This article was about lock pages in memory on Standard Edition and the message that can appear to say that a significant part of SQL Server's allocated memory has been paged out. Is that what you're seeing?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi