top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the most important database performance metrics, and how do you monitor them?

+4 votes
1,636 views
What are the most important database performance metrics, and how do you monitor them?
posted Feb 12, 2015 by Merry

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes
 
Best answer

There are many important metrics, termed “key performance indicators”, that allow you to evaluate the health of more server more or less correctly.
Requests per Second (RPS).
Error Rates.
Average Response Times (ART).
Peak Response Times (PRT).
Uptime.
CPU utilization.
Memory utilization.
The Count of threads.
The Count of Open Files Descriptors.
For more Information http://blog.monitor.us/2012/09/essential-server-performance-metrics-you-should-know-but-were-reluctant-to-ask/

answer Feb 12, 2015 by Vrije Mani Upadhyay
Similar Questions
+2 votes
How to do database testing by using automation tool?

How to check runtime database checkpoints. i want to check that wheather the current record is added in database table after execute the adding a record?

+1 vote
How to convert multiple rows into single row in iformatica for large volume of data, need best solution

I have data in table A as below

Assetid   attribute   value
    1546    Ins_date   05062011
    1546    status     active
    1546    X          10.4567
    1546    Y          27.56
    1546    size       17
    675     X          4.778
    675     Y          53.676
    675     depth      5
    675     st_date    06092010

I have data as above in table A. This table has many Assetids 1546,675,....etc. attributes might vary for assets.

I want output as below:

assetid  ins_date  status  X        Y       Size  depth  st_date
1546     05062011  active  10.4567  27.56   17    null   null
675      null      null    4.778    53.676  null  5      06092010

I have created Stored procedure, then called in Informatica to achieve this output. However, since i have large volume of data, it is taking much time to load.

Please suggest me other easy and best way to load it.

...