umm .. that's not always the case with /3gb switch. I've found that with the 3gb switch enabled there can sometimes be problems with xml operations. In this instance only...

My comment was directed at your vendor < grin > 

It's quite possible to use active - active clustering to get performance improvement ( but not load balancing ) as...

In general terms from the sql point of view moving databases about is no different on a cluster to a single server - however - does your new cluster need...

Put it this way if he sold cars I definitely wouldn't buy one from him!!

Perhaps he intended to suggest you split the databases across servers/nodes which is a different matter...

All the cpus will be used under normal load, or should be, you do need enough work to make use of the cpus mind. If you're using enterprise sql then...

These are caused by procs called without qualified names e.g  exec myproc  instead of exec  dbo.myproc  OR/AND having user stored procs starting sp_

I suffer both and it can and does...

With so few disks there's not a real way to configure an effective setup.

Much as I hate raid 5 I'd have to agree with your boss, but only as...

You should be aware that the ability to use multiple processors is more limited in std edition.

You might want to monitor processes to see what is using cpu - I...

I think there are a number of possible scenarios to follow which depend on a number of factors, it's really a matter of how you personally decide to approach this.

I...

The sql resouce kit comes with a system table map which will help you.

The other question is why? surely you would have control over object creation on a server ?

It's never easy with this type of problem .. however, you might want to look at some of these:-

Disk counters, especially response time and queues

Processes, I've found things such as...

I have workgroups at home and I've used them on sql servers sat in a dmz.  I always had the users/logins as administrators so cmdshell worked.  You should be able...

It will update stats on the indexed columns but not any explicit or auto-generated stats on non-indexed columns.

If you want to be sure of getting those updated issue a sp_updatestats ...

can you be more precise about what you are doing and what you want to track?

Yeah I think the problem I run into is that the SANs I have sql servers connected to have many servers attached, and the physical raids are carved so that...