Post reply

Multiple SQL Server instnaces on single server or multiple servers

  • October 3, 2019 at 10:09 am

    #3685607

    Hi,

    I have to migrated load to different environment. There are multiple instances. What is the best approach migrating multiple instnaces on single server or sinlge instance on single server.

    Thanks

    Brijesh

  • October 3, 2019 at 10:42 am

    #3685610

    This really depends on your requirements (you haven't really given us enough to work on)

    I would go for a single instance, especially if you are using linked servers in any way - at least you can just do cross database queries rather than using linked servers

    multiple instances can help if your clients require a dedicated server, but it comes with the cost of having to manage the memory and cpu configuration very carefully. performance tuning can be a bit of an issue too... especially where each instance of SQL is fighting for disk resources.... you can't see in activity monitor why your disks are running slow without going through each instance.

    MVDBA

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

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