OnDemand User Group

Support Forums => MP Server => Topic started by: jsquizz on October 08, 2019, 07:55:17 AM

Title: Determining metrics for specific application?
Post by: jsquizz on October 08, 2019, 07:55:17 AM

got a requirement from our application team to figure out-

Application XYZ, which is part of AG 123, takes up XXX GB in TSM.

Does anyone have a query handy, or something to determine this. I have a feeling it will require some fancy footwork behind the scenes to do this.

Title: Re: Determining metrics for specific application?
Post by: Justin Derrick on October 08, 2019, 07:41:05 PM

By AG, this is relatively straightforward.  By Application...  This is a nightmare.  :D

-JD.

Title: Re: Determining metrics for specific application?
Post by: jsquizz on October 09, 2019, 07:34:37 AM

Quote from: Justin Derrick on October 08, 2019, 07:41:05 PM

By AG, this is relatively straightforward.  By Application...  This is a nightmare.  :D

-JD.

If this was AG, it would have already been done.

I'm probably going to take a dump of ALL 87's from the system log for a particular application load, throw it into excel...

Then look at log entries for "deletes", throw them into excel...

I've found it quite easy to gather metrics and info this way. It sure beats having to have my operations team run queries in prod, especially since I'm the only one that knows the relationships of the tables.