Major issue for me, so hoping someone may have seen this behaviour before?!?

Anyone?

I'm not sure memory is the issue now, but I did just adjust the Max Server memory.

I think it seemed to be the B server was hogging all the...

More questions on this.....

Would a query that sometimes takes 10 minutes, then other times takes 45 minutes actually need tuning? Surely that is pure server performance? Or is it something...

Follow up question -

For performance on these 2 virtualised servers would I be best served getting my network guys to force A and B to have a 50/50 share of...

Both of those options are great. Thanks guys

😀 SOLVED IT AT LAST.

Step 1 checks for a value. If the value is NOT met it sets a Global Variable @DISABLE = 1 else @DISABLE = 0.

Step 2 is...

That was my plan, so I now need to find out how to set the package execution to success. I can set the step to be successful, but ultimately the...

The main aim for us with this is protecting our VPN into the building. If the line goes down (and it has before) we need the external server to take...

Thanks for the link. I've written Log Shipping out. Gonna go with Transactional or Merge replication.

Can anyone think of a reason to NOT use Merge?

And how would you resync if...

Ok lets go with 2 scenarios -

1) Transactional Replication is used to keep B up to date. The line between our front end and A goes down so we start...

What are the packages using? Data Flow with ADO or OLEDB? Loading from what source?

If you are taking regular log backups then I wouldn't truncate the log each night...

What other processes are occuring? Reindexing?

Ok so then once you have tuned it as best you can (all indexes are in, the 100% in execution plan where it should be and so forth) and it...

Actually it may be 2 dual cores for what its worth.

Their is 8gb memory TOTAL shared between the 2 machines. Both machines are on the same host.