cancel
Showing results for 
Search instead for 
Did you mean: 

SQL CPU Usage is at 100%

GianniCool
Level 6
Partner

The archiving service was running against a remote SQL server, and EV was causing it to run at 100% CPU.  The EV services had to be stopped as it was killing other SQL operations.  They are running EV 7.5.  This just started yesterday, and no changes have been made to any of the Vault setup according to the client.

Any insight into this would be greatly appreciated.

Thanks!
-John
1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified
https://www-secure.symantec.com/connect/idea/enhancement-request-evault-stored-proc

"This has been resolved in V7.5 sp6 as well as V8 sp3"
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

10 REPLIES 10

JesusWept3
Level 6
Partner Accredited Certified
Get a SQL Admin to look through what stored procedures would be causing it to go at 100% I have seen this all too frequenetly with EV8, but not so much on EV2007 Check to see if you have DeleteEmptyFolders set on any of the EV servers (its a reg key)
https://www.linkedin.com/in/alex-allen-turl-07370146

GianniCool
Level 6
Partner

I cannot find DeleteEmptyFolders in the reg.  Do you want me to create it?

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Do you know what Store Procedure or Query was running against SQL?   I SQL Profiler trace would be handy.

GianniCool
Level 6
Partner

The DBA is getting that info now...

GianniCool
Level 6
Partner

Here's what I got:
This one was running over and over , it's XML based so we can't really troubleshoot it in the same way as we do with regular queries

exec usps_OrphanSavesets '<?xml version="1.0" encoding="UTF-16"?>
> <ROOT><ITEM TID="546B700A-6473-41E5-B245-4C2989C24AB0"
> JDTID="546B700A647341E5B2454C2989C24AB"/><ITEM
> TID="942C9DF2-9C3E-4FE2-A279-BDE7BB048FF0"
> JDTID="942C9DF29C3E4FE2A279BDE7BB048FF"/><ITEM
> TID="93C411A8-1320-47D5-BA8E-3B5085480D00"


TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Where you by chance running the archive task in report mode to cancel pending items?

http://seer.entsupport.symantec.com/docs/326422.htm


JesusWept3
Level 6
Partner Accredited Certified
https://www-secure.symantec.com/connect/idea/enhancement-request-evault-stored-proc

"This has been resolved in V7.5 sp6 as well as V8 sp3"
https://www.linkedin.com/in/alex-allen-turl-07370146

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Great catch JW2. 

GianniCool
Level 6
Partner

Thanks guys, I'll try that this morning and let you know!

-John

GianniCool
Level 6
Partner

Well, my client decided to do this in the evening.  I will update this thread tomorrow with the results.  Thanks again!