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

[Back to original message]