2 sql server instances on Same machine

  • How to determine and adjust worker thread and memory configuration for 2 sql server instances running on same physical server?

  • I would leave the worker thread setting alone for now.

    If both instances are the same, set max memory on each server = (TotalMemory - (OS & xtraSvcs memory)) / 2

    If not then adjust the ratios appropriately.

    The probability of survival is inversely proportional to the angle of arrival.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply