====== Microsoft - Microsoft SQL Server - SQL - Performance - View the error log ======

Look at the error log for messages relative to long I/O requests, bad pages or dumps.

<code sql>
sp_readerrorlog
</code>