• Products
    • View all products
    • Free trials
    • Buy online
    • Product lines
      • ApexSQL
      • Change Auditor
      • Enterprise Reporter
      • Foglight Database Monitoring
      • Foglight Evolve
      • KACE
      • Metalogix
      • Migration Manager
      • NetVault Backup
      • One Identity
      • QoreStor
      • Quest On Demand
      • Rapid Recovery
      • Recovery Manager
      • RemoteScan
      • SharePlex
      • Spotlight
      • Stat
      • Toad
    • Featured products
      • Cloud Management
        • Cloud Access Manager
        • Foglight for Virtualization, Enterprise Edition
        • Identity Manager
        • On Demand Migration for Email
        • Quest On Demand
        • Rapid Recovery
      • Data Protection
        • Foglight for Virtualization
        • NetVault
        • NetVault for Office 365
        • QorePortal
        • QoreStor
        • Rapid Recovery
        • vRanger
      • Database Management
        • Foglight for Databases
        • Litespeed for SQL Server
        • SharePlex
        • Spotlight SQL Server Enterprise
        • Toad Data Point
        • Toad DevOps Toolkit
        • Toad Edge
        • Toad for Oracle
        • Toad for SQL Server
      • Identity & Access Management
        • Active Roles
        • Defender
        • Identity Manager
        • Identity Manager Data Governance
        • One Identity Safeguard
        • Password Manager
        • Privileged Access Suite for Unix
        • Starling Connect
        • Starling Two-Factor Authentication
        • syslog-ng
      • Microsoft Platform Management
        • Active Administrator
        • Change Auditor
        • Enterprise Reporter
        • GPOADmin
        • InTrust
        • Metalogix
        • Migration Manager
        • On Demand Migration for Email
        • Quest On Demand
        • Recovery Manager
      • Performance Monitoring
        • Foglight Capacity Director
        • Foglight Hybrid Cloud Manager
        • Foglight for Databases
        • Foglight for Operating Systems
        • Foglight for Oracle
        • Foglight for PostgreSQL
        • Foglight for SQL Server
        • Foglight for Storage Management
        • Foglight for Virtualization
        • Spotlight on SQL Server
      • Unified Endpoint Management
        • Desktop Authority Management Suite
        • KACE Cloud Mobile Device Manager
        • KACE Desktop Authority
        • KACE Privilege Manager
        • KACE Systems Deployment Appliance
        • KACE Systems Management Appliance
        • RemoteScan
  • Solutions
    • View all Solutions
    • Industries
      • Education
      • Energy
      • Federal Government
      • Financial Services
      • Healthcare
      • State & Local Government
    • Platforms
      • Active Directory
      • Cisco
      • DB2
      • Exchange
      • Google
      • Hyper-v
      • Lotus Notes
      • OneDrive for Business
      • Office 365
      • Oracle
      • SAP/Sybase
      • SharePoint
      • SQL Server
      • Teams
      • Unix/Linux
      • VMware
      • Windows Server
    • Cloud Management
    • Data Protection
      • Overview
      • Backup & Recovery
      • Cloud Management
      • Deduplication & Compression
      • Disaster Recovery
      • Office 365 Data Protection
      • Virtualization Management
    • Database Management
      • Overview
      • Administration
      • Cloud Migration
      • Data Preparation and Provisioning
      • Development
      • DevOps
      • Performance Monitoring
      • Replication
      • Supported Platforms
        • IBM DB2
        • MySQL
        • Oracle
        • PostgreSQL
        • SAP Solutions
        • SQL Server
    • GDPR Compliance
    • Identity & Access Management
      • Overview
      • Identity Administration
      • Identity Governance
      • Privileged Access Management
      • AD Account Lifecycle Management
      • Access Control
      • Cloud
      • Log Management
    • Microsoft Platform Management
      • Overview
      • Mergers & Acquisitions
      • Migration & Consolidation
      • Office 365 Migration & Management
      • Security & Compliance
      • Windows Backup & Recovery
      • Supported Platforms
        • Active Directory
        • Cisco
        • Exchange
        • Google
        • Groupwise
        • Lotus Notes
        • Office 365
        • OneDrive for Business
        • SharePoint
        • SQL Server
        • Teams
        • Unix/Linux
        • Windows Server
    • Performance Monitoring
      • Overview
      • Database Performance Monitoring
      • Operating System Monitoring
      • Storage Performance & Utilization Management
      • Supported Platforms
        • Active Directory
        • DB2
        • Exchange
        • Java
        • Hyper-V
        • .NET
        • Oracle
        • SAP/Sybase
        • Storage
        • SQL Server
        • VMware
    • Unified Endpoint Management
      • Overview
      • Endpoint Compliance
      • Endpoint Security
      • Endpoint Visibility
      • Industries
        • Education
        • Healthcare
      • Supported Platforms
        • Internet of things
        • Microsoft® Windows
        • MAC
        • UNIX/LinuX
  • Resources
    • Blogs
      • Data Protection
      • Database Management
      • IT industry Insights
      • IT Ninja
      • Microsoft Platform Management
      • Performance Monitoring
      • Toad World Blog
      • Unified Endpoint Management
    • Customer Stories
    • Documents
    • Events
    • Webcasts
    • Technical Documentation
    • Videos
    • Whitepapers
  • Trials
  • Services
    • Consulting Services
      • Overview
      • Microsoft Platform Services
      • Data Protection Services
      • Unified Endpoint Management
      • Performance Monitoring Services
      • Database Management Services
    • Educational Services
    • Support Services
  • Support
    • Support Home
    • By Product
      • All Products
      • AppAssure
      • Archive Manager
      • Change Auditor
      • Desktop Authority
      • DR Series
      • Foglight
      • KACE
      • Migration Manager
      • NetVault
      • Rapid Recovery
      • SharePlex
      • Toad
      • vRanger
    • Contact Support
      • Overview
      • Customer Service
      • Licensing Assistance
      • Renewal Assistance
      • Technical Support
    • Download Software
    • Knowledge Base
    • My Account
      • My Products
      • My Service Requests
      • My Licenses
      • My Groups
      • My Profile
    • Policies & Procedures
    • Consulting Services
      • Microsoft Platform Management
      • Data Protection
      • Unified Endpoint Management
      • Performance Monitoring
      • Database Management
    • Technical Documentation
    • Educational Services
    • User Forums
    • Video Tutorials
  • Partners
    • Overview
    • Partner Circle Log In
    • Become a Partner
    • Find a Partner
    • Partner Community
  • Blogs
    • IT Industry Insights
    • Quest Solution Blogs
      • Data Protection
      • Database Management
      • ITNinja
      • Microsoft Platform Management
      • Performance Monitoring
      • Toad World Blog
      • Unified Endpoint Management
  • Forums
  • 製品情報
    • すべての製品情報を見る
    • Change Auditor
    • Foglight
    • KACE
    • Metalogix
    • Migration Manager
    • Migrator for Notes to SharePoint
    • NetVault Backup
    • On Demand Migration for Email
    • QoreStor
    • Rapid Recovery
    • Recovery Manager
    • SharePlex
    • Spotlight
    • Toad
  • ソリューション
    • すべてのプラットフォームを見る
    • クラウド管理
    • GDPRコンプライアンス
    • データ保護
      • 概要
      • クラウド管理
      • ディザスタリカバリ
      • バックアップとリカバリ
      • Office 365 データ保護
      • 仮想化管理
      • 重複除外と複製
    • データベース管理
      • 概要
      • DevOps
      • データの準備と分析
      • データベースのクラウド移行
      • データベースパフォーマンス監視
      • データベース管理
      • データベース複製ソフトウェアツール
    • 統合エンドポイント管理
      • 概要
      • エンドポイントコンプライアンス
      • エンドポイントセキュリティ
      • エンドポイントの可視化
    • Microsoftプラットフォーム管理
      • 概要
      • ハイブリッドActive Directoryのセキュリティとガバナンス
      • Microsoftプラットフォームの移行計画と統合
      • セキュリティとコンプライアンス
      • 情報アーカイブおよびストレージ管理ソリューション
      • Windowsのバックアップとリカバリ
      • Microsoft Serverのパフォーマンスと可用性
      • レポート作成機能
      • グループポリシーと権限
    • パフォーマンス監視
  • サービス
    • コンサルティングサービス
      • 概要
      • Microsoftプラットフォーム管理
      • データ保護
      • 統合エンドポイント管理
      • パフォーマンス監視
      • データベース管理
    • トレーニングと認定資格
    • サポートサービス
  • サポート
    • サポートホーム
    • 製品で検索
      • All Products
      • AppAssure
      • Archive Manager
      • Change Auditor
      • Desktop Authority
      • DR Series
      • Foglight
      • KACE
      • Migration Manager
      • NetVault
      • Rapid Recovery
      • SharePlex
      • Toad
      • vRanger
    • お問い合わせ
      • すべて
      • カスタマサービス
      • ライセンス アシスタンス
      • 更新のアシスタンス
      • 技術サポート
    • コミュニティフォーラム
    • ソフトウェアのダウンロード
    • ナレッジベ%E3%83%BCス
    • マイアカウント
      • マイ プロダクト
      • Myサービスリクエスト
      • マイ ライセンス
      • マイ グループ
      • マイ プロファイル
    • ポリシーおよび手順
    • コンサルティングサービス
      • Microsoftプラットフォーム管理
      • データ保護
      • 統合エンドポイント管理
      • パフォーマンス監視
      • データベース管理
    • リリースノートおよびガイド
    • 教育サービス
    • ビデオチュートリアル
  • トライアル
  • パートナー
    • 概要
    • Partner Circleへのログイン
    • パートナーになる
    • Find a Partner
    • パートナーコミュニティ
  • コミュニティ
