How can we help you today? How can we help you today?

SQLBackup uses almost 100% CPU

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?
LAL
0

Comments

4 comments

Sort by
  • petey
    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.
    petey
    0
  • LAL
    First query: 28153
    Second query: 83665
    LAL
    0
  • petey
    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.
    petey
    0
  • LAL
    Thanks. I'll let it run for a while and see how we go.
    LAL
    0

Add comment

Please sign in to leave a comment.