Learn how to interpret and react to various types of alarms and to problematic resource usage by workloads.  Equip yourself to track down causes of degrading performance.


Diagnosing Blocking and Locking with Foglight for Databases

View webcast here

This webcast covered:

  • Alarms that can proactively notify user of a long running blocking lock, and / or deadlocked session.
  • Diagnosing blocking activity in real time.
  • Diagnosing blocking locks, and deadlocks in the past.
  • Sharing blocking lock details, and deadlock events with developers.

 

 

Finding Problematic Oracle and SQL Server SQL Statements & What to do Once You Find Them

View webcast here

This webcast covered:

  • Using base Foglight versus SQL Performance Investigator to find problematic SQL.
  • Filtering by user, program, disk, etc.
  • Comparing to past executions of the SQL.
  • Looking at prior execution plans.
  • What happens when you click the “Tune SQL” button?

 

 

Part 2: Finding Problematic Oracle and SQL Server SQL Statements & What to do Once You Find Them

View webcast here

This webcast covered:

  • Understanding the performance impact of changes
  • Diagnosing object specific (table and index) IO performance
  • Digging into query execution plans
  • Looking at performance advisories
  • Sharing performance data with developers

 

Capacity Management with Foglight

View webcast here

This webcast covered:

  • Understand resource utilization across the enterprise
  • Determine which servers are “over capacity” and therefore good candidates for tuning
  • Establish which servers are “under capacity” and therefore good candidates for consolidation, or perhaps pulling the plug
  • Understand “normal” performance via Foglight baselines
  • Forecast storage needs into the future
  • Dashboard and reports that expose capacity data to those who need it

 

 

Diagnosing IO Issues with Foglight for Databases
View webcast here

 This webcast covered:

  • Foglight alarms that can actively notify you of current and emerging IO problems
  • Screens that help you see which objects are experiencing IO, and how much
  • Analytics to quickly discover the databases, users, applications and statements involved in heavy IO
  • Performing comparisons between time periods to discover what changes are responsible for new and emerging IO bottlenecks
  • View the query plans of the relevant statements to see the specific operations responsible for heavy IO

 

Finding and tuning problematic queries with Foglight Expert
View webcast here

This webcast covered:

  • Foglight alarms that can actively notify you of current and emerging query issues
  • Screens that help you isolate resource-consuming statements
  • Analytics to quickly discover the databases, users, and applications with which the statements are associated
  • View the query plans to help determine bottlenecks
  • Initiate a tuning session and be provided rewrite alternatives

 

 Capacity Planning & DB Expansion Pack
View webcast here

This webcast covered:

  • Understanding your current database workload using specific metrics and baselines
  • Setting up and organizing your plan for capacity management by scheduling monthly and /or quarterly reports
  • Getting additional functionality by using the DB Expansion Pack

 

Insights from Foglight

 View Webcast Here

This webcast covered: 

  • Advisories – Are automatically-generated and comprehensive reports which focus on specific performance issues discovered by Foglight.
  • Comparison -Lets you see what specific new activities within your server that are responsible for the performance changes you are seeing.
  • Performance Highlights – Filters through server load data to show you top activity from a number of different angles.
  • Change Tracking – Helps you find configuration, schema and execution plan changes that could be affecting performance
Anonymous
Related Content