Quest Community
Quest Community
  • Site
  • User
  • Site
  • Search
  • User
Blogs
Blogs
  • Data Protection
  • Database Management
  • Microsoft Platform Management
  • Performance Monitoring
  • Unified Endpoint Management
  • Quest
  • More
  • Cancel
  • New
  • All tags
  • Foglight for SQL Server
  • Big Data
  • business Intelligence
  • Database Management
  • database monitoring
  • Database Performance Monitoring
  • DBA
  • Evaluation
  • Foglight
  • Foglight for Cross-Platform Databases
  • Foglight for Databases
  • Foglight for MongoDB
  • Foglight for Oracle
  • Foglight for PostgreSQL
  • Foglight for SAP ASE
  • Foglight for SQL PI
  • Foglight for Virtualization
  • Performance Analysis
  • Performance Investigator
  • Performance Monitoring
  • Quest
  • SQL Server
  • sql server performance monitoring
  • Thought Leadership
  • Troubleshoot
  • VMware
  • Adding Email Notification to Database Alarms

    Darren Mallette
    Darren Mallette

    Foglight ships with a rich set of pre-configured rules to alert you when issues arise with your databases.

    The default action is to put an alarm message on the dashboards within Foglight. Email notifications aren't enabled by default - but it's an easy…

    • 6 months ago
    • Blogs
    • Performance Monitoring
  • Introduction to Alarm Templates in Foglight 6

    Darren Mallette
    Darren Mallette

    With the release of Foglight version 6, alarm management has been simplified with the use of alarm templates.

    You can access Alarm Templates directly from the left-hand panel in the new UI. However, if you've upgraded from a previous version, it helps…

    • 8 months ago
    • Blogs
    • Performance Monitoring
  • Using Foglight User Defined Collections to check SQL Server Security Best Practices

    Janis Griffin
    Janis Griffin

    I was reviewing the article 13 SQL Server Best Practices recently and it occurred to me that 3 of the tips could be put in Foglight to continually check that your SQL Server instances are compliant.  Tip #3 in the article suggests that you should reduce…

    • over 1 year ago
    • Blogs
    • Performance Monitoring
  • Series Finale - Automating Foglight Blackouts

    Darren Mallette
    Darren Mallette

    Way back in 2020, these posts formed the building blocks of using the command line to automate alarm blackouts in Foglight:

    Part 1

    Part 2

    Part 3 

    In Part 3, we looked at adding objects (instances, hosts, etc.) to a service definition, and then having the…

    • over 1 year ago
    • Blogs
    • Performance Monitoring
  • Tips for User-Defined Queries in Foglight - Part 2

    Darren Mallette
    Darren Mallette

    In this post, some tips for working with User-Defined Queries (UDC's) were introduced.

    We left off with the idea of creating a custom dashboard showing UDC results from multiple instances.

    The Foglight data model is organized with a controlling root…

    • over 1 year ago
    • Blogs
    • Performance Monitoring
  • Tips for User-Defined Queries in Foglight

    Darren Mallette
    Darren Mallette

    The ability to enter your own queries into Foglight for SQL Server, Oracle and DB2 opens up a world of additional data that you can use with Foglight. These are called User-Defined Collections, or UDC's for short.

    There are some nuances to using them…

    • over 1 year ago
    • Blogs
    • Performance Monitoring
  • Foglight for SQL Server: Simple (but Powerful) Query Performance Monitoring

    Jason Hall
    Jason Hall

    While Foglight for SQL Server offers capabilities that go above and beyond most SQL Server monitoring products in the industry, Query Performance Monitoring is certainly a strength of the product that customers get significant of value out of.  I recorded…

    • over 1 year ago
    • Blogs
    • Performance Monitoring
  • Another way to gather VMware metrics on SQL Server hosts

    Darren Mallette
    Darren Mallette

    In this post, I alluded to 2 ways to capture VMware metrics with Foglight for SQL Server.

    The steps below apply to SQL Server running on Windows only. Since VMware Tools pulls metrics into the VM, we can access those by querying the WMI Performance Counters…

    • over 2 years ago
    • Blogs
    • Performance Monitoring
  • Correlating VMware metrics with SQL Server Performance - in 2 Parts

    Darren Mallette
    Darren Mallette

    There are a couple easy, free ways to get VMware metrics collected by Foglight for SQL Server. This first part shows the easier way.

    When setting up the monitor for SQL Server, you can select (or not) to provide VMware credentials.

    Foglight will connect…

    • over 2 years ago
    • Blogs
    • Performance Monitoring
  • I Didn't Know SQL Optimizer Could do that!

    Darren Mallette
    Darren Mallette

    In the first part of this series, we will learn how to export SQL statements from Foglight SQL Performance Investigator, and import them into SQL Optimizer.

    Start by opening SQL PI, and selecting a database from the Databases dimension. This simplifies…

    • over 3 years ago
    • Blogs
    • Performance Monitoring
  • Introduction to UI Queries in Foglight

    Darren Mallette
    Darren Mallette

    Think of a UI Query as a shortcut to data that you can use in a report, dashboard, service definition, etc. This post will show how to get started building queries. 

    The example today will be to get a list of all SQL Server Agent Jobs, regardless of the…

    • over 3 years ago
    • Blogs
    • Performance Monitoring
  • Expand your SQL Server monitoring coverage to include your BI stack with Foglight (3-Part Series) Part 3 – SQL Server Analysis Services (SSAS)

    David Orlandi
    David Orlandi

    Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.

    In this (Part 3) blog, the focus is SQL Server Analysis Services or ‘SSAS’.…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Expand your SQL Server monitoring coverage to include your BI stack with Foglight (3-Part Series) Part 2 – SQL Server Reporting Services (SSRS)

    David Orlandi
    David Orlandi

    Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.

    In this (Part 2) blog, the focus is SQL Server Reporting Services or ‘SSRS’.…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Expand your SQL Server monitoring coverage to include your BI stack with Foglight (3-Part Series) Part 1 – SQL Server Integration Services (SSIS)

    David Orlandi
    David Orlandi

    Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.

    In this (Part 1) blog, the focus is SQL Server Integration Services or ‘SSIS’…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • The Juggling Act of Modern DBAs

    The Juggling Act of Modern DBAs

    Dave B Awesome
    Dave B Awesome

    Database performance monitoring can be a real circus! And with an ever-growing amount of technology platforms to manage, we’ve become the ultimate jugglers.  

    Didn’t sign up to be a clown?

    Hey, I know. I didn’t, either. But, listen, sometimes…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • A General Guide to a Foglight for SQL Server Upgrade

    David Orlandi
    David Orlandi

    Understand that this is a general, high-level guide outlining the steps you should expect to take during a Foglight for SQL Server upgrade. Since environments and upgrade circumstances are often different, it is important to review and familiarize yourself…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Measuring the impact of changes on DB performance

    Amit Parikh
    Amit Parikh

    As the old saying goes, “the one constant in life is change”, and this is especially true in database environments.  There are many reasons why database environments experience change whether it be through typical maintenance efforts such…

    • over 5 years ago
    • Blogs
    • Performance Monitoring
  • Documenting your SQL Server inventory with Foglight

    Amit Parikh
    Amit Parikh

    As a DBA, you are responsible for many things, not to mention the ever changing landscape that is your database environment.  Documenting the server inventory is essential as it will come in good use when it comes to planning for a migration/upgrade,…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Checking When DBCC CheckDB Last Checked Your DB

    Checking When DBCC CheckDB Last Checked Your DB

    Darren Mallette
    Darren Mallette

     I had a customer ask how they could use Foglight to find out when "dbcc checkdb" last ran against their SQL Server databases.

    This is a great use case for User-Defined Collections!

    As a refresher, my colleague Trent Mera wrote a great blog on…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • How to Avoid Extinction in the Database Evolution

    Dave B Awesome
    Dave B Awesome

    Friends. Change is here. All of us DBAs are dealing with it. Look at the number of new database platforms. It’s relentless. They just keep coming. And we’re expected to take on any or all of them that’ll save our companies money. But it’s hard, right…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Integrate Foglight by Sending SNMP Traps

    David Orlandi
    David Orlandi

    Many customers ask how they might integrate Foglight Alarms into other 3rd party monitoring tools.  One way to accomplish this is to send SNMP traps in response to a Foglight alarm.

     

    To configure Foglight for this capability, you need to first download…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Diagnosing IO Latency with Foglight for Databases

    Trent Mera
    Trent Mera

    Understanding the processes and configurations causing your bottlenecks

    IO is the single most important metric to know for creating optimal performance of your database systems.  To understand it, you’ll need to know the processes, resources and configurations…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Foglight for DB 2017 Summary and Look to the Future

    Pini Dibask
    Pini Dibask

    What an exciting year it was for Foglight for Databases!

    Foglight for Databases had an amazing year, with several releases for the various Database Cartridges. Here are some of the highlights of what we’ve done in 2017:

    • Foglight for SQL Server…
    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Foglight for SQL Server: Back to Basics - Diagnosing Blocking

    Foglight for SQL Server: Back to Basics - Diagnosing Blocking

    Jason Hall
    Jason Hall

    I've done a number of posts recently that touch on Foglight administration, customization, or some of the more advanced capabilities of the product.  I felt it was a good time to circle back on some of the more basic use cases that Foglight can help…

    • over 4 years ago
    • Blogs
    • Performance Monitoring
  • Why is my Database Server Slow?

    Why is my Database Server Slow?

    Jason Hall
    Jason Hall

    We've all been there, the dreaded ticket that comes across our inbox.  Always light on detail, just a single sentence: "The database server is slow."  No five words bring as much fear, uncertainty and doubt to a DBA than those (well, maybe…

    • over 4 years ago
    • Blogs
    • Database Management
  • View related content from anywhere
  • More
  • Cancel
>
  • Company
    • About Us
    • Buy
    • Contact Us
    • Careers
    • News
  • Resources
    • Industry Insights Blog
    • Communities
    • Customer Stories
    • Documents
    • Events
  • Support
    • Professional Services
    • Renew Support
    • Technical Support
    • Training & Certification
    • Support Services
  • Social Networks
    • Facebook
    • LinkedIn
    • Twitter
    • YouTube
  • © 2021 Quest Software Inc. ALL RIGHTS RESERVED.
  • Legal
  • Terms of Use
  • Privacy
  • Community Feedback & Support
  • 会社名
    • 会社情報
    • 購入
    • お問い合わせ
    • 採用情報
    • ニュース
  • リソース
    • ブログ
    • お客様の事例
    • ドキュメント
    • イベント
    • ビデオ
  • サポート
    • プロフェッショナルサービス
    • サポートの更新
    • テクニカルサポート
    • トレーニングと認定資格
    • サポートサービス
  • ソーシャルネットワーク
    • Facebook
    • Instagram
    • LinkedIn
    • Twitter
    • YouTube
  • © 2021 Quest Software Inc. ALL RIGHTS RESERVED.
  • 「法務」
  • ご利用規約
  • 個人情報保護方針
  • コミュニティのフィードバックとサポート