1 / 13

Adaptive Server IQ-M 12.5 Performance and Tuning

Adaptive Server IQ-M 12.5 Performance and Tuning. Agenda - 1. Section 1 Introduction Section 2 Disks and Things! Section 3 Design Section 4 Create Database Section 5 Tables and Data Types Section 5a Large Object Data Types Section 6 Indexes. Agenda - 2. Section 7 IQ Monitor

baeza
Download Presentation

Adaptive Server IQ-M 12.5 Performance and Tuning

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Adaptive Server IQ-M 12.5Performance and Tuning

  2. Agenda - 1 • Section 1 Introduction • Section 2 Disks and Things! • Section 3 Design • Section 4 Create Database • Section 5 Tables and Data Types • Section 5a Large Object Data Types • Section 6 Indexes

  3. Agenda - 2 • Section 7 IQ Monitor • Section 8 Memory and Loading • Section 9 Query Processing • Section 10 Administration etc. • Section 11 Simplex vs. Multiplex

  4. 1 Introduction

  5. Location Bits • Fire Exits • Toilets • Duration • Breaks • Other bits….

  6. Who am I ? Richard Soundy IQ Technical Specialist European Products and Solutions Group Based in Europe +44-1628-597414 Maidenhead UK soundy@sybase.com

  7. Prerequisites • A reasonable working knowledge of Adaptive Server IQ-M • A working knowledge of SQL • Some experience in Database Administration

  8. Performance and Tuning • In order the following are vital for performance : • 1) Database Design • 2) Database Design • 3) Database Design

  9. Also • In addition to Database Design the following are helpful : • Correctly sized hardware • Correct Set-up for IQ-M • Knowledge of Application • Ability to understand what IQ-M is doingand help IQ-M to perform faster

  10. Performance and Tuning • In this course we can only suggest ideas and methods • The application of these ideas and methods is up to you • If anyone finds something that seems to work – tell us, so we can incorporate the ideas

  11. Performance and Tuning • A lot of what we teach here is heuristic – we tried it once (or twice) and it works • But a large amount comes from the engineers and comes under the heading of “well this should work this way!” • If this doesn’t happen in the field – let us know – and we will try and find out why

  12. Platforms/OS Supported in Sybase IQ 12.6 • Unix • Sun 64: 2.8, 2.9, (2.10*) • IBM 64: 5.1, 5.2, 5.3 • HP 64: 11.0, 11.1, (11.2*) • HP Itanium 11.23 • Windows • 2000, 2003, XP • Linux • Redhat 2.1, 3.0 • Suse 8, 9 • Redflag

  13. Introduction - End

More Related