2124 InterBase Performance Monitoring: Vision and Control

1
2124InterBase Performance Monitoring Vision and
Control

• Craig Stuntz
• TeamB / Senior Developer
• Vertex Systems Corporation

2
Performance Monitoring overview

• Uses tables, so SQL techniques and security rules
  still apply
• Provide a snapshot of DB state at one instant in
  time
• Temporary tables
• with special features

3
New Features in InterBase 7.5

• New actions Flush, Reclaim. and Sweep
• New tables Heaps and Triggers
• Improved GUI tool
• Also, Ping (keepalive) introduced in IB 7.1 SP 2

4
Table by Table

• (demo)

5
Security

• Non DBA / DB owner users have no permissions by
  default
• Can change this with GRANT
• Consider using VIEWs to restrict data to current
  user only
• Not recommended for non-trustworthy users

6
Performance Monitoring for DBAs

• Vision
• Whats happening now?
• Audit logging
• Configuration adjustments
• Control
• DB maintenance
• Attachment, statement, transaction control

7
Performance Monitoring for Programmers

• Transaction isolation and lifetime
• Use SQL tricks

8
Free Bonus Bullet Points

• Third-party tools
• Future directions

9
Questions?
10
Upcoming Sessions
11
Thank You

• 2124
• InterBase Performance Monitoring
• Vision and Control
• Please fill out the speaker evaluation
• You can contact me further by posting questions
  to the Borland newsgroups