Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

Delphix Storage Usage Details: Snapshots and vDBs

  • 1.  Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-20-2020 05:56:00 AM
    Hi everyone,

    Is there anyway to get information about which snapshot is being used by which vDB or vDBs, from CLI, API, GUI?

    The above information could be quite useful specially when storage usage is going up to 70+ percents, vDBs are not refreshed for more than a month.


    ------------------------------
    BR,
    Rahim Cetinel
    Solution Architect | Delphix Blackbelt
    Accuras DMCC, Turkey
    ------------------------------


  • 2.  RE: Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-20-2020 05:01:00 PM
    Hi Rahim,
    Is this what you are looking for, sir?
    https://docs.delphix.com/docs/configuration/capacity-and-resource-management/an-overview-of-capacity-and-performance-information/using-and-understanding-the-storage-capacity-screen

    Let me know.
    Thank you,
    Michael

    ------------------------------
    Michael Torok
    Director of Knowledge and Community Management
    Delphix
    ------------------------------

    Original Message


  • 3.  RE: Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-21-2020 02:07:00 AM

    Hi Michael,

     

    Thanks for the link. That Delphix screen explains some of information but what I am asking is more details in that screen.

     

     

     

    The info at could be more detailed in a way that which snapshot is being used by which vDB can be seen (or maybe in another screen).

     

    This is useful mostly in Storage is more than 80% cases.

     

     

    BR,

     

    Rahim Cetinel

    Solution Architect | Delphix Blackbelt

    M:+905334112490  | Skype: rahim.cetinel

    www.accuras.com




    Original Message


  • 4.  RE: Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-21-2020 01:29:00 PM
    Hi Rahim,
    Thank you for the clarity. We have an idea in our backlog tracking the expansion of this information (IDEA-664). I will add you to it.

    Best,
    Michael

    ------------------------------
    Michael Torok
    Director of Knowledge and Community Management
    Delphix
    ------------------------------

    Original Message


  • 5.  RE: Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-22-2020 06:57:00 AM
    Michael, I would also like to see which snapshot is used by which VDB.  Please give my "thumbs up" for this idea.  

    Thanks!
    Sandy

    ------------------------------
    Sandy Ford
    Sr. SQL Database Administrator I
    United Fire Group
    ------------------------------

    Original Message


  • 6.  RE: Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-22-2020 08:41:00 AM
    Hello,

    You might try the "dxtoolkit" utility. It has a command called dx_get_capacity which can display these types of details:
    https://github.com/delphix/dxtoolkit/wiki/dx_get_capacity

    Scroll down to the last example for the one that displays all of the VDB's snapshots.

    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------

    Original Message


  • 7.  RE: Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-22-2020 10:18:00 AM
    I'll make sure you are mentioned, Sandy. Thanks!
    Also, if you feel comfortable using the CLI/API, take a look at what @Scott MacDonald mentions below. ​

    Thank you again,
    Michael

    ------------------------------
    Michael Torok
    Director of Knowledge and Community Management
    Delphix
    ------------------------------

    Original Message


  • 8.  RE: Delphix Storage Usage Details: Snapshots and vDBs
    Best Answer

    Posted 04-22-2020 08:57:00 AM
    Edited by Michael Torok 04-22-2020 10:15:16 AM
    Hi,

    While not easily found in the GUI (yet), you can indeed get this detail from either the CLI or API.
    It depends how you want to see it.

    For example, in the CLI to see the list of snapshots and which container(DB) they belong to:

    delphix> /snapshot list
    NAME                         CONTAINER LATESTCHANGEPOINT.LOCATION LATESTCHANGEPOINT.TIMESTAMP
    '@2020-04-21T10:32:25.597Z'  R2PDB1    71732974                   2020-04-22T10:33:03.000Z
    '@2020-04-21T10:31:40.978Z'  monterey  71732195                   2020-04-22T10:32:04.000Z
    ...
    '@2020-04-20T10:30:08.102Z'  vdb       29984581                   2020-04-21T10:30:49.000Z
    '@2020-04-20T10:30:08.657Z'  vvdb      29902981                   2020-04-21T10:30:49.000Z

    or to find the owner of a particular snapshot:

    delphix> /snapshot select '@2020-04-21T10:31:40.978Z'
    delphix snapshot ''@2020-04-21T10:31:40.978Z''> get container
    monterey

    or to get all the snapshots for one particular container(DB):

    delphix> /snapshot list database=ASE_VDB1
    NAME                        CONTAINER  LATESTCHANGEPOINT.LOCATION LATESTCHANGEPOINT.TIMESTAMP
    '@2020-04-15T03:29:37.593'  ASE_VDB1   -                          2020-04-15T10:29:37.593Z
    '@2020-04-16T03:29:30.190'  ASE_VDB1   -                          2020-04-16T10:29:30.190Z
    '@2020-04-17T03:29:30.816'  ASE_VDB1   -                          2020-04-17T10:29:30.816Z
    '@2020-04-18T03:29:30.130'  ASE_VDB1   -                          2020-04-18T10:29:30.130Z
    '@2020-04-19T03:29:30.206'  ASE_VDB1   -                          2020-04-19T10:29:30.206Z
    '@2020-04-20T03:29:28.503'  ASE_VDB1   -                          2020-04-20T10:29:28.503Z
    '@2020-04-21T03:29:25.493'  ASE_VDB1   -                          2020-04-21T10:29:25.493Z
    '@2020-04-22T03:29:25.426'  ASE_VDB1   -                          2020-04-22T10:29:25.426Z


    see also the "snapshot" endpoint in the API, which should provide the same info.

    If you mean you want to see which VDBs are pinning or holding which snapshots (and so are not getting deleted by retention), then you can do this via the "timeflow" endpoint, for example (sources obviously have no parent snapshot):

    delphix> timeflow list display=container,parentSnapshot
    CONTAINER  PARENTSNAPSHOT
    marina     -
    monterey   -
    R2PDB1     -
    vcdb       '@2020-04-20T10:31:51.048Z'
    vdb        '@2020-03-02T15:27:05.325Z'
    vvdb       '@2020-03-10T12:09:48.294Z'
    vmask      '@2020-03-02T15:27:05.325Z'
    vpdb       '@2020-04-20T10:32:50.193Z'
    SQL1       '@2020-03-28T07:00:00.000'
    SQLmask    '@2020-03-05T04:00:00.000'
    Macaroon   -
    Soda       -
    ASE_VDB1   '@2020-02-22T03:50:40.063'
    clippers   -
    Vfiles     -
    Vfile_vdb  '@2020-02-21T03:15:13.042'
    delphix>


    Hope that helps,

    Scott.

    ------------------------------
    Scott MacDonald
    Senior Member Technical Staff
    Delphix
    ------------------------------

    Original Message


  • 9.  RE: Delphix Storage Usage Details: Snapshots and vDBs

    Posted 04-23-2020 03:07:00 AM

    Hi Scott,

     

    Thanks a lot for the information. I will definitely check the CLI. I am assuming that "snapshot" related APIs will also reveal same or similar results. Probably we will write something calling Delphix APIs to generate a report.

     

     

    BR,

    Rahim Cetinel

    Solution Architect | Delphix Blackbelt

    M:+905334112490  | Skype: rahim.cetinel

    www.accuras.com




    Original Message


Related Content