I know this is a question loaded with potential evangelism, but...

Next calendar year we will be upgrading our SQLAnywhere database (appx 60Gb, 50-75 concurrent users) from v10 to v12. Does anyone have any real-world experience showing is there is a performance advantage between 64-bit Linux & Windows?

asked 13 Nov '13, 10:23

BudDurland's gravatar image

BudDurland
3169920
accept rate: 0%

edited 13 Nov '13, 10:26

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275

2

This is not an answer to your question but... why are you moving to v12 instead of moving the latest release v16?

(13 Nov '13, 10:25) Mark Culp
1

If you do upgrade to Linux (or you decide to test the performance on Linux), be sure to upgrade to build 12.0.1.3953/16.0.0.1636 or later. Performance on Linux is significantly better in these versions. (http://search.sybase.com/kbx/changerequests?bug_id=740799)

(13 Nov '13, 10:33) Mikel Rychliski

@mark: We're driven by what version of SA our ERP application if validated to work with, and vendor is, well, not so johnny-on-the-spot to test out the latest versions (they just recently confirmed v11 to work).

@Mikel: We always do the latest EBF on install, and check for updates every quarter (sooner if an issue is identified)

(13 Nov '13, 13:23) BudDurland

Just as an information (you did not ask for this os) SQL Anywhere 12 also runs very nicely on OS X 10.8 compared to Windows Server 2008 R2. Robert

(18 Dec '13, 16:32) robert

We had a 60GB ASA 11 database running (replicated via dbremote) on both a windows and linux 64 system. In terms of performance we did not see a difference between the two systems. (Same Hardware!)

So I think it is safe to choose what platform meets the other criterias of your IT infrastructure.

André

permanent link

answered 14 Nov '13, 11:57

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

1

Just the kinds of response I was hoping for, rooted in real-world experience. Thanks!

(19 Nov '13, 07:46) BudDurland

What Hardware do you have for a 60GB DB? How many users? We have sometime troubles with performance and i want to know what others do. Thanks.

permanent link

answered 20 Feb '14, 09:59

dnichterwitz's gravatar image

dnichterwitz
61114
accept rate: 0%

Ours is running is a dual-Xeon VMWare 5.1 host. We allocated a good deal of RAM (12GB). The storage is to a Dell SAN over iSCSI, though I'm thinking of moving it to direct attached storage for performance, if I can settle the disaster recovery issue through mirroring. We support appx 50 simultaneous connections. However, a handful of those uses are using fairly data intensive queries.

(20 Feb '14, 10:19) BudDurland
Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×248
×61
×44

question asked: 13 Nov '13, 10:23

question was seen: 1,092 times

last updated: 20 Feb '14, 10:19