Ryan, take a look at the following link. I believe this will provide information your looking for to make a decision.
Remedy 9.0 benchmark report has some data where we compared physical SQL server to a VM. Essentially we saw similar performance and therefore using a VM for a small or medium type of environment as a database server should be okay. For production environment we recommend not to over-subscribe resources and map (1-1 mapping) one VCPU to one physical core. https://docs.bmc.com/docs/display/public/brid90/Mixed+workload+with+Microsoft+SQL+server+deployed+to+a+Virtual+Machine On Tue, Oct 20, 2015 at 10:07 AM, Ryan Nicosia <ryan.nicosia....@socom.mil> wrote: > I've looked through the 9.0 upgrade documentation and outside of some > basic sizing guidelines I'm not really finding what I'm looking for. > > I've also downloaded the worksheet that BMC put together for planning your > resource requirements for 9.0 install based on users, ticket throughput, > etc. > > What I am after are recommendations on a virtualized Microsoft SQL cluster > and what we should provide to our SQL team on how SQL should be provisioned > to support Remedy. In the past, we ran into several issues with DB > connectivity from ARS due to an unidentifiable issue with latency between > the cluster (veritas in this instance) and the storage array where the > database was actually housed. The only solution was to revert back to a > physical SQL server. > > We want to avoid this situation with our 9.0 upgrade by ensuring all of > the SQL requirements are provided up front. Unfortunately, it looks like > BMC documentation is kind of lacking in this regard. > > So, for anybody that has upgraded to 9.0 and has a large user base and > large DB with a lot of transactions, do you have any lessons learned or > recommendations for Microsoft SQL server in a clustered environment? > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"