|
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. |
|
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:) @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 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
|
