Page History

AppDynamics for Databases can be configured to collect CPU consumption metrics from the monitored host. Host monitoring is not supported for the Microsoft SQL Azure Database platform.

AppDynamics for Databases supports Windows, Linux, and Solaris and gathers granular data on server performance, includingwhich displays on the following Server tabs:

• Inventory tab: Server properties such as CPU architecture and speed, Physical Memory, OS version etc.
• Procs tab: Remotely view processes on your monitored servers
• Activity tab: CPU and memory consumption, and disk queue length
• CPU Monitoring
• Physical Memory Usage
• Disk I/O - tab: Read IOPS, Write IOPS, Read Throughput MB/sec, Write Throughput MB/sec, Average Disk Queue LengthLength 
• Network I/O - kBtab:  kB/sec Sent and Received, TCP send/receive errors
• Server Inventory Screen - Server properties such as CPU architecture and speed, Physical Memory, OS version etc.
• Top Processes Screen - remotely view process information on your monitored servers

An example of these metrics can be seen in the CPU Consumption Over Time chart as shown below.

Image Removed

To see server metrics, in the Monitored Infrastructure section of the Main Menu, click Server.

Note: To enable the Host Collector for database servers only, on the Add Collector or Edit Collector Configuration pages you must click the Monitor OS? checkbox and enter details of OS Type and Hostname (or IP address.)

Collecting Information from Linux and Solaris

AppDynamics for Databases can monitor Linux or Solaris from any of its supported platforms.

To collect OS metrics from Linux or Solaris, the AppDynamics for Databases Host Collector makes an ssh connection to the monitored host to gather information using standard commands. For the AppDynamics for Databases collector to successfully collect information, the monitored host must support ssh connections, and the AppDynamics for Databases Host Collector must have a hostname, username and password defined.

Collecting Information from Windows

AppDynamics for Databases can only monitor Windows from a Windows platform.

...

Using Windows Authentication to Monitor SQL Server

...

1. When creating a collector on the Collector Setup page, do not specify a username and password.

...

1. Configure the AppDynamics for Databases windows service to log on as the desired windows account with SQL Server access.

   ...

   1. 1. Go to the Windows Services UI from Control Panel. Select the AppDynamics for Databases collector service and right click to display the properties.

   ...

   1. 1. Click Log On and then enter the credentials for the user.

   ...

   1. 1. Click OK, and then try starting the collector either from the services panel or from the Collector Administration page

   ...

   1. Repeat the above process for the AppDynamics for Databases GUI Windows Services.

   The AppDynamics for Databases GUI windows service also needs to be configured to log on as the desired windows account with SQL Server access; this is because to display some windows within AppDynamics for Databases, such as the Current window and the Objects window, the UI process needs to make a direct connection to the monitored SQL Server to request information.

   If you are running AppDynamics for Databases on Linux then you must use SQL Server authentication.

   Required NetApp Permissions

   For complete AppDynamics for Databases functionality in a NetApp environment, the NetApp Metric Collector needs access NetApp API access. Depending on your environment, clustered or non-clustered, see the following topics:

   ...

   See also Map NetApp Volumes to Databases.

   NetApp OnTap 7mode Permissions

   Here is an example user creation script if you would like to create a new dedicated user for AppDynamics for Databases with relevant privileges:

   Code Block
   useradmin role add Appd4db_Role -a api*,login-http-admin useradmin group add Appd4db_Group -r Appd4db_Role useradmin user add appd4db -g Appd4db_Group

   Required NetApp Clustered Data OnTap Permissions

    Here is an example user creation script if you would like to create a new dedicated user for AppDynamics for Databases with relevant privileges:

   ...