there are two ways to configure 4GB of ram , 3gb switch with dynamic memory management

/PAE enable awe set fixed memory to say 3.25gb

I've run boxes in both configs. Note...

I'd check the network card settings, speed and duplex/half duplex.

are the o/s and sql editions identical, cpu same + speed. memory same, server configs the same?

most of the counters you mention I'd probably say were fine, a free page is an unused page and although it's good to have them why concern yourself that most...

and that's the point in difference, it's collecting all that data to get meaningful results ( maybe ). I have to admit that I have other tools to show me...

I don't have too many problems with ms transactional replication, there's certainly some interesting things to be aware of. but I've used it for several years without tooo many problems.

I'd...

let's hope that every other country doesn't follow suit and start changing this every year!! Has anyone a link which shows what "benefits" are supposed to come from changing the...

using the various dbcc commands can help but to be honest listing the top 20 objects for a number of 600+ table databases isn't truthfully going to be too much...

I did some work on optimising a customised message passing database utilising queues which wasn't working.  as far as I can remember the main issue was removing the old entries...

I'm not convinced you can do what you're trying to do in that manner. Tempdb is generally the work space for sql server for sorts, groups bys, spools, distincts and...

time - uptime ?

It might be security / service account permissions. I can't think of anything that a cluster changes, unless it's at a different service pack level , o/s.

clustering has no effect on moving databases about. Check out KB224071  for moving system databases.

the scenario sounds very unlikely, however adding memory is only part of the story, how have you configured this memory and which version of o/s and sql server are you...

if no-one posts then I'll run an install on sunday on a test server - think you need code page 850 , sorry not really sure I usually install windows...

with regard to what?  The main pools of memory used are the proc cache and the data cache. You can view the proc cache and could probably figure out what...