Webサイトを快適にご利用いただくためには、IE11以降、Chrome、Firefox、またはSafariをご使用ください。

How to create and deploy script agents in Foglight

Learn how to create and deploy script agents in Foglight, the solution for database performance monitoring across multiple platforms.

Related videos

SQL Optimization
SQL Optimization

Using Foglight and SQL Optimizer you can identify poorly performing queries and rewrite them or generate a more efficient execution plan. First, use Performance Investigator to identify and select the query you wish to tune, i.e., by number of executions, IO, CPU time, etc. The video explains how to use SQL Optimizer for better query performance.

Change Tracking
Change Tracking

Using the change tracking feature, Foglight allows you to correlate performance issues with changes that might have occurred, such as those to database configurations, objects, indexes and execution plans. You can see a graphical representation of the changes over the desired time period, and, as an example, use the Plan Analyzer to compare execution plans.

Performance Baselines
Performance Baselines

Foglight uses IntelliProfile™ technology to estimate system performance baselines based on periods of collected metrics. Deviations from baselines trigger alarms. From the dashboard, you can investigate these alarms and determine what might be causing any abnormalities. Baseline alarms can easily be configured.

Quickly Isolate Deadlock Issues
Quickly Isolate Deadlock Issues

Foglight captures database deadlocks in a dedicated UI with tabs to view the deadlocks by time period, database, objects and applications. Using the deadlocks table, you can drill into a deadlock to see the offending SQL text, lost time and more. You can also get more information in downloadable and editable XML which helps you identify the deadlock victim and successful process.

Focus on CPU
Focus on CPU

Foglight can sound alarms for CPU usage that spikes over established baselines – a clear indicator that something is wrong. In this case, you’ll want to identify queries that might be using the most CPU and potentially tune them. You can also see whether the problem is with the operating system or the hypervisor.

Quickly Isolate Workload Bottlenecks
Quickly Isolate Workload Bottlenecks

From the Foglight dashboard, you can highlight a specific time period and examine the various components that might be slowing down performance. These include the database, users, programs and SQL statements. See how you can isolate wait events and identify the bottlenecked workloads in just a few clicks.

Downloading your Foglight for Databases Trial
Downloading your Foglight for Databases Trial

This video guides you to quickly access your Foglight Trial download file. You’ll need to provide contact information and create (or log into) your Quest account prior to downloading. Our Customer Success team is available to assist you with download and installation, if needed.

Foglight for Databases Architecture
Foglight for Databases Architecture

This video provides a short overview of Foglight and its architecture. To accommodate different infrastructures and flexible usage, Foglight has several components. This video will touch on these components and how they work to your advantage. Email our Customer Success team if you need more information on Foglight components.

Prerequisites for Installing Foglight
Prerequisites for Installing Foglight

Watch this video to learn the system specifications and hardware needed before installing Foglight. For more information on Foglight prerequisites or distributed installation of Foglight, visit this page.

Installing Foglight for Databases
Installing Foglight for Databases

Once you’ve successfully downloaded Foglight, watch an extended clip of how to install it. This video demonstrates installation on a Windows platform and walks you through the different options you’ll see in the installation wizard.

Creating a SQL Server Connection in Foglight
Creating a SQL Server Connection in Foglight

This video provides an overview of how to configure a Foglight Performance Investigator repository for a SQL Server connection.

Creating an Oracle Connection in Foglight
Creating an Oracle Connection in Foglight

This video provides an overview of how to configure a Foglight Performance Investigator repository for an Oracle connection.

Foglight Database HealthCheck
Foglight Database HealthCheck

Solve the top database performance and tuning mysteries. Watch our Foglight database HealthCheck video to maintain database health.

Easily manage multiple database platforms with Foglight for Databases
Easily manage multiple database platforms with Foglight for Databases

In this video you can see how to manage multiple database platforms and consolidate information into a single console with Foglight for Databases.

Foglight for Databases ensures the health of your database environment
Foglight for Databases ensures the health of your database environment

Meet the increasingly complex demands of cross platform database performance monitoring for both on-premises and cloud database platforms.

こちらもいかがですか:

Foglight for Cross-Platform Databases
Foglight for Cross-Platform Databases

多様な環境全体にわたり、データベースパフォーマンスの管理を統合して標準化。

無料トライアルをダウンロード