Video Screencast Help

Evidence the Single instancing

Created: 19 Feb 2014 • Updated: 16 Apr 2014 | 17 comments
This issue has been solved. See solution.

Hi All,

I am looking evidance how the single instancing of an email sent to multiple  recipents, thorugh EV 10.0.3  SIS respositrory.

Thanks

Vishal

 

 

 

 

 

 

 

Operating Systems:

Comments 17 CommentsJump to latest comment

Rob.Wilcox's picture

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.

 

GabeV's picture

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.

“Success is not final, failure is not fatal: it is the courage to continue that counts.”–Winston Churchill

JesusWept3's picture

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
deepak.jindal123's picture

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 ?
 

JesusWept3's picture

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

vishal Saxena's picture

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

 

GabeV's picture

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?

“Success is not final, failure is not fatal: it is the courage to continue that counts.”–Winston Churchill

vishal Saxena's picture

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.

JesusWept3's picture

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"
vishal Saxena's picture

Yes Jesu, I and Deepak administer the same enviornment.

And we have run the query its show Vault Store names thats sharing within Group but that not evidance, when email sents to multiple recipients and only one copy of email is stored. and we are looking for same.  

 

deepak.jindal123's picture

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

Rob.Wilcox's picture

FWIW the output of this:

 

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

 

Is blank for me too.

JesusWept3's picture

what happens if you just do select * from FileTypeSummary?

vishal Saxena's picture



Hi All,

Any more suggestion. we dint get any appropriate answer 

Thanks

Vishal

JesusWept3's picture

One other thing you can try is a query against one of your vault stores

SELECT  A.ArchiveName "Archive Name",
	COUNT(SP.ParentTransactionID) "Shared Items"
FROM	EnterpriseVaultDirectory.dbo.Archive A,
	EnterpriseVaultDirectory.dbo.Root R,
	EVVSYourVaultStore_1.dbo.ArchivePoint AP,
	EVVSYourVaultStore_1.dbo.Saveset S,
	EVVSYourVaultStore_1.dbo.SISPart SP
WHERE   A.RootIdentity = R.RootIdentity
  AND   R.VaultEntryId = AP.ArchivePointId
  AND   AP.ArchivePointIdentity = S.ArchivePointIdentity
  AND   S.IdTransaction = SP.ParentTransactionId
GROUP BY A.ArchiveName
ORDER BY "Shared Items" DESC
JesusWept3's picture

And also if the answers or help given isn't useful or unhelpful to you, call in a case with symantec so they can take a look at your environment, simplest answer may be that its just detecting the hardware and letting it do the SIS for it instead

SOLUTION