2
votes
1answer
2k views

SQL Server 2008 R2 - RAM = 128GB, PageFile = 192GB?

Is there a definitive guide for PageFile size on the latest 64-bit servers with large amounts of RAM? I've seen conflicting recommendations, and am wondering if the latest releases have changed the ...
0
votes
1answer
458 views

How much to increase page file value for SQL Server 2008 R2 Full Text Search Engine

SQL Server 2008 R2 Full-text search engine (FTS) is taking up too much resource (I/O & Memory) in my production server. (migrated from SQL server 2005). I have been reading up on SQL Server FTS ...