Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

litespeed backup consumes high cpu Expand / Collapse
Author
Message
Posted Saturday, September 7, 2013 8:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 2, 2014 6:12 AM
Points: 41, Visits: 151
is litespeed one of the causes of high cpu??
Post #1492533
Posted Thursday, September 19, 2013 5:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 6,349, Visits: 13,670
the default within Litespeed is to parallelise across all available CPUs. Using the @affinity and @throttle parameters you are able to specify which processors the backup uses and the max CPU %

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1496342
Posted Tuesday, September 24, 2013 3:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
Perry Whittle (9/19/2013)
Using the @affinity and @throttle parameters you are able to specify which processors the backup uses and the max CPU %
Can we take help of Resource Governor in Sql 2008 for this ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1497713
Posted Thursday, September 26, 2013 6:43 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:20 AM
Points: 386, Visits: 233
Bhuvnesh (9/24/2013)
Perry Whittle (9/19/2013)
Using the @affinity and @throttle parameters you are able to specify which processors the backup uses and the max CPU %
Can we take help of Resource Governor in Sql 2008 for this ?


If you're using SQL 2008, I would suggest using native backup compression over LiteSpeed. Litespeed has it's own issues when running concurrent backup processes that native compression doesn't suffer from.






sqlmunkee
Bringing joy and happiness via SQL Server since 1998
Post #1498796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse