We have many MS-SQLServer 2005 instances (32 bit & 64 bit) running on many Microsoft Windows systems (32 bit & 64 bit).
Our management has decided to centralize all SQLServer instances on a Microsoft Windows Cluster 2003 R2 (64 bit) and one or two Microsoft Windows 2003 R2 (64 bit) standalone servers.
- Is it possible to have a clue on the memory usage per user database? Via Windows Task Manager, I can see the consumption of the SQLServer instance, but my instance contains for example 15 user databases.
- Is it true that I can have not more then 5 instances per Windows Server?
Thanks in advance,