For such huge RAM requirements then agreed, you don't need nor want a full dump, so set the size to that required by the dump but then leave it as...

antonio.collins (8/23/2010)[hr

on a small dev/test server, a large pagefile may be necessary, but a production db server shouldn't have a higher peak commit than its accesible physical ram. in...

ab.sqlservercentral (8/23/2010)

---

Magic Man (8/20/2010)

---

ab.sqlservercentral (8/20/2010)

---

Magic Man (8/19/2010)

---

Why set a size and constrain the memory manager in the first place?. Set the pagefile as system managed, it will be set to...

ab.sqlservercentral (8/20/2010)

---

Magic Man (8/19/2010)

---

Why set a size and constrain the memory manager in the first place?. Set the pagefile as system managed, it will be set to an initial size...

Why set a size and constrain the memory manager in the first place?. Set the pagefile as system managed, it will be set to an initial size and can grow...