cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server HIGH CPU

hazga
Level 1

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.

1 REPLY 1

VirgilDobos
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi mate,

Can you confirm the SQL maintenance is done as per the best practices and also that the SQL fragmentation is not over say 60%?

https://www.veritas.com/support/en_US/article.TECH74666

--Virgil