It looks like I have a lot of reading to do over Christmas!

It is definitely sqlserver.exe that is using about 90% cpu. The server itself is responsive enough it is...

Thanks for all the help.

I changed the memory settings last night and all looks good so far although tomorrow morning will be the test. I have it set to 21GB...

Eric

Thanks for the tips on not stopping and being able to get a connection, it is just what I needed. I'll test this on our dev server and use it...

It is a dedicated physical machine with 24GB of RAM. Apart from SQL / SQL Agent and reporting services (used by one application) nothing else runs on the server at...

Thanks,

A lot of reading to be done, but looks helpful. I'll need to be able to get a connection to the DB to run this but it looks like that...