Adaptive Server IQ-M 12.4. 3 Performance and Tuning

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