How can I get statistics on database usage?

  • 0
  • 1
  • Question
  • Updated 3 years ago
I want to see what VDBs are unused or rarely used. Is there a way I can get Delphix to display usage statistics?
Photo of Thom T

Thom T

  • 838 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Srish Sriram

Srish Sriram, Employee

  • 1,280 Points 1k badge 2x thumb
Hi Thom,

You may find the Dashboard view useful. You can access the Dashboard through the Resources menu on your Delphix Admin application. The Dashboard contains several panels with detailed performance information. One panel you may find useful is Performance Management, which shows VDB network usage. You can use this information to determine how frequently your VDBs are being used.

You can find more information on the Dashboard at our help article "An Overview of Capacity and Performance Information". I hope this helps. Please let me know if you have any questions or issues.

Thanks,

Srish
Photo of Joey Dobias

Joey Dobias, Employee

  • 430 Points 250 badge 2x thumb
If your question is more about actual RDBMS level usage such as whether users are logging and and actively working with a specific VDB, then the answer is no.

Since the Delphix Engine is a storage appliance, as Srish says, we store and can display a lot of information about storage utilisation in the Dashboard (and also in the Capacity Management screen). However, to find out how often users are logging into a particular VDB you need to use whatever admin tools you normally would for that RDBMS (be it MSSQL, Oracle, ASE admin tools, queries, and commands).