Solved

vmware sizing and capacity planning

Posted on 2011-09-30
3
808 Views
Last Modified: 2012-05-12

We need some help with some capacity planning for our SQL Server environment.
it was attempted to do some capacity planning twice recently, but we quickly outgrew the solution we implemented.
I am wanting to make the right choices this time around.  
What tool could I use to help with this plan? capacity planning, and sizing

Here’s what I currently know about the environment:
•      10 virtual SQL Server instances (shame on me, I forgot to ask what version of SQL Server!)
•      1 virtual instance running SSAS
•      3-4 of the instances are mission-critical
•      EMC SAN
•      2 host VMware cluster
•      There are other servers on the VMware cluster, but I don’t know exactly what or how many
•      He doesn’t know exactly where backups are going

Challenges we’ve experienced recently:
•      Rapidly outgrowing recent capacity expansions
•      Have lots of disk contention, but not sure how much of that is due to memory limitations
•      Have limited RAM available
•      The set up the reporting SSRS environment, but undersized it and rapidly outgrew the environment
•      set up the SSAS environment and now the cubes are rapidly devouring that environment
•      would benefit from advice on how to use the SAN more efficiently
•      help analyzing the pro’s/con’s of using some physical db servers
•      What are other info you need in order to help me with the assessment and capacity planning recommendations
0
Comment
Question by:Indyrb
3 Comments
 
LVL 16

Assisted Solution

by:danm66
danm66 earned 250 total points
ID: 36901371
I would be most concerned with the disk contention you mention.  You can fix the memory and processor utilization issues fairly easily but exceeding your SAN's abilities can be the more expensive problem to overcome

Are you using perfmon to get your disk performance or the VMware performance charts?  check the performance charts for disk performance and see what kind of latencies you are getting.  If you are using an array of SATA disks without a whole bunch of cache; you may have outstripped it's ability to keep up
0
 
LVL 18

Accepted Solution

by:
BigSchmuh earned 250 total points
ID: 36901936
Can't you evaluate, based on thr current VM, your cpu and io needs ?

Most difficult capacity planning comes from cases where we have no figures. Yours should be different.
0
 

Author Comment

by:Indyrb
ID: 37076841
What do you use to do capacity planning, sizing, and performance monitoring
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question