Capacity planning is about more than just knowing how much
space you need for database files. You have to understand the workload
and what it requires in terms of CPU, memory, and disk resources. To do
this, you need data…which means you need capture baselines. If you want
to do intelligent, targeted capacity planning, then you need to collect the
appropriate data…otherwise you’re just guessing.
There are many things to consider when capacity planning
for SQL Server. Storage and disk capacity are apparent, but when you want to
right-size your database(s) for a new SQL implementation or migration, there is
a lot more to think about than space.
Of course, you need to consider sizing and future growth.
Also, we also have to consider design, configuration, and other essential
resources to ensure your new SQL Server is performing optimally.
No comments:
Post a Comment