What are the challenges you face when working across database platforms? Take the survey
Options

SQLBackup uses almost 100% CPU

LALLAL Posts: 9
edited March 7, 2011 8:46PM in SQL Backup Previous Versions
Hello

On a SQL Server with the following versions:
- Windows 2008 R2
- SQL 2005 SP3
- SQL Backup 6.4 (UI 6.4.56; SQBCoreService 6.4.0.1015)

When starting SQLBackup UI on the server it takes up to 100% connecting to SQL 2005 (green circle keeps running). When I killed the UI process, the SQBCoreService process was still using 45% CPU. I had to restart the service. There was no backup or restore running. All I did was just expanded the SQL Server in the SQLBackup UI.

Why are these two processes, particularly the UI, use so much CPU?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Best guess is that it's busy retrieving and processing the backup history. Could you please run the following queries and let us know the results:
    EXEC master..sqbdata 'SELECT COUNT(*) FROM backuphistory'
    SELECT COUNT(*) FROM msdb..backupset
    

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    First query: 28153
    Second query: 83665
  • Options
    peteypetey Posts: 2,358 New member
    It looks like the GUI and service are busy populating the local backup history data store. Is this the first time you are running the GUI to connect to this instance on this machine? If so, if you can let it run awhile, this would be a one time hit. Subsequent runs of the GUI won't need to store the backup/restore history details from scratch.

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thanks. I'll let it run for a while and see how we go.
Sign In or Register to comment.