カテゴリ
製品バージョン
トピック
サブトピック
How to include and exclude databases in ApexSQL Monitor (4214741)
Description After adding a SQL Server instance in ApexSQL Monitor, all databases present in that instance will be included for monitoring, by default. ... Users can narrow a database list to a specified group or even to a single database.
How to add servers to ApexSQL Monitor (4214774)
To monitor an SQL Server instance, it has to be added manually. ... Select a local SQL Server instance from the Server drop-down list, authentication type, and enter the credentials ... Q: Are there any permissions required to add a local SQL Server instance?
ApexSQL monitoring tools alerts (4293555)
This article explains how to manage alerts in ApexSQL Monitor. ... This article explains how to manage alerts in ApexSQL Monitor. ... Description ... Alerts notify you about potential and ongoing performance issues with your machines, virtual machines, SQL Server instances, SQL Server services, databases and many more.
Purging repository data (4214752)
This article explains what repository data purging is, how to use it in ApexSQL monitoring tools, when and how it should be configured, what are the benefits that can be gained, and how it behaves in the background
Monitoring AlwaysOn Availability Groups (4211470)
Summary This article explains explain how to use ApexSQL Monitor AlwaysOn monitoring which will provide quick insight into the state of an AlwaysOn high availability environment. ... The graphically presentation of the high availability AlwaysOn environment allows users to visually ascertain the status of the Windows Server Failover Cluster nodes as well as the status of SQL Server AlwaysOn replicas.
ApexSQL Monitor ad hoc reporting Helper functions (inventory, descriptions and examples) (4214458)
This article shows the helper functions needed for ad hoc reporting including what each function is, why the function is needed, when each function should be used and how those functions should be used
How to create custom SQL Server performance reports – Part 2 (alerts, Indexes and databases) (4211435)
In the Part 1 of the article, functions and examples of reporting on performance metrics and status metrics were presented. ... In this article, the functions and examples of the reports for indexes, database status and alerts will be shown.
How to add AlwaysOn Availability Groups for monitoring (4216064)
Adding AlwaysOn Availability Groups in ApexSQL Monitor is done via the AlwaysOn listener, and this application will provide a complete overview of the AlwaysOn Availability Group topography including the Windows Server Failover Cluster (WSFC), but also all availability replicas of the other AlwaysOn Availability Groups that are sharing the same SQL Server instance replicas.
How to use and interpret the SQL Server Activity monitor (4214401)
How frequently are the Activity monitor charts refreshing in the Instance dashboard? ... How can I access more detailed information about the current SQL Server activity? ... How is the activity monitor data classified?
How to configure ApexSQL Monitor SSL web access (https) manually (4213483)
Summary ... This article provides information about configuring SSL after the installation of ApexSQL Monitor to allow secure access to web server. ... Description ... The ApexSQL Monitor service is designed to work with SSL, but ApexSQL doesn’t provides any self-signed certificate.
Working with email notifications and email profiles in ApexSQL monitoring tools (4211091)
Description ... All ApexSQL monitoring tools can be set to send an email whenever an alert is raised or summary emails in regular intervals for alerts raised during that interval. ... Email notification behavior is fully configurable and all monitoring tools can be set to:
ApexSQL Monitor licensing (4214766)
In other words, if you have a machine with 3 SQL Server instances to monitor or you have 3 separate SQL Servers all with one instance, you’ll need 3 ApexSQL Monitor licenses. ... Q: How does licensing work in clusters?
Using and scheduling SQL Server performance monitoring reports (4216146)
ApexSQL Monitor uses SQL Server performance reports as an essential feature for analysis of contemporary and historical SQL Server performance data. ... ApexSQL Monitor collects and keeps performance data into a repository database for a time frame defined by the retention policy that can be set by the user.
How to configure and use deadlock monitoring (4218941)
This article provides information on how ApexSQL Monitor can be used for investigation of SQL Server deadlocks, as well as how and what diagnostic data it collects to diagnose and troubleshoot occurred deadlocks.
Performance metrics quick guide (4214916)
ApexSQL Monitor incorporates system, SQL Server and database performance metrics, along with specific sets of metrics related to wait statistics, indexes and AlwaysOn SQL Server configuration. ... Also, it allows user to add custom metrics, as well.
How to calculate baseline for less than seven days of historical data (4214775)
Summary ... This article describes how to enable the option for advanced users to calculate baselines for less than seven days period. ... Description ... The proper baseline calculation requires at least seven (7) days of data to be sufficiently accurate and reliable.
How to use custom SQL script alerts in ApexSQL Monitor (4289910)
Summary ... This article explains how to use the custom SQL script alert action in ApexSQL Monitor, use the preset action tags in a script and test it, including examples of a few SQL scripts to use to assist in performance monitoring.
ApexSQL Monitor installation terms, definitions, and network topography (4298324)
Summary ... This article provides information about ApexSQL Monitor installation terms and offers a visual overview of a topography of installed components. ... Description ... ApexSQL Monitor is a web-based application that will install necessary components unattended during the installation process.
How to create and schedule maintenance periods in ApexSQL Monitor (4214904)
Summary ... This article explains how to create and set up maintenance periods to disable measuring and alerting for a particular SQL server. ... Description ... ApexSQL Monitor is a monitoring tool that enables users to monitor the performance of a database, SQL server, host system, and to alert users to potential bottlenecks or problems.
How to use custom command alert actions in ApexSQL Monitor (4214610)
This article shows how to utilize the Create command functionality, how to include the action tags within a command line and perform command testing in ApexSQL Monitor. ... Description ... The Create command functionality, as part of ApexSQL Monitor’s alert actions feature, allows executing custom commands including Windows Shell, PowerShell, .bat and .ps1 files etc., when alerting events occur.
Organizing monitored servers into groups (4216303)
This article explains explain how to group servers with similar properties to allows displaying an overview of the servers in the group, filtering alerts by the group, and configuring alert or measurements settings for all servers in the same group at once
How to set up SMS alert notifications in ApexSQL Monitor (4211695)
This article explains how to set up custom SMTP and email profiles to send SMS alert notifications using the ApexSQL Monitor alert action feature, including necessary requirements. ... Description
How to configure ApexSQL Monitor (4214783)
This article provides information on how to properly configure ApexSQL Monitor including the configuration of metrics, alert parameters and maintenance periods ... Description ... Configuring metrics – By clicking the Configure link in the main menu, the configure page will be displayed.
ApexSQL Monitor setup and configuration: best practices, recommendations and options (4213470)
Summary ... This article provides information about the best practices for ApexSQL Monitor installation, configuration, and usage for the most optimal performance monitoring, application performance and minimal overhead on monitored servers.
Using the query waits feature (4214841)
The Query waits feature is the core ApexSQL Monitor feature and, in most cases, the first step in resolving SQL Server performance issues. ... Query wait statistics, somewhere referred to as the Response Time Analysis (RTA), is for many less experienced or new DBAs the most complicated part of performance troubleshooting.
製品の新しい関連付け
- セルフ・サービス・ツール
- ナレッジベース
- 通知および警告
- 製品別サポート
- ソフトウェアのダウンロード
- 技術文書
- ユーザーフォーラム
- ビデオチュートリアル
- RSSフィード
- お問い合わせ
- Technical Support
- すべて表示