I don't say you should remove it. I just said, that windows is perfectly working without one. And I said that you shouldn't calculate it based on RAM size.

Magic Man (9/1/2010)

---

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

Hi,

Just the numbers tell nothing, it just depends on the system usage. To be honest: I never care about context switches.

You should rather have a look at your buffer...

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

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

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

Hi Andrew,

Thanks for your reply. One of the hotfixes modified something with the "LocalSystem" Account, I guess that's why it doesn't work any more. We are using Mixed Mode...

Thanks for all your input.

I indeed use the DB Mail feature using the sp_send methods in sql 2005, so I think It's really handled asynchronously.

Lock conditions don't impact me -...

Hi,

thanks for your idea, but that doesn't work for me.

I don't want to pull for new entries regularly, I want to get them immediately as they arise. I...

Ok, I got it:

- two parts:

1: a trigger that fires on update/insert. At the end it disables itself

2: a scheduled job, running every 1 hour and enabling the...