You are here: Re: 100 % CPU Usage « MsSQL Server « IT news, forums, messages
Re: 100 % CPU Usage

Posted by Brian Cryer on 11/24/05 14:04

"Paul" <paulwragg2323@hotmail.com> wrote in message
news:1132832857.005861.86530@g47g2000cwa.googlegroups.com...
> OK , I have re-run with the information messages on and there were 0
> allocation and 0 consistency errors so this looks OK.
>
> I have requested the mdf and ldf files from the customer rather than
> the backup in the hope that we may see different behaviour.
>
> Again, I will post back with any progress.
>
> Paul

I don't think it will turn anything up, but try running checkdb against your
master database.

Another thought (probably equally unlikely to turn up anything), I know
you've already looked in your sql server log and didn't find anything, have
you looked in the windows system event logs? If there were a disk related
issue it would probably be reported there - although I would expect
something to appear in the sql logs and I'm not sure it would account for
your high cpu time.
--
Brian Cryer
www.cryer.co.uk/brian

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация