Quest Central for Sybase

1
Quest Central for Sybase


2
Quest Central for Sybase
3
Application Performance Management
Detect, diagnose and resolve application performan
ce issues quickly
4
Quest Central for Sybase Performance Certainty
Solution

• Assures reliable database performance
• Diagnoses ASE slowdowns
• Maximizes performance through SQL optimization,
  Abstract Plans and Indexing Strategy
• Ensures successful ASE version upgrade
• Stabilizes ASE and application performance
• Predicts where performance problems will occur
  before deploying applications in production
• Provides a methodology to achieve performance
  gains

5
Quest Central for Sybase

• Provides an answer to all these questions
• What is happening on my ASE server right now?
• What is the performance impact of database
  environment changes?
• Will the query plans change when I migrate?
• Will the performance be improved by this index?
  Will it be degraded?
• What SQLs query plans will experience
  performance changes?
• If the performance will degrade, how can it be
  optimized and maintained?

6
Two Components

• Spotlight on Sybase ASE
• SQL Tuning

7
Spotlight on Sybase ASE

• Graphically displays, in real time, the actual
  server processes and flow of data in your
  database so administrators can quickly identify
  congested areas and take appropriate corrective
  action.
• Integration with Foglight
• Integrates with other Spotlight solutions into a
  single console

Oracle
8
Spotlight on Sybase ASE

• Shows a visual representation of process flows
  within an instance, enabling observation of
  actual database activity in real time
• Identifies bottlenecks using flows, graphs, and
  visual icons
• Displays details of problem areas, including Most
  Active Sessions, Inefficient SQL, Locks/Wait
  Events, and Disk I/O, helping resolve performance
  problems quickly
• Alerts with an audio or visual alarm if any
  database component is forming a bottleneck

9
(No Transcript)
10
SQL Tuning More Than Meets the Eye

• SQL Capture
• SQL Optimization
• Index Recommendation
• Impact Analysis

11
Capturing SQL

• SQL Inspector
• Gathers from MDA tables (12.5.0.3)
• View top resource consuming statements
• Send SQL for corrective action

12
SQL Inspector
13
SQL Scanner

• Identify SQL in source codes without executing
  the application
• Stored procedures, views, functions
• SQL Inspector capture files
• SQL scripts, Powerbuilder files
• Analyze extracted SQL and show potential
  performance impact
• Quickly get to those statements most in need of
  tuning

14
SQL Scanner
15
SQL Optimizer

• Generate alternative SQL
• Show only those with a query plan change
• Benchmark each alternative
• Determines the optimal statement for your database

16
Syntactical SQL Optimizer
17
Index Advisor

• Recommend Indexes for given SQL statement
• Estimate time and space needed to build index
• Optional batch run to determine performance change

18
Index Advisor
19
Index Impact Analyzer

• Will this index make my other SQLs faster?
• Will this index degrade any other SQLs?
• If so, which ones and by how much?

20
Index Impact Analyzer
21
Migration Analyzer

• When I migrate to 12.5.3, what will happen to my
  query plans? What about ASE 15?
• Before I roll out a release, can I see any
  degraded SQLs that may impact my users?
• Migration scenarios
• 12.5.2 to 12.5.3 to 12.5.4
• QA/UAT to Production
• Sybase on Solaris 9 to Sybase on Linux

22
Migration Analyzer
23
Configuration Analyzer

• If I change this parameter, do I really know what
  will happen to all of my query plans?

24
Configuration Analyzer
25
Unused Index Analyzer

• Which indexes are not being used by any query
  plan?
• Unused indexes could be deleted to free up space,
  improve speed of DML statements and decrease
  maintenance
• Potential for SELECT performance improvement also

26
Unused Index Analyzer
Analyzes query plans of SQL statements in the
SQL Repository to identify unused indexes
27
Quest Central for Sybase
28
Thanks

• www.quest.com/sybase