on 2013 Nov 13 10:23 AM
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?
Request clarification before answering.
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é
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just the kinds of response I was hoping for, rooted in real-world experience. Thanks!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.