Red Gate forums :: View topic - cpu usage 90% for an hour
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

cpu usage 90% for an hour

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
stevenhoban



Joined: 18 Apr 2013
Posts: 15

PostPosted: Wed Jul 17, 2013 3:05 pm    Post subject: cpu usage 90% for an hour Reply with quote

I had a support call at 1pm saying that users where saying the app was running slow. I checked the cpu processor time and it was pegged up at around 90% for over an hour.
I have used the back in time feature of sql monitor and underneath the top 10 expensive queries ( which by the way, only seem to show queries used by sql monitor and not my user queries ) there is a heading named "SQL user processes (top 10 by CPU usage) and listed under this is the follwoing:
SPID 86 LOGIN TIME '17 JUK 2013 09:42 HOST "SERVER NAME"
PROGRAM NAME "SQL BACKUP" COMMAND "EXECUTE" STATUS "RUNABLE" DATABASE "MASTER"

This co-insides with when the processor started to max out.
Our sql backup pro runs on the host 'server name' but it wasnt doing anybackups at that time ?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Jul 18, 2013 9:06 am    Post subject: Reply with quote

Hi,

What was the CPU usage for 'SQL Backup' process when CPU was maxing out?

Thanks,
Priya
Back to top
View user's profile Send private message
stevenhoban



Joined: 18 Apr 2013
Posts: 15

PostPosted: Thu Jul 18, 2013 2:57 pm    Post subject: Reply with quote

How do i check that ?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Jul 18, 2013 3:08 pm    Post subject: Reply with quote

Hi,

You can use 'Back in time' feature on Machine overview and then navigate to time when CPU was maxing out. You should then be able to look at 'System processes (top 10)' list and see which process was using CPU.

Hope this helps.

Thanks,
Priya
Back to top
View user's profile Send private message
stevenhoban



Joined: 18 Apr 2013
Posts: 15

PostPosted: Fri Jul 19, 2013 12:05 pm    Post subject: Reply with quote

ah ok.
I can see SQBCoreService @ 44.9%
and
sqlservr @ 44.0%

I understand that the sqbcoreservice is not meant to cpu intensive ? Is this correct ?

Any pointers on where i go from here ?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Fri Jul 19, 2013 1:11 pm    Post subject: Reply with quote

Hi,

If there was no backup going at this point and still SQBCoreService service was using was using ~45% CPU then it will be worth raising it in SQL Backup forum or raising a support ticket.

Thanks,
Priya
Back to top
View user's profile Send private message
stevenhoban



Joined: 18 Apr 2013
Posts: 15

PostPosted: Fri Jul 19, 2013 1:55 pm    Post subject: Reply with quote

We have transaction log backups every 10 minutes but the full backups are done during the night.
The transaction log backups run througout the day with no issues. How come the cpu would be so high for this service ?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Mon Jul 22, 2013 8:34 am    Post subject: Reply with quote

Hi Steven,

I would suggest to raise this issue in SQL Backup forum or with Support@red-gate.com. I work for SQL Monitor development team hence my knowledge of SQL Backup is limited. SQL Backup development team or Red Gate Support team are better people to answer your queries.

Hope this helps.

Thanks,
Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group