Unix Technical Forum

SQL Agent CPU sustained peaks

This is a discussion on SQL Agent CPU sustained peaks within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> Hi everyone I've got another issue in my company's datawarehouse system. SQLAgent eventually loads CPU with 20 - 25% ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server Data Warehousing

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:55 PM
=?Utf-8?B?THVpcyBGZXJuw6FuZGV6?=
 
Posts: n/a
Default SQL Agent CPU sustained peaks

Hi everyone

I've got another issue in my company's datawarehouse system. SQLAgent
eventually loads CPU with 20 - 25% of activity.

What can be the reason for this?

Thanks

Luis


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 07:55 PM
Michael Hotek
 
Posts: n/a
Default Re: SQL Agent CPU sustained peaks

The only cause of that is the jobs that are being executed by SQL Server
Agent. If there aren't any jobs executing, SQL Server Agent just spins
cycles within the background noise on the server.

--
Mike Hotek
MHS Enterprises, Inc
http://www.mssqlserver.com


"Luis Fernández" <LuisFernndez@discussions.microsoft.com> wrote in message
news:4D441331-CA70-4772-B686-ECCE6A57E043@microsoft.com...
> Hi everyone
>
> I've got another issue in my company's datawarehouse system. SQLAgent
> eventually loads CPU with 20 - 25% of activity.
>
> What can be the reason for this?
>
> Thanks
>
> Luis
>
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:39 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com