cancel
Showing results for 
Search instead for 
Did you mean: 

Evidence the Single instancing

vishal_Saxena
Level 3

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

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified

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

https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

17 REPLIES 17

Rob_Wilcox1
Level 6
Partner

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.

 

Working for cloudficient.com

GabeV
Level 6
Employee Accredited

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.

JesusWept3
Level 6
Partner Accredited Certified

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
https://www.linkedin.com/in/alex-allen-turl-07370146

deepak_jindal12
Level 3

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
Level 6
Partner Accredited Certified

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

https://www.linkedin.com/in/alex-allen-turl-07370146

vishal_Saxena
Level 3

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
Level 6
Employee Accredited

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?

JesusWept3
Level 6
Partner Accredited Certified

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"
https://www.linkedin.com/in/alex-allen-turl-07370146

vishal_Saxena
Level 3

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.

deepak_jindal12
Level 3

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

vishal_Saxena
Level 3

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.  

 

Rob_Wilcox1
Level 6
Partner

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.

Working for cloudficient.com

JesusWept3
Level 6
Partner Accredited Certified

what happens if you just do select * from FileTypeSummary?

https://www.linkedin.com/in/alex-allen-turl-07370146

Rob_Wilcox1
Level 6
Partner

No rows returned either, petal.

Working for cloudficient.com

vishal_Saxena
Level 3


Hi All,

Any more suggestion. we dint get any appropriate answer 

Thanks

Vishal

JesusWept3
Level 6
Partner Accredited Certified

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
https://www.linkedin.com/in/alex-allen-turl-07370146

JesusWept3
Level 6
Partner Accredited Certified

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

https://www.linkedin.com/in/alex-allen-turl-07370146