Sybase iAnywhere SQL AAnywhere Mobile and Embedded Database

The Invisible Database

Thoughts and opinions on embedded, mobile and self-managing database systems, as well as the software business.

header image

SQL Anywhere 12 Announced!

June 29th, 2010 · 5 Comments

Today, Sybase announced the next major version of SQL Anywhere: Version 12. SQL Anywhere 12 has been in development for over two years. This new version includes a great many new features. The common theme running through all these features is our effort to improve the ease-of-use experience and the self-management capabilities of the database server.

There are literally hundreds of new features, but I would like to highlight a few important ones:

Spatial Data Support
We have added comprehensive support for the storage, manipulation, and synchronization of spatial data. You can now store location information, and then access it in your database queries, allowing for very powerful applications. Spatial data and synch is supported on all SQL Anywhere supported platforms, including servers and handheld devices. Both Eric Farrar and myself have written about spatial support previously here and here.

Scale-out Support
You can now set up a hierarchy of read-only copy nodes to allow offload high volume reporting or web-site applications to access read-only data, without affecting performance on the main server. The tree of read-only nodes provides automatic load balancing, and automatic reconfiguration in the event of one of the nodes going offline.

Sample Read-Only Scale-Out setup.

Sample Read-Only Scale-Out setup.

Support for iPhone
We ship support for iPhone with our UltraLite database and synchronization components. Application developers can now create true enterprise applications that allow data on the device to be seamlessly synchronized to back-end servers. Tom Slee wrote extensively about our iPhone support when we released it in Beta test.

Self Managing Enhancements
SQL Anywhere has always been known for its self managing characteristics, but I think we’ve gone a step further with version 12. A significant new feature, that will work invisibly behind the scenes is our new Server Thread Auto-Tuning capability. This unique feature in the industry allows the SQL Anywhere Server to dynamically change the number of worker threads used inside the server to handle requests. When throughput would be improved with additional threads, more threads are used. When throughput would be increased by decreasing the number of threads, thereby reducing contention and thrashing, fewer threads are used. Previously, administrators had to set the number of threads at server startup time using a “try this guess, and test performance” approach. This becomes a thing of the past. I predict that everyone who knew about these options will pretty soon forget that they even existed.

The other major self management enhancement is the addition of automatic self-healing on statistics used by the query optimizer inside the database. The SQL Anywhere server will monitor itself, and observe when the statistics used by the optimizer significantly differ from the actual results returned by a query. When this happens, the server will undertake an effort to repair the statistics without affecting user performance. Glenn Paulley wrote a comprehensive article on this process here.

Central Admin of Remote Databases
In large scale synchronization environments, there are often small administrative tasks that need to be performed such as schema upgrades, backups, etc. Previously, these tasks presented a challenge to administrators, who had to use additional tools, or otherwise invent something themselves. SQL Anywhere 12 now provides a set of tools to help with these administrative tasks directly.

Scalability Testing of Synchronization Environments
Customers are always asking for guidelines for capacity planning a large scale synchronization setup. Our recommendation is always to test performance of their setup. This has been a challenge in the past. SQL Anywhere 12 now includes a toolset to enable the capture, customization and replay of a synchronization session, and enables simulation of large environments. This can be used to more accurately observe and correct bottlenecks prior to putting a system into production.

Complete details of all the enhancements in SQL Anywhere version 12 are available in our online documentation system: Doc Comment Exchange (DCX), located here.

As well, you might wish to read Breck Carter’s post about performance improvements in proxy tables.

Share and Enjoy:
  • TwitThis
  • Digg
  • Facebook
  • Google Bookmarks
  • Technorati
  • LinkedIn
  • MySpace

Tags: SQL Anywhere

5 responses so far ↓

  • 1 Jai // Jun 30, 2010 at 3:52 am

    Does “self management of worker threads” you do not need -GN option anymore?

  • 2 Chris Kleisath, Senior Director of Engineering // Jun 30, 2010 at 7:08 am

    Correct, you no longer need to set the “-gn” option on the server. In many cases, you will get better performance by allowing the server to tune the number of threads automatically.

  • 3 With Mobile As Their Alarm Clock, Press Wakes Up to SQL Anywhere | UberMobile // Jun 30, 2010 at 2:36 pm

    [...] The new SQL Anywhere 12 improves upon that by adding support for spatial data, scale-out clusters, iPhones (to enable apps run faster and more powerfully), more self-management and central administration features, and tools to help test and plan large-scale data synchronization setups, to better avoid bottlenecks in production. [...]

  • 4 Sybase - Hibernate schema generation using PowerDesigner with SQL Anywhere // Jul 4, 2010 at 10:03 pm

    [...] version 11, and the current PowerDesigner 15.2 release (a PowerDesigner 15.2 EBF will support the forthcoming SQL Anywhere 12 release) supports reverse-engineering for both Hibernate and NHibernate, and can generate either the [...]

  • 5 Sybase - SQL Anywhere 12 Released to Manufacturing! // Jul 7, 2010 at 7:22 am

    [...] RSS ← SQL Anywhere 12 Announced! [...]

Leave a Comment

Note that all comments are currently being moderated until I have a better handle on spam, so your comment may not appear for a couple of hours

Sybase Privacy policy