 
Overview
This service is with regard to configuring and maintaining physical storage
components of the data tier to meet requirements of capacity, throughput, and
performance. The key points of capacity planning are as follows:
-
Be familiar with your system's use of hardware resources
-
Maintain a tangible record of your system's performance over time
-
Use this information to plan for the future hardware needs or software projects
required
Capacity planning does not need to be a complicated process, but it does involve
meticulous work, requiring numeric precision and documented proof. The
complexity involved in capacity planning increases as the magnitude of the
system increases. Capacity planning becomes critical when expanding capacity is
an expensive endeavor.
Traditional capacity planning will tell you how much hardware you need to
support a specific load on the server (assuming that the application takes full
advantage of the hardware). As your system grows, you will have to do this
evaluative process more than once, and as you gain experience with it, you will
undoubtedly refine and enhance the process for your individual system. This is
going to depend on your maintaining a historic baseline record of your system.
Three things drive the type of hardware and configuration you need:
-
Performance required
-
Volume of usage
-
Application design (the data access methods)
Of these three, the last has the most influence. Essentially, you have two paths
to choose from:
-
Concentrate on designing the best data access methods for your application to
get the most out of your hardware, which results in higher cost for the short
term, or
-
Concentrate on the best configuration for your hardware to get the most out of
your application, which results in higher cost for the long term
SQLSquare Services & Approach
SQLSquare can put together a process that works for your environment using the
following techniques:
-
Establish Mechanisms to monitor your application’s usage of system resources
-
Evaluate the historic usage trends of the application
-
Observe bottlenecks. Extrapolate the future trends, evaluate anticipated
increase in users or data
-
Determine whether there are enough resources to handle needs for specified
future time period
-
Determine what changes are necessary
We help you plan for following resources and any additional resources that are
significant in your environment.
-
CPU Planning
-
Memory Planning
-
Disk Planning
-
Disk Storage Subsystem Planning & Management
-
Placement of Database & Log Files
-
Network Planning
Key Benefits
-
Understand the current capacity & usage of the systems
-
Prepare in advance to cope up with growing requirements of your organization in
timely fashion
-
Allocate your resources optimally - Invest only where and when required.
Contact SQLSquare today!
|
