Can you explain a bit more what you mean by a 'multi server instance'..?
/Kenneth
|||Each host machine (server) can host (virtually) any number of SQL Server instances. Each instance has its own master, model and other support databases along with the user databases. Each instance consumes RAM and CPU cycles and while many of the SQL Server code DLLs are shared, there are instance memory allocations that cannot be shared. Each instance has its own cache to hold procedures, query plans and data--these cannot be shared. That is, each SQL Server instance competes with all other instances, the OS and all other running processes for RAM, disk and CPU resources. Does this tell you something about performance? It should.
See chapter 2 of my book "Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)" for more details.
No comments:
Post a Comment