Configuring Teratrax Performance Agent
The user interface for Teratrax Performance Agent consists of the
following tabs:
Monitoring Tab
The Monitoring tab allows you to specify which SQL Server instance
you want to monitor and configure monitoring thresholds for slow SQL
code, SQL Server blocks, and SQL Agent jobs.
- Instance Name: The Instance Name specifies which SQL Server
instance is monitored. To change the monitored instance, click the
Change button and enter a new instance name in the
Server Configuration dialog.
- Authentication: Indicates whether Teratrax Performance
Agent is using SQL Server authentication or Windows authentication to
connect to the instance. Windows authentication can only be used on
local instances and the instance name must start with "(local)".
Authentication can be changed from the
Server Configuration dialog.
- Monitor This SQL Server Instance: Check this box and
click Apply to start monitoring the specified SQL Server instance. To
stop monitoring, simply uncheck the box and click Apply. Configuring
the SQL Server instance name and authentication alone does not start
monitoring.
-
Capture all SQL code that take longer than x
milliseconds to run: Check this box if you want Teratrax
Performance Agent to trace slow performing SQL batches and RPC events.
You can also specify the minimum duration required for collected batches or RPC
events. You can set the duration to 0 to collect all
SQL batches and RPC events. However, Teratrax recommends a value of
3000 ms or higher on a SQL Server instance with a high volume of
transactions. Stored procedure calls are either reported as RPC events
or batch events depending on the way they are called from client
applications.
- Capture SQL Server blocks that exceed x millisecond: Check
this box if you want Teratrax Performance Agent to monitor SQL Server
blocking events. You can also specify the minimum duration required
for a block to be captured.
- Capture Agent jobs that fail or take longer than x seconds to
run: Check this box if you want Teratrax Performance Agent to
monitor SQL Server Agent jobs that fail or take a long time to
execute.
- Defaults: Click this button to reset all default settings.
Once you complete all the necessary configurations, click Apply for
the changes to take effect.
Alerts Tab
The Alerts tab allows you to configure the Outgoing Mail Server
(SMTP) and the Server Down Alert. Teratrax Performance Agent uses the
SMTP server specified to send out Server Down Alerts and other alerts
created and managed from
Teratrax Performance Viewer.
- Outgoing Mail Server (SMTP): Used by Teratrax Performance
Agent to send out e-mail alerts.
- SMTP Server: The SMTP server name (Example:
mail.domain.com).
- Port: The port used by the SMTP server.
- User Name: The login for SMTP authentication. Usually,
this is either an e-mail address or the first part of an e-mail
address. E-mail alerts received by end users indicate
that they are sent from this account.
- Password: The password used for SMTP authentication.
Teratrax Performance Agent does not support SMTP server that
require encrypted connections (SSL).
- Server Down Alert: An e-mail alert that notifies you if SQL
Server stops responding.
- Send me an e-mail alert when this server instance stops responding:
Check this box if you want to receive an e-mail message notifying
you that the SQL Server instance is not responding.
- E-mail: E-mail alerts are sent to this e-mail address
from the SMTP user name indicated in the "Outgoing Mail Server
(SMTP)" section. This can be any valid e-mail address.
- Send Test E-mail: Click this button to send a test e-mail
to the specified e-mail address.
Teratrax Performance Agent sends an e-mail alert every hour until
the server starts responding again.
Verify SMTP: Click this button to verify SMTP
configuration.
Once you complete all alert configurations, click Apply to save all changes.
About Tab
Displays the Teratrax end user agreement and licensing information. |
