Consolidating databases sql server
In recent years, the shift towards server consolidation and virtualization has gained pace, and in the years ahead, the idea of a dedicated, non virtualized server may seem quite odd.
From a SQL Server perspective, this has a number of important ramifications.
There are also a number of tables where Indexes are not present. I assume you mean the numbers for PLE are low, meaning a sql server page is not staying in memory very long.
If you think adding indexes would help, you should run this idea by the vendor first to make sure that they don't have some indexes they advise you add which they have already tested. Also, I ran the sp_blitzindex today and it came up with a number of suggestions where number of indexes are missing.
Yes, you would need to know how long the systems will be in place and if the disks can be expanded at a future date.
If you are only worried about disk capacity, assuming you know your avg.daily growth rate using a method of your choosing; the numbers for 3 months down the line can be calculated using: Where, x is a fraction indicating how much free space you want to have in your DB when you start planning for expansion.
As computing power increases and virtualization software improves, the march towards fewer, more powerful servers hosting multiple virtual servers and/or more database instances is an industry trend that shows no sign of stopping.Finally, for a shared environment like this, you probably want to use Enterprise Edition with Resource Governor so you can prevent the "noisy neighbor" problem.If I understand your requirements correctly, you have multiple SQL Server instances that are currently hosting LANDesk databases and your firm wants to consolidate these instances into a single SQL Server Cluster instance with a database per region?The disk data will simply be cumulative, whilst the CPU and memory data will need to evaluated.
In a consolidated environment, you'll probably use a little less CPU and memory.The real question for a DBA is often how to consolidate/virtualize rather that whether to consolidate/virtualize.