Capacity Planning
Capacity planning allows you to support growth with the appropriate technical infrastructure while giving finance visibility into investment needs.
Capacity planning is much more than knowing how much disk space you need. At Pythian, we develop accurate and efficient capacity plans by taking into consideration IO subsystems, network architecture, servers and DB architecture. We understand the dependencies and the need to view all the parts as a cohesive unit.
Benefits: Capacity Planning
- Peace of mind in knowing the lifespan of your infrastructure
- More accurate budget planning
- Cost savings - downtime is expensive
- Efficiency - you won’t buy hardware you don’t need
Services Provided under Capacity Planning
- Forecasting IO subsystem, CPU, memory usage
- Space usage (disk, tablespace)
Database Features
We have extensive experience in Oracle, Oracle Apps, MySQL and SQL Server.
When it comes to capacity planning, we know how to get the most from the features such as:
- Oracle: RAC, ASM, Grid Control, SGA/PGA usage, CPU usage.
- Oracle Apps: Concurrent job processing analysis, space analysis (Apps tablespaces), analysis of CPU/memory/swap space on application and database servers.
- MySQL: Mysqldumpslow; mysqlreport; mk-query-digest; monitoring with internal monitoring tools, Nagios, Cacti, Ganglia, periodic capacity audits to proactively find bottlenecks and recommend improvements, data archiving, table defragmentation, data warehousing.
- SQL Server: Database growth, usage analysis, login/logouts auditing, clustering, multi-instance, replication, database mirroring, database snapshots
