How to Identify Netezza Server I/O Usage using System Views?

  • Post author:
  • Post last modified:February 26, 2018
  • Post category:Netezza
  • Reading time:2 mins read

You may have to query Netezza system tables or views to get information about system, for example, to identify Netezza server I/O Usage.

These kind of information will help you to manage Netezza server and databases. As a server maintenance activity, you may have to regularly to identify Netezza Server I/O and monitor regularly to minimize the performance degrade.

Identify Netezza Server I/O Usage using System Views

Below query provides the Netezza I/O usage i.e. identify read and write details on Netezza disks.

select cast(START_TIME as date) as startDate,
 cast(END_TIME as date) as endDate,
 SUM( HOST_DISK_READ_SECS + HOST_DISK_WRITE_SECS + 
 HOST_FABRIC_SECS + SPU_DISK_READ_SECS + SPU_DISK_WRITE_SECS + 
 SPU_FABRIC_SECS + SPU_DATA_DISK_READ_SECS + 
 SPU_DATA_DISK_WRITE_SECS + SPU_TEMP_DISK_READ_SECS + 
 SPU_TEMP_DISK_WRITE_SECS ) as TOTAL_READ_WRITE_IN_SECS
from _V_SCHED_GRA_EXT
group by 1,2
--limit 10;

 STARTDATE | ENDDATE | TOTAL_READ_WRITE_IN_SECS
------------+------------+--------------------------
 2017-11-14 | 2017-11-14 | 0
(1 row)

Read:

 

 

Tags: