Generating Netbackup throughput data reports

If you support Netbackup at your site, I’m sure you’ve had to look into issues with slow clients and failed backups. The nbstatus script I mentioned in a previous post is useful for identifying connection problems, but it doesn’t help you understand how well your clients are performing. To help me understand how much data my clients are pushing, I wrote the nbthroughput shell script:

$ nbthroughput

Top 5 hosts by data written

Policy                Schedule              Storage Unit     Bytes       Bytes/s
--------------------  --------------------  ---------------  ----------  -------
ZeusFileSystem        Full-Quarterly        med01-hcart3-    9199683296  39376
VMWareMBackups        Full-Weekly           med01-hcart3-    1756762304  84219
VMWareBackups         Cumulative-Increment  med01-hcart3-    1035153514  34155
VMWareBackups         Cumulative-Increment  med01-hcart3-    879121280   68009
ApolloFileSystem      Full-Weekly           med01-disk       771900576   19919  

Fastest 5 clients (processed 10MB+)

Policy                Schedule              Storage Unit     Bytes       Bytes/s
--------------------  --------------------  ---------------  ----------  -------
Oracle01FileSystem    Differential-Increme  med01-hcart3-    3609248     128365
App01FileSystem       Differential-Increme  med01-hcart3-    3569984     128250
Web01FileSystem       Differential-Increme  med01-hcart3-    3550592     126423
VMWareBackups         Cumulative-Increment  med01-disk       335576832   100559
ZeusFileSystem        Default-Application-  med01-disk       104857632   93847

Slowest 5 clients (processed 10MB+)

Policy                Schedule              Storage Unit     Bytes       Bytes/s
--------------------  --------------------  ---------------  ----------  -------
W2k3-1FileSystem      Differential-Increme  med01-disk       1298912     333
W2k3-2FileSystem      Differential-Increme  med01-disk       1482752     2000
W2k3-3FileSystem      Differential-Increme  med01-disk       1095936     2083
W2k3-4FileSystem      Differential-Increme  med01-disk       4114880     2425
W2k3-5FileSystem      Differential-Increme  med01-disk       3496576     2483

The script will display the fastest clients, the slowest clients, and how much data your clients are pushing to your media servers. I find it useful, so I thought I would post it here for others to use.

5 Comments

Kiran  on January 8th, 2010

Wow, what a wonderful script. I’m looking exactly for this script on a windows environment and i dont quite understand the scripting mentioned here. i got upto bpdbjobs – report, which lists everything but throughput. could u please guide me?

Kiran  on January 9th, 2010

hi, could you please reply to my e-mail id? I really would like to use it in the windows environment now. please please please…

Andrew  on March 25th, 2010

Can you also please post the file you use to select the columns that “bpdbjobs -report” outputs?

jv711  on May 21st, 2010

what version of netbackup are you using? The 2nd and 3rd block, (fastest and slowest clients) is not working for me under ver 6.0

When I mess with bpdbjobs -report, I don’t have an 11th and 12th field with bytes written, and -all_columns, -most_columns, and -gdm doesn’t seem to give me what I want. Any clues???

matty  on May 26th, 2010

I think i figured out what is going on. To get the script to work the way it’s shown above, you will need to add the following configuration directives to your bp.conf:

BPDBJOBS_COLDEFS = JobID 1 true
BPDBJOBS_COLDEFS = Type 1 true
BPDBJOBS_COLDEFS = State 1 true
BPDBJOBS_COLDEFS = Status 1 true
BPDBJOBS_COLDEFS = Policy 1 true
BPDBJOBS_COLDEFS = Schedule 1 true
BPDBJOBS_COLDEFS = Client 1 true
BPDBJOBS_COLDEFS = DstMedia_Server 1 true
BPDBJOBS_COLDEFS = DSTSTORAGE_UNIT 1 true
BPDBJOBS_COLDEFS = Elapsed 1 true
BPDBJOBS_COLDEFS = Kilobytes 1 true
BPDBJOBS_COLDEFS = KbPerSec 1 true
BPDBJOBS_COLDEFS = Files 1 true

This will tell bpdbjobs to spit out a bit more data than it normally does.

Thanks,
- Ryan

Leave a Comment