Congratulation Jeff. Thanks for your articles as well.

A great article and constructive discussion!

I do learn a lot of brilliant methods to delete very large table, but not just simply to make a where clause and wait for...

Hi Steve,

With using a iPad, we can monitor several SQL server instances\databases healthiness in just 1 screen, when we are waiting for bus in the street, queuing for meals.

What is...

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 an...

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 and...

ab.sqlservercentral (8/18/2010)

---

Guys,

those pagefile discussion drives me crazy. First, most of the posts are off-topic. The discussion is about MEMORY DUMPS, not about paging file calculation. Second, most people don't...

manu.tiwari (8/18/2010)

---

Hi Stanley,

A very informative and detailed article. Just one point to add to keep the system running efficiently we keep pagefile size 1.5 times of RAM in most of...

James Stephens (8/18/2010)

---

This is good information to know. I hate to get negative on MS but I have to:

Why should a professional server administrator need to resort...

YeshuaAgapao (8/18/2010)

---

I use the /PAE boot.ini switch on a 32-bit windows XP workstation with 4GB of RAM. It not only lets me use 3.25GB of that RAM, it lets...

SanjayAttray (8/18/2010)

---

I had to change it to 6 GB from default size of 2 GB on a production server few days back. Also, by default pagefile.sys is located in...

ab.sqlservercentral (8/18/2010)

---

Hi,

Nice article, but it's worth to mention that it won't work with different paging files spread around different partitions. Unless you have enough free space on c:\ the...

ta.bu.shi.da.yu (8/18/2010)

---

I know where this is going. If it's a...

They are 32 bits.

Jeff Moden (6/22/2010)

---

stephen.burke (6/14/2010)

---

MAPS from Microsoft is the best way to record all such info in a database for you, plus a ncie report and excel spreadsheet.

In order to produce...

Thanks, will try.