Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

vmware sizing and capacity planning

Posted on 2011-09-30
3
Medium Priority
?
838 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:Danny McDaniel
Danny McDaniel earned 1000 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 1000 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
 
LVL 5

Author Comment

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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
Article by: evilrix
Looking for a way to avoid searching through large data sets for data that doesn't exist? A Bloom Filter might be what you need. This data structure is a probabilistic filter that allows you to avoid unnecessary searches when you know the data defin…
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…

886 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