High SQL load from backup to tape job while idle

Everything about backing up to tape

High SQL load from backup to tape job while idle

Veeam Logoby mschlott » Mon Mar 03, 2014 9:45 pm

I noticed today that my SQL database had a constant high cpu usage. My DBA looked into it and found the below sql statement running all the time and using a lot of resources. He added a reccomended index and the problem went away. Thought I would pass this on in case others are experiencing this issue and don't have access to a decent DBA. Another symptom was that anytime I tried to stop my backup to tape job, while idle, it would take over a minute to stop. After stopping the backup to tape job, the SQL load would go away.

Here is the statment. It may contain typos, I am typing this in from a screen shot.
select oib.* from
[dbo][Backup.Model.OIBs] oib
where
oib.storage_id = @storage_id

Here is the index information. My database name is VeeamBackup.
Create missing_index_1 ON [VeeamBackup].[dbo].[Backup.Model.OIBs] ([storage_id])
mschlott
Enthusiast
 
Posts: 83
Liked: 2 times
Joined: Thu Jan 20, 2011 5:45 pm
Full Name: Mike Schlottman

Re: High SQL load from backup to tape job while idle

Veeam Logoby Gostev » Mon Mar 03, 2014 10:48 pm

Do you have Patch #3 installed?
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: High SQL load from backup to tape job while idle

Veeam Logoby mschlott » Mon Mar 03, 2014 10:54 pm

Not yet. Was this fixed in patch 3?
mschlott
Enthusiast
 
Posts: 83
Liked: 2 times
Joined: Thu Jan 20, 2011 5:45 pm
Full Name: Mike Schlottman

Re: High SQL load from backup to tape job while idle

Veeam Logoby foggy » Tue Mar 04, 2014 8:04 am

Some database interaction improvements have been introduced there, worth a try.
foggy
Veeam Software
 
Posts: 14728
Liked: 1078 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Tape



Who is online

Users browsing this forum: No registered users and 4 guests