For the best web experience, please use IE10+, Chrome, Firefox, or Safari

Foglight Skills 101: Finding and tuning problematic queries with Foglight Expert

Foglight Skills 101:  Finding and tuning problematic queries with Foglight Expert
Online

Apr.

30

  • Date:Apr. 30, 2019
  • Time: 1:00 PM – 2:00 PM EST
  • Duration:45 Minutes
  • Location:WebEx
  • Event:Online
Foglight Skills 101:  Finding and tuning problematic queries with Foglight Expert

Join this session to learn how Foglight’s ‘Expert Edition‘ can help you identify resource-intensive queries with a simple set of workflows.  You’ll see how Foglight offers Activity Highlights and Advisories to narrow your focus, isolate queries by resource type, and view its current access paths for any inefficient spots. From there, you’ll learn how to initiate a tuning session and have the SQL Optimizer provide hints, rewrites, and index suggestions to improve SQL performance based on your performance criteria.

What you will learn

  • 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

Attend Your Free Event