10-08-2017 02:37 PM
EV single server 2008 R2 SQL server 2008R2. Since we activated the vault store partition collections to improve the backup the SQL Server CPU is at 100 99% consumed by SQL process.
Our DBA suspect this request to be responsable.
SELECT FPVersion, FPDistinctionByte,FPHashPart1,ParentTransactionId,UniqueId,
IdPartition, VaultStoreIdentity,ArchivedDateUTC, AttachmentId, CollectionIdentity,RelativeFileName,HSMType,
CASE WHEN CacheIdPartition IS NOT NULL THEN 1 ELSE 0 END AS IsInSameVSDB,
CASE WHEN StreamerPartition = 1 THEN 1 ELSE 0 END AS CannotOptimise
FROM [dbo].[view_SavesetSISParts] WHERE SavesetIdentity = @SavesetIdentity
Any advice since the production is really impacted.
Thax in advance.
10-08-2017 09:19 PM
Can you confirm the SQL maintenance is done as per the best practices and also that the SQL fragmentation is not over say 60%?