ok - forget task manager and get process explorer - never understand why so many dba's look to task manager for memory usage - it doesn't get it right!

There are...

Well given a box with 4gb of ram if you want to play with the memory you can either enable the 3gb switch or enable awe and set sql server...

It's all about what you expect and need from your database - you wouldn't want any part of sql server to share with the o/s so you can only put...

I think the thing about index rebuilds etc. is what window do you have to do this. If you have a smallish database and a suitable window I'd probably go...

yup - you query msdb and create your own mail routine and message.

sorry you need to be more precise. which version/edition are we talking - what memory has your server - how is sql configured and finally how are you measuring memory...

Hmm - don't have experience with Itanium but I think set working set is much the same as lock pages in memory. The idea was to fix memory to stop...

I don't think so - sorry I'm beyond sp2 and I'd advise you to go to at least sp2 + cu5 or cu6 - there are some memory bugs in...

it all depends if you need the data to be available. This is a very general question that is difficult to answer. You have to get the business to tell...

please note that awe is available with 4gb of ram, you do not need more than 4gb to use it.

we're only talking x32 here. The real advice is to forget...

so x64 or x32? sp and cu level ?

we sort of had a similar thing with pdfs - went to x64 and the problem went away ( but the new...

hmm it's a bit of a vague question. technically this might happen - try updating stats with a full scan and see if that helps.

could be you need some better...

I actually thought xp_sendmail was still there but just needed enabling. I just checked my x64 boxes and yes it's there in surface area config, but disabled.

If you didn't know that an awe enabled sql server doesn't show memory in task manager you'd fail a job interview as a DBA Use master..sysperfinfo, or...

with clusters you should always work with the virtual sql server - you should not normally use the nodes.