SQL anywhere and virtualization requirements

[#1]

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

[Breck_Carter]

I have had a number of clients who experienced SQL Anywhere performance problems directly caused VMs. Generally the root causes are a combination of (a) the desire to get something for nothing, (b) the idea that a heavily-loaded database server behaves no differently from a lightly-loaded email server, and (c) the belief that powerful computer will automatically assign resources wherever and whenever they are needed with no prior thought, planning or preparation.

Outside the office, (a), (b) and (c) go together with (d) the belief that any teenager can find anything on any computer in the world with only three keystrokes.

Absent those, SQL Anywhere runs fine on a VM 🙂

[reimer_pods]

Failed trying to interpret "... together with (d) ...", seems to be a virtual topic 8-|.

[Breck_Carter]

Point (d) is "the belief that any teenager can find anything on any computer in the world with only three keystrokes."

[VolkerBarth]

The truth is they only need three touch gestures:)

Don't forget that we are old-school...