Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.7.5.30 - User Guide

Managing SQL Server Database Systems Introduction to this Guide Using Foglight for SQL Server Monitoring Business Intelligence Services Administering Foglight for SQL Server Glossary Reference

Reviewing the Support Service Status

The Services Status panel includes panes that allow carrying out the following tasks:
•
Monitoring the Status of the Current Services — using the Services Status table, which allows viewing the current status of each SQL Server support service, as well as the exact time when this status was last changed.
•
Tracking the Service Status History — using the Service Status History chart, which displays the status of the support services over the last hour.
Monitoring the Status of the Current Services
The Services Status table, which displays the current status of each SQL Server support service, contains several parameters, as presented in the following table.
To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens.
 
 
Table 46. The Services Status table parameters.
Column
Description
State
The state of the SQL Server support service. The possible values are: Stopped, Paused, Running, Not Installed, Not Configured, and Configured.
State Changed
The time and date that the state of the service last changed.
Service
The SQL Server service name.
The support services monitored by Foglight for SQL Server are as follows:
•
SQL Server Agent
•
DTC
•
Full Text Search
•
OLAP Services
•
SQL Server Mail
•
Integration Service
•
Report Service
•
Browser Services
•
Writer Services
•
ADH Service
Tracking the Service Status History
The Service Status History chart displays the status of each SQL Server support service over time. This table allows viewing whether a service has been installed, and the exact times when each support service’s state was one of the following:
•
Stopped
•
Paused
•
Running
•
Not installed
•
Not configured
•
Configured
* 
NOTE: SQL Server Mail and SQL Agent Mail are not services and cannot be started or stopped. The Service Status History chart displays only their current configuration status.

Reviewing SQL Agent Jobs

The SQL Agent Jobs panel lists all of the currently defined SQL Agent jobs, highlighting their current status (running, succeeded, or failed). This panel also allows viewing the execution messages from the last run of each job.
In addition, the SQL Agent Jobs panel displays the status of each job over time, thereby providing the exact information about when a job ran and when it succeeded or failed.
This panel allows carrying out tasks described in the following topics:
•
Tracking the SQL Agent Jobs
•
Tracking Job Execution Messages
•
Viewing the SQL Agent Jobs History
Tracking the SQL Agent Jobs
The SQL Agent Jobs table lists all SQL Server Agent Jobs defined in this server. This table highlights the current status of each job (running, succeeded, or failed). This data is updated on demand.
IMPORTANT: To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens.
 
Table 47. The job state is indicated to the left of the job name.
Indication
Description
The job was never run.
The following indicators refer to jobs that were run:
Blue
The job run was cancelled.
 
Red
The job run failed.
Green
The job run completed successfully.
The job state depends on the last run outcome. For example: if the current status is Completed, but the last run outcome is Fail, the job is indicated by a red circle as a failed job.
 
Table 48. The SQL Agent Jobs table contains the following columns:
Column
Description
Job Name
The name of the job.
Job Category
The SQL Agent job category assigned to this job.
Enabled
Indicates whether the job is enabled.
Last Run Outcome
The result of the last run (Fail, Success, Retry, Cancel, or In progress).
Current Status
The current status of the job (Running, Completed, or Never Ran).
Curr Step #
If the job is currently running, displays the current step number.
Last Run Time
The date/time on which the job last ran.
Last Run Finish
The time the job was completed.
Last Run Duration
How long the last run took (displayed in the d hh:mm:ss format).
Next Run Time
The date/time of the next scheduled run.
Description
A brief description of the job.
Tracking Job Execution Messages
The Job Messages table displays the execution messages for each step in the current job. The data in the table is refreshed on demand. Historical data is not stored in a repository.
To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens.
 
Table 49. The Job Messages table displays the following parameters:
Column
Description
Time
The time the job or step started execution. For an In Progress history, this is the time the history was written.
Message
Displays an error message, if the current step in the job resulted in an error.
Step Name
The name of the step.
Run Status
The job execution’s status (Failed, Success, Retry, Canceled, or In progress).
Run Duration
Elapsed time in the execution of the job or step in seconds format.
Viewing the SQL Agent Jobs History
The SQL Agent Jobs History chart displays the status of jobs over time, thereby providing the exact information about when a job ran and when it succeeded or failed. The possible statuses are as follows:
•
Never Ran
•
Retrying
•
Running
•
Failed
•
Canceled
•
Success
When a job executes, Foglight for SQL Server adds it to this chart (Running), identifying the time it started.
When the job finishes, Foglight for SQL Server checks the completion status (Success or Failed) and changes the color of the job accordingly, to indicate when exactly a job started and ended.

Viewing SQL Agent Alerts

The SQL Agent Alerts panel lists all currently defined SQL Server Agent Alerts, highlighting the alert type and when it last occurred.
This panel also features a chart that allows tracking the occurrences of each alert over time.
The sections of this panel allow carrying out the tasks detailed in the following topics:
•
Tracking SQL Agent Alerts
•
Tracking Recent Alert Occurrences
Tracking SQL Agent Alerts
The SQL Agent Alerts table lists all SQL Server Agent alerts defined in this SQL Server instance.
This table highlights the type of alert (either Event Alert or Performance Alert), as well as how often the event has occurred, and the date and time of its last occurrence.
To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens.
 
Table 50. The SQL Agent Alerts table displays the following parameters:
Column
Description
Alert Name
The name of the alert that was raised.
Type
The type of alert.
Enabled
Indicates whether the alert is enabled.
Last Occurred
The time when the alert was last raised.
Count
The number of occurrences of the alert.
DBName
The name of the database where the alert was raised.
Description
The full text of the specified alert’s error message. This text is taken either from SQL Server or, for user-defined alerts, from the user-created message.
Tracking Recent Alert Occurrences
The Alert Occurrences chart shows when recent SQL agent alerts have occurred, and how many have occurred during the selected time range. The legend on the right indicates the types of alerts currently displayed in the chart.

Monitoring SQL Server Transactions using the DTC Panel

The DTC panel provides additional data on SQL Server transactions.
DTC (Distributed Transaction Coordinator) service is an integral component of Microsoft Windows (Windows 2003 and higher versions) and is also available as part of the SQL Server installation, if a previous version of Windows is used. For details, see glossary definition of DTC.
If the server to which Foglight for SQL Server is currently connected has more than one instance running, this panel provides data regarding all instances of SQL Server on the current computer, not only the instance currently under analysis.
 
Table 51. The DTC Details chart displays data on the following aspects of DTC performance:
Data Series
Description
Aborted Transactions
The number of distributed transactions that were rolled back.
Active Transactions
The number of currently active distributed transactions.
Committed Transactions
The number of distributed transactions committed per second.
In Doubt Transactions
Transactions that have passed phase 1 of the two-phase commit operation (have committed the local transaction), and are awaiting a response from the DTC to either commit or roll back (phase 2).
Response Time Average
The average of the full time (in milliseconds) it has taken a query (select 1, by default) to get from the application to SQL Server and back.
Transactions/sec
The number of distributed transactions performed per second.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating