02-19-2014 11:39 AM
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
Solved! Go to Solution.
02-21-2014 08:32 AM
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
02-19-2014 11:42 AM
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.
02-19-2014 01:35 PM
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.
02-19-2014 02:16 PM
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
02-20-2014 06:39 AM
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 ?
02-20-2014 06:43 AM
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
02-20-2014 07:48 AM
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
02-20-2014 08:15 AM
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?
02-20-2014 08:34 AM
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"
02-20-2014 09:00 AM
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.
02-20-2014 09:12 AM
Hi, Yes We are from same company.I was not aware Vishal has already put this query on this forum.
02-20-2014 09:23 AM
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.
02-20-2014 11:20 AM
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.
02-20-2014 11:24 AM
what happens if you just do select * from FileTypeSummary?
02-20-2014 11:32 AM
No rows returned either, petal.
02-21-2014 08:15 AM
Hi All,
Any more suggestion. we dint get any appropriate answer
Thanks
Vishal
02-21-2014 08:27 AM
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
02-21-2014 08:32 AM
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