Hi, Does anyone know where I can find a guide to performance tuning and ASA-9? Sometime download link. I did several searches and only meeting to version 11 and / or higher I need advanced technical guide to go along DBA's.

asked 22 Jan '13, 10:04

Walmir%20Taques's gravatar image

Walmir Taques
600293143
accept rate: 13%


I do not know one particular whitepaper, but Breck maintains this great list of technical documents here:

Tales From The Doc Face - SQL Anywhere Technical Documents

While the custom search for "performance" was not that helpful in my case, simply searching for "performance" on this page does list a bunch of documents, and fortunately Breck has usually listed the related versions, too. Resume: There are several docs on v8/v9 listed - you may have a read:)

permanent link

answered 22 Jan '13, 10:28

Volker%20Barth's gravatar image

Volker Barth
30.3k300452659
accept rate: 32%

@Volker Barth, Is there any official documentation from Sybase?

(22 Jan '13, 12:02) Walmir Taques
Replies hidden

I can' tell that - however, IMHO Breck's list is by far the best list to look for documentation on SQL Anywhere (besides the great online documentation, of course), and most entries there are official Sybase material.

(22 Jan '13, 12:19) Volker Barth
Comment Text Removed

Ok. thanks!

(22 Jan '13, 12:58) Walmir Taques

This book has a chapter on tuning: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20

10 TUNING     . . . . . . . . . . . . . . . . . . . . . . . 399
   10.1 Introduction  . . . . . . . . . . . . . . . . . . . 399
   10.2 Request-Level Logging . . . . . . . . . . . . . . . 400
   10.3 Index Consultant  . . . . . . . . . . . . . . . . . 408
   10.4 Execution Profiler  . . . . . . . . . . . . . . . . 413
   10.5 Graphical Plan  . . . . . . . . . . . . . . . . . . 416
   10.6 File Fragmentation and Reorganization . . . . . . . 421
      10.6.1 File Fragmentation . . . . . . . . . . . . . . 421
      10.6.2 Table Fragmentation  . . . . . . . . . . . . . 423
      10.6.3 Table Reorganization . . . . . . . . . . . . . 428
      10.6.4 Index Fragmentation  . . . . . . . . . . . . . 429
      10.6.5 Index Reorganization . . . . . . . . . . . . . 432
      10.6.6 Database Reorganization with Unload/Reload . . 433
   10.7 CREATE INDEX  . . . . . . . . . . . . . . . . . . . 437
   10.8 Database Performance Counters . . . . . . . . . . . 443
   10.9 Tips and Techniques . . . . . . . . . . . . . . . . 446
   10.10 Chapter Summary  . . . . . . . . . . . . . . . . . 453

Foxhound might also help: http://www.risingroad.com/foxhound/index.html

permanent link

answered 22 Jan '13, 16:28

Breck%20Carter's gravatar image

Breck Carter
25.6k427586844
accept rate: 20%

edited 22 Jan '13, 16:29

Hi, thanks for the help. I'm developing a survey by the College and is based on the database sybase (ASA-9). How does the recording of the indexes in sybase, I know that is recorded in a table, but as the "optimizer" knows whether or not to use the index to search in?

(25 Jan '13, 08:05) Walmir Taques
Comment Text Removed
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:

×97

question asked: 22 Jan '13, 10:04

question was seen: 1,877 times

last updated: 25 Jan '13, 11:48