1 / 12

Adaptive Server IQ-M 12.4. 3 Performance and Tuning

This course covers performance tuning techniques for Adaptive Server IQ-M 12.4.3, including index internals, database design, query optimization, and administration.

wblake
Download Presentation

Adaptive Server IQ-M 12.4. 3 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.4.3Performance and Tuning Richard Soundy BI Europe Sybase Business Intelligence Division

  2. Agenda - 1 • Section 1 Introduction • Section 2 Index Internals • Section 3 Database Design for IQ • Section 4 Building Databases etc. • Section 5 IQ Monitor • Section 6 Tuneable Options

  3. Agenda - 2 • Section 7 Joins and Sorts • Section 8 The Query Tree • Section 9 Multiplex • Section 10 Administration etc. • Section 11 What was in the 12.4.3 Release • Section 12 What should/will be in the 12.5 Release

  4. 1 Introduction

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

  6. Who am I ? Richard Soundy IQ Technical Manager Business Intelligence 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. Introduction - End

More Related