Forum Discussion

hazga's avatar
hazga
Level 1
7 years ago

SQL Server HIGH CPU

Hi everyone;

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,

   DeviceType,MigratedFileId,ConvertedContentDisposition,LargeFile,

   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.