cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

We develop an application that uses Sql Anywhere 11.0.1 as the database. Database size can be anywhere from 5GB to 25GB. My task has been to come up with specs for the application to run in a virtual environment. I'm not a virtual expert, but I do know there are many different ways to virtualize. We have small, medium and large/enterprise customers that use our application. We have tested extensively on physical hardware and specifically RAID and mulitple SSD drives, so we know what performance can/should be. We have recommended specs built for physical hardware.

I read through many of the posts regarding MS SQL Server regarding virtualization(since I didn't find a lot specifically geared toward SQLanywhere). There are a number of ways to allow access to the DB (through shared storage on SAN, local storage on host machine, or possibly having multiple instances of the DB to share the load). So, my question is it plausible(from an industry standpoint) to not necessarily give VM requirements on our spec sheet, but have some fine print about DB performance "gotcha's" if running in a VM.

thanks for your thoughts

View Entire Topic
Former Member
0 Likes

Thanks guys. Unfortunately, when our sales team sells the app, they talk to the business side and of course, in order to make it most cost efficient, they always ask what the minimum requirements are. The ole' "something for nothing" as someone above stated. We generally don't give minimums, but when they try to virtualize and place the app on a host and then don't give it enough resources either because they don't know how or don't want to dedicate enough, then, this is where we obviously see performance issues. So, going back to my original post. Is it good enough to just put physical server requirements on a spec sheet and adding some fine print about placing the app in a VM environment could cause performance issues. Part of my thinking is that I can't test every VM environment, nor can I dictate how our customers IT department inevitably deploy/provision the VM.
Hope that all makes sense...I really do appreciate the candid feedback.