Paul,

The metrics displayed by Q AUDITOCC are updated by AUDIT LICENSE; not in real 
time.

..Paul
(sent from my iPhone)

On Jul 26, 2016, at 9:37 PM, Paul_Dudley <pdudley AT ANL.COM DOT 
AU<mailto:pdudley AT anl.com DOT au>> wrote:

To keep track of our primary storage usage, on a weekly basis I run the 
following command:



query auditocc pooltype=primary



For one of the nodes - an SQL server - it is reporting that the backup storage 
used is 7Tb.

However knowing the size of the databases on that server and the number of 
copies of each backup we keep, I believe that to be incorrect.

I started the DP for SQL client on that server, clicked on Restore Data, and 
then selected all backups (both active and inactive).

I then added up the size of each backup (both active and inactive) and it added 
up to 2.2Tb.



How could there be such a huge difference between each total?





Thanks & Regards

Paul Dudley

IT Operations

ANL Container Line

pdudley AT anl.com DOT au<mailto:pdudley AT anl.com DOT au>








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add
ressees. Any unauthorised dissemination or use is strictly prohibited. If you 
received
this e-mail in error, please immediately notify the sender by return e-mail 
from your s
ystem. Please do not copy, use or make reference to it for any purpose, or 
disclose its
contents to any person.