The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.
  • SQLA v10.0.1.4051
  • Win Server 2008 64bit
  • DB size 116GB
  • 32 GB RAM (max cache allocated 29GB)
  • 4 x quad core
  • Approx 130 users

The resources are all dedicated to the virtual machine.

The previous physical system which had similar RAM (but slower processors). The old system had the data files on a 0+1 RAID array, the new system has (for the moment RAID 5, it will be changed) but significantly faster disks.

Backup of the database takes about 30 mins on both systems.

On the old physical validation took around 4.5 hours, now its taking about 12 hours. The business is seasonal, and user load is low at the moment and general speed of use is fine. While longer validation could be accommodated, the concern is that the much slower performance here may indicate other issues that will become apparent when user load increases again.

I'm not sure where the most likely potential bottlenecks for validation really are - or indeed what statistics to look at the confirm / eliminate them. Any suggestions as to where to start would be much appreciated!

asked 30 Aug '11, 13:20

Justin%20Willey's gravatar image

Justin Willey
6.8k110144212
accept rate: 20%

1

How many drives are used in the old & new configuration? Validation in v10 can require lots of random IO and the number of spindles would be a limiting factor. FWIW, validation in v12 should be much, much faster.

(30 Aug '11, 13:33) John Smirnios
Replies hidden

Thanks John - I don't know the answer but I'll find out!

(30 Aug '11, 13:46) Justin Willey

Is it the actual backup that is taking longer or just the validation? If it's the backup itself, you may be encountering issue CR #676340, fixed in 10.0.1.4258.

If it's just the validation, notably Sybase cannot guarantee the performance of the database server on a virtual machine: http://www.sybase.com/detail?id=1032794#q6

Please note that the extent of support does not cover performance. Sybase does not gurantee the performance for any Sybase products running on virtual machines.

The validation is a combination of CPU and disk activity - I would look at general OS performance counters between the two systems to evaluate how much overhead the virtualization layer is adding.

permanent link

answered 30 Aug '11, 14:10

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 30 Aug '11, 14:23

In virtual environments disk IO is often a problem, and validation does a lot of disk IO...

(31 Aug '11, 05:07) ASchild

More experimentation suggests that the problem is the speed of connection to the disk array

(03 Nov '11, 11:43) Justin Willey
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:

×114
×10

question asked: 30 Aug '11, 13:20

question was seen: 936 times

last updated: 03 Nov '11, 11:43