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.

asked 20 Dec '12, 10:49

Bob%20Leviton's gravatar image

Bob Leviton
1967716
accept rate: 0%

Check the console log to determine if the lockups coincide with checkpoints?

(20 Dec '12, 10:52) Mark Culp
Be the first one to answer this question!
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:

×72
×10
×10

question asked: 20 Dec '12, 10:49

question was seen: 864 times

last updated: 20 Dec '12, 10:52