no more than 4gb of ram and 4 procs if I'm not mistaken. Enterprise also offers higher end clustering support up to 4 machines and indexed views other than that...

looks like someone comes from the novel world 😉 Srini, let us know what you end up going with. Replication can be stable if setup correctly.

Good luck,

Wes

you can use sql standard on a san. if you don't need the extra stuff that enterprise provides like large memory or more proc's then stick with standard.

Wes

Tom,

Are you running the raid 5 over raid 5 option on your hitachi unit?

Well, that's not a good thing. I usually don't say this but I use to work at Dell in the Enterprise space. At one point service use to be pretty...

If I remember correctly, you will need to shut down all sql and clustering services manually change the account they start under move the boxes to the new domain and...

One, Unisys will come out and setup the machine any way you want it. It comes pre-loaded with datacenter. If people are complaining about doing it all themselves they are...

Correct the hardware shows an additional CPU per hyperthreading enabled CPU. If you are having issues you can usually turn hyperthreading off in the bios of your server until you...

I personally don't have any experience with them but I would also investigate replication as it supports the two phase transaction to maintain ACID copliance on all tables that are...

Any of Dell's 4 way boxes are a good investment. I can tell you first hand support is pretty good and they generally don't quibble over getting the box fixed....

the option (maxdop 1) is a fix for that issue and the can't spawn enough threads problem we have run into from time to time. I would look at profiler...

Yep. If you can do a SCSI cluster SAN is a cake walk. Setup quarum drive space for system dbs on the san and setup your groups and drive dependencies...

I would consider your apps cross functional in nature. If you are duplicating data accross apps you risk corruption and consistansy issues that can really cause some grief. If all...

I personally would worry about database consistancy issues. I would setup one reader and one writer. Writer would have no indexes and replicate all changes to the reader that way...

you need to check the account SQL is set to run under and the cluster account. It doesn't have enough permissions to start the server.

Wes