Monitoring Intelligent Memory

Database
Enthusiast

Monitoring Intelligent Memory

Can anyone tell me how I can tell what columns to look at in DBQL and resusage to see how much of a benefit we are getting from intelligent memory, and which queries have been improved by using it?

Tags (1)
1 REPLY
Enthusiast

Re: Monitoring Intelligent Memory

Hi,

Resusage tables have most of the resource usage details of the system. For eg: ResUsageSpdsk has ReadCount, WriteCount, ReadResponse, WriteResponse, MigrateReadIO, MigrateWriteIO and more colums give details about HDD and SSD devices. Provided that TVS should be enabled in your system.

Thanks,

Dinesh