Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

A customer is considering changing the server configuration in there data center to virtual machines and Network-attached storage. Are there any issues we should be aware of regarding SQL Anywhere in this configuration? We are currently moving all databases to 12.0.1 but will have a few still running 9.0.2 when this is scheduled to take place.



asked 18 May '12, 18:13

J%20Diaz's gravatar image

J Diaz
accept rate: 10%

(20 May '12, 14:13) Volker Barth


FWIW I found that article by using the search box on this page:

permanent link

answered 18 May '12, 20:59

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 18 May '12, 21:02

Thanks Breck, I'm learning...

(20 May '12, 09:25) J Diaz

@Breck: Now is the time to spread the "tales" link, methinks:)

(20 May '12, 14:07) Volker Barth
Replies hidden

@Volker: Not yet. The Google Custom Search Engine feature seems to be broken. I have done some fiddling, but it will probably take some time to see any results. The symptom? Bogus result sets for some searches, like "select" returning only one hit, but "olap" returning several. The Google CSE GUI also seems to be unstable.

(20 May '12, 14:21) Breck Carter

See that discusses some important factors related to I/O semantics across Linux and Windows operating systems.

What virtual machine OS software are you planning to use, Jim? VMWare?

permanent link

answered 18 May '12, 22:10

Glenn%20Paulley's gravatar image

Glenn Paulley
accept rate: 43%

How does that article relate to NAS, SAN or VM usage? None of those terms appear in the article (which might explain why it didn't turn up in the search).

(19 May '12, 08:59) Breck Carter
Replies hidden

The article explains the I/O semantics required by both Linux and Windows with respect to their filesystems. The issue with running under a VM is whether or not the VM relays flush() and similar calls from the host OS through to the underlying hardware. If it does not, then potential exists for corruption, particularly with power failures.

(19 May '12, 16:28) Glenn Paulley

I believe the plan is to use VMWare. I've asked for proposed specifications on both the Virtual Machine and NAS. Thanks as always for the assistance.

(20 May '12, 09:03) J Diaz
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 18 May '12, 18:13

question was seen: 2,787 times

last updated: 20 May '12, 14:21