DX Application Performance Management

Hi,

Can we we monitor SQL Database availability in Wily
directly or using some script or using plugin. Do we have a PowerPack for MSSQL Database?


Thanks in Advance.

Warm Regards,
Shajada RAO

Hi,

With respect to above question !!!

Can we able to monitor MySql and Postgres databases ? because we have some important applications with backend as MySql and Postgres DB.

is there any powerpack for the same?

@Shajada - let me know your email id so that we can help each other to resolve such kind of questions directly.

Thanks & Regards,
Nikhil Kalwint

Hi Nikhil,

My email id is rao.shajada@gmail.com.

Regards,
Shajada Rao

This is from the CA APM Overview Guide:

>
Introscope integration with CA Insight Database Performance Monitor (DPM)

CA Insight Database Performance Monitor (DPM) is a product that enables you to centrally monitor and manage performance on a distributed relational database management system (RDBMS), simplifying management across databases, vendors, and operating system environments.

With CA Insight DPM, you can easily view the overall health of your database infrastructure across the entire enterprise. This allows you to quickly identify, diagnose, and solve the root cause of your database performance issues before they impact business critical processes.

Integration features
CA Insight DPM delivers key performance and database health information directly into Introscope
Provides you with CA Insight DPM metrics and out-of-the-box dashboards in Introscope
Includes metrics and dashboards for DB2 Linux, UNIX and Windows, SQL Server, Sybase, and DB2 for z/OS (when CA Insight for DB2 for z/OS is installed)
The integration component, called the Insight Bridge for Introscope, provides additional database vendor support, database metrics, and additional dashboards in Introscope


Please contact your Pre-Sales team for details.

-Hiko

Please mark your question as "resolved" if we've answered your question.

But we can not monitor MySQL and PostGres database using insight database....

So thought of ...we could done it throu CA Wily...

I would probably look to model something similar to the PPK where you would setup EPAgent to poll your SQL server for statistics every XX seconds or minutes.

Here's a webpage I found that has a list of potential counters for MS SQL you may want to poll for: http://www.mssqltips.com/sqlservertip/1265/sql-server-database-specific-performance-counters/

Obviously, some of the counters will change depending on the version.