Also the other person Bhuvnesh send this article:

http://msmvps.com/blogs/omar/archive/2007/09/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx

George, What do you think about it?

Thanks for the information. Is there any drawbacks of doing this on a production box?

My questions are:

How can i assign the 'lock pages in memory' right to the service account running SQL?

I'm running SQL 2005 Enterprise Edition on Windows Server 2003 x64 OS box...Why...

I went through my SQL logs. Once or twice a day, i am seeing the following message:

A significant part of sql server process memory has been paged out. This may...

Thanks for the reply. I will set the max memory limit.

Thank you very much for an excellent input. Well for reporting part of the application we are having another read only server and the database restored from the primary database backup...

I want to know how reliable is this product. Can I use this tool to make backup of the databases more than 200 GB in size. When I restore from...