Evidence the Single instancing

Here is an example of a simple test that you can do.

Create 3 users.

Make them all enabled for archiving.

Login as 1 user, and send a 3 Mb PDF file to the other two users in a single email.

Run the archiving task against the 2nd user (ie the first recipient).

Observe what is written to the Vault Store Partition

Run the archiving task against the 3rd user (ie the second recipient)

Observer what is written to the Vault Store Partition

Assuming you're talking EV 8 or higher, you'll see exactly what OSIS is all about.

Hello Vishal,

This technote provides more details about Single Instance Storage:

About single instance storage
http://www.symantec.com/docs/HOWTO57156

Once you get familiar with the process, it will be more easy to understand and set it up on your environment.

I hope this helps.

You can also run this query that will show you the Extension type of a file, how many physical SIS parts exist (DVSSP files) and how many savesets refer to that SIS Part

So you might see something like 

*.xls | 5774886 | 10132845 | 1871681

This means that Excel Spreadsheets have 5,774,886 DVSSP files
but there are 10,132,845 references that point to those Excel files. which means its saved the environment 5 million extra Excel files from having to be stored

And the total size is 1,871,681MB (about 1.87TB of data)

SELECT FS.FileTypeExtension "Extension",
       FT.TotalStoredSISParts "SIS Parts",
       FT.LogicalSISParts "SIS Part References",
       FT.TotalStorageSize/1024/1024 "Storage Size (MB)"
FROM   EnterpriseVaultDirectory.dbo.FileSpecification FS,
       EVVSYourVaultStoreGroup_2_2.dbo.FileTypeSummary FT
WHERE  FT.Type = FS.FileTypeIdentity
ORDER BY "SIS Parts" DESC

Hi,

I tried to run command :

SELECT FS.FileTypeExtension "Extension",
       FT.TotalStoredSISParts "SIS Parts",
       FT.LogicalSISParts "SIS Part References",
       FT.TotalStorageSize/1024/1024 "Storage Size (MB)"
FROM   EnterpriseVaultDirectory.dbo.FileSpecification FS,
       EVVSYourVaultStoreGroup_2_2.dbo.FileTypeSummary FT
WHERE  FT.Type = FS.FileTypeIdentity
ORDER BY "SIS Parts" DESC

Output comes blank , there was no value.It means single instancing not working ?
 

Its more likely than not that you just dont have SIS turned on at all OR you are using a Centera or ATMOS which doesn't use EV's OSIS, isntead EV just lets the Centera take care of the Single instancing

Let me brief you about enviornment , we have runing EV 10.0.3 with HCP and we have done comression on HCP and SIS enable on EV Share vault store within Group. when we run the SQL query its how no vaule.

Now we would like to now how to find Single instance evidance its working properly.

Thanks

Vishal,

SIS is not retroactive. That means that if you already had data archived and after a while (weeks, months, etc.) you enabled SIS, the data that was already archived will not have SIS applied. Also, if Enterprise Vault provides compression, why did you enable compression at the storage level? Did you confirm that the HCP compression is better than the EV compression?

OK i just want to figure out something first before confusing this thread even more. Do both you and Deepak administer the same environment and work together? or are you both having the same issues but different companies?

Regardless can you run the following query and show the results?

USE EnterpriseVaultDirectory
SELECT  VSE.VaultStoreName "Vault Store",
	VSG.DisplayName "Vault Store Group",
	FCD.DatabaseName "FingerPrint Database",
	FCD.SQLServer "FingerPrint SQL Server",
	CASE VSE.SharingLevel
	WHEN 0 THEN 'No Sharing'
	WHEN 1 THEN 'Share Within Partition'
	WHEN 2 THEN 'Share Within Group'
	END AS "Sharing Level"
FROM    VaultStoreGroup VSG,
        VaultStoreEntry VSE,
        FingerprintCatalogueDatabase FCD,
        FingerprintCatalogueInstance FCI,
        SISBoundary SB
WHERE   VSE.SISBoundaryIdentity = SB.SISBoundaryIdentity
  AND   SB.VaultStoreGroupIdentity = VSG.VaultStoreGroupIdentity
  AND   VSG.VaultStoreGroupIdentity = FCI.VaultStoreGroupIdentity
  AND   FCI.FPCIIdentity = FCD.FPCIIdentity
ORDER BY "Vault Store"

Hi Gabe,

we have enabled SIS on EV since build, and during our tetsing we are trying to find an evidance of SIS its woking properly.

we are using Hitachi Contant platform as storage for EV as per customer requirement and as per Htachi - EV intigration guide ,  compression should be on HCP end and deduplication will be on EV.

I am not sure  HCP compression is better than EV but data faiover point of view its good.

Hi, Yes We are from same company.I was not aware Vishal has already put this query on this forum.