chekced it was showing cpu usage more tahn 90% for the sqlserver.exe and the menory ussage was full. We stoped the sql service and restarted then the usage reduced.

This situation happned onece in a while.

How do i check what was going wrong at that time? this