Re: [ADSM-L] How to track transaction stats for TSMVE backups?

At the risk of being excessively optimistic, it might. 

If they're taking flat-file backups, would that stop if they have faith in the 
TDP backing up their data for them, regardless of how it happens? 

If they stop taking the flat file backups, that should reduce the churn rate 
some. It wouldn't be a huge reduction in the churn rate, but it might be worth 
experimenting with. 

Admittedly, some DBAs will always trust what they can see, files in their file 
system, more than some amorphous backup system, but in some shops, it might 
work.

Nick

On Sep 27, 2013, at 10:53 AM, "Prather, Wanda" <Wanda.Prather AT ICFI DOT COM> 
wrote:

> AFAIK, all that does is let the VE backup VSS snap also truncate the logs.
> But won't help with the change rate.....
> 
> Thanks!
> W
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of Nick Laflamme
> Sent: Friday, September 27, 2013 11:50 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups?
> 
> Remember that the 6.4 TDP for SQL Server is VE aware, or so I've read.
> 
> Just a thought,
> Nick
> 
> On Friday, September 27, 2013, Prather, Wanda wrote:
> 
>> In my case it appears to be DB related, lots of small (over 100) SQL DB's.
>> With the combination of the DB's, plus the DBA's (reasonably) 
>> creating maintenance plans which write flat-file backups of the DB's onto 
>> the same
>> VM's, with the VM's coming from wholesale P-to-V conversions.   Think the
>> solution is moving the SQL DB's onto a couple of big dedicated SQL 
>> servers, but that's mostly for future implementations; gotta just live 
>> with the history we've inherited for now.  ... And I just stumbled 
>> onto an Oracle DB I didn't know was out there....  sigh.
>> 
>> W
>> 
>> -----Original Message-----
>> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU 
>> <javascript:;>] On Behalf Of Hans Christian Riksheim
>> Sent: Friday, September 27, 2013 6:53 AM
>> To: ADSM-L AT VM.MARIST DOT EDU <javascript:;>
>> Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups?
>> 
>> We also see a high change rate and we think the reason for that is the 
>> Windows pagefile. Some trickery to exclude that would be welcome but 
>> since this is block based I guess it is not possible.
>> 
>> Hans Chr.
>> 
>> 
>> On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon 
>> <erwann.simon AT free DOT fr<javascript:;>>
>> wrote:
>> 
>>> See that page and search for reporting enhancement :
>>> 
>>> https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wi
>>> ki 
>>> /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20
>>> Vi
>>> rtual%20Environments
>>> 
>>> 
>>> 
>>> "Prather, Wanda" <Wanda.Prather AT icfi DOT com <javascript:;>> a écrit :
>>>> DID NOT KNOW THAT!!!!!
>>>> 
>>>> Thanks MUCH!!!
>>>> Should take care of it.
>>>> 
>>>> -----Original Message-----
>>>> From: Erwann Simon [mailto:erwann.simon AT free DOT fr <javascript:;>]
>>>> Sent: Thursday, September 26, 2013 2:00 PM
>>>> To: ADSM: Dist Stor Manager; Prather, Wanda
>>>> Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups?
>>>> 
>>>> Hi Wanda,
>>>> 
>>>> If your server is at 6.3.3 or higher, there's a new 
>>>> summary_extended table you can select against. See sub_entity 
>>>> column that reports the vmname, so you can distinguish by VM.
>>>> 
>>>> Erwann
>>>> 
>>>> 
>>>> "Prather, Wanda" <Wanda.Prather AT ICFI DOT COM <javascript:;>> a écrit :
>>>>> I'm getting about 3 TB per day of VE backups.
>>>>> Something isn't right, it's a much higher change rate than I expected.
>>>>> 
>>>>> So I want to know how much each VM is sending every night, figure 
>>>>> out who the offenders are.
>>>>> I can get the occupancy from the filespace, but I'm interested in 
>>>>> transmission stats, not total storage.
>>>>> 
>>>>> With > 200 VM's, digging it out of the dsmsched.log is 
>>>>> non-trivial, same for activity log.
>>>>> Summary table has info for the data mover node only, doesn't show 
>>>>> the VM name.
>>>>> 
>>>>> Before I reinvent the wheel by writing a log parser, has anybody 
>>>>> found
>>>> 
>>>>> a better way?
>>>>> Anybody submitted an RFE for this already?
>>>>> 
>>>>> Thanks
>>>>> 
>>>>> Wanda Prather  |  Senior Technical Specialist  |
>>>> Wanda.Prather AT icfi DOT com <javascript:;>
>>>>> |  www.icfi.com
>>>>> ICF International  | 401 E. Pratt St, Suite 2214, Baltimore, MD
>>>>> 21202
>>>> |
>>>>> 410.539.1135 (o)
>>>> 
>>>> --
>>>> Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
>>> 
>>> --
>>> Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
>>> 
>>