Where can I find advantages of Multiple Instances on a single Server.
Instances are fairly well isolated from one another. They can run under different service accounts, store data by default on separate disks, etc. In 30 second of looking through BOL I couldn't find a good summary description of instances but I bet it's in there somewhere. Do you have a more specific question or are you looking for general info? Are you asking about the SQL Server Engine in particular, or other components?
Paul
|||On intranet we are having some applications, in particular time everyday we are uploading bulk data onto a database. Due to this other applications are unable to access the database server OR it is very slow. In this case is there any advantage of using Multiple Instances ?
Here databases are sharing some of the data each other.
|||I'm moving this thread to the database engine forum for expert comment. Are the bulk load and other applications accessing the same table or different tables? Is the bulk load consuming a large percentage of CPU or disk throughput?
Paul
|||Use local snapshot replication (pull).
No comments:
Post a Comment