|
We recently ran into this in our test lab, where we normally test our software on virtual machines. With a SQLA 12 database service running on a Windows 2008 R2 Server virtual machine, if we are running a live backup against it (dbbackup -l, version 12) from the host machine or from another physical or virtual machine, we observe the database locking up for 15 - 25 seconds at regular intervals of 1.5 to 5 minutes. The lockup can be seen by repeating a simple query in ISQL or running our application, which accesses the database regularly. The lockup only occurs when the live backup is running. We couldn't reproduce the problem when we used real physical machines. The virtualization software is Microsoft Hyper-V (2008 version). The SQL Anywhere version is 12.0.1.3152. Any insight into what might be causing this would be appreciated, thanks. |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 20 Dec '12, 10:49
question was seen: 2,087 times
last updated: 20 Dec '12, 10:52
Check the console log to determine if the lockups coincide with checkpoints?