prithvi.m (9/13/2011)

---

Thanks Shifty1981..I did go through this thread and multiple other's to see if this process makes sense. Arguably, Max memory should be the upper limit. No matter how much...

Take a look at my first post a few post up. Unfortunately things are not as clean cut as your conclusion. If you adjust the max memory setting, the values...

Where do you find that log info?

still not convinced "significantly" always means there's pressure though. a new server staged for growth that is growing may not need all the ram allocated so it won't take it....

Was reading up on this and thought I'd add some insight. We just spun up a new SQL server that will grow immensely, but right now it's barely touched. We...

If you have the space and the IO, then there's potentially no need to be frugal. But to get the best out of the system, I'd set up perfmon scheduling...

Turns out we did some io analysis and our tempdb is barely touched compared to our other indexes, so we actually ended up not giving it it's own spindles. I...

Ok then. Later on when it goes to write it, will it update each file in parallel or sequentially? And how much later on?

Basically trying to determine if the drop...

I'm confused. Doesn't the added row for the key of each index get added physically to the index file or removed if that's the case?

sean.massey (2/16/2011)

---

You may want to check out these DMV queries to help see where you have a bottleneck but with low page life expectency and paging I'd be thinking memory.

Thanks, but that's just a forum post telling someone what to look at/for. I don't see a basis for those recommendations. Ram is not cheap when you're near 100GB of...

Thanks Sean. Below are the stats during our peak usage. When you say "are you seeing paging" what do you mean? I ask because I've read articles that say look...

Thanks. Have...

Thanks, but I need some sort of article or technical explanation of why it's important to have roughly 20% of memory available.

So there is some inherent benefit to a log or database filling up the space on a non-boot drive instead of the boot drive? Or perhaps I should say 'less...