Hi Koen, both are False.

Regards,

Gordon.

I've set different Max Memory values for the different instances according to what they are currently 'using'. This varies from less than 1GB up to 43GB for the most memory...

Many thanks indeed for the useful responses and links. And apologies for taking so long to reply. Put my back out within a day of posting so have been recuperating...

Seem to have solved this one myself and, to save anyone else going through the same unnecessary pain of researching on Google, asking question in Forums such as this and...

Thanks for the response gSquared. I have located an MS 64-bit driver - sqljdbc_xa.dll. Unfortunately my 'colleagues' on the Oracle side aren't prepared to alter their processes to accomodate calls...

Thanks for the reply, Craig. Unfortunately I need to be able to measure performance down to database level which I don't think PerfMon will do.

Regards,

Gordon.

Many thanks indeed for all the sound advice. I will be putting pretty much all of it into practice.

Regards,

YaHozna.

Thanks for the feedback, John. Are SELECT statements actually logged though, as they are not required for any recovery? That would perhaps explain why they show up in sys.dm_tran_active_transactions but...

Hi Mark, many thanks for your input. I would be interested to learn what criteria you used when deciding to create additional instances. Were these instances different versions of SQL...

Hi Lynn and thanks for the response. Yes, having an Active/Active configurations is certainly a possibility however it also means extra Windows Server and SQL Server licenses. Plus, as you...

Hi SSC Journeyman. Not sure how that would work. Is this not an Active/Active configuration with the instance on one node moving to the other when there is a fail-over?...

Thanks to everyone who has replied to my post thus far. I'll reply generally rather than to individual posts if I may.

It would seem that the general consensus is that...

Many thanks to those who have taken the time to reply with some very useful input. And apologies for having taken so long to reply - am on a course...

Michael, many thanks for the reponse. Is there a way to get more information as to what caused the login failure than from the error log, which doesn't really give...

Thanks for the input Phill. You may well be right about ditching the MPs. I'll give it some thought.

Regards,

YaHozna.