MS-SQL Diagnostics & Tuning

sp_Blitz (Brent Ozar)
Stack Exchange’s Monitoring System

See also:

See MSSQL Indexes for information on handling Index fragmentation

SQL Server Error Logs

The Error Logs are available under the SQL Server Agent section in SQL Server Management Studio. If the restart was due to a Windows restart then review the Windows Event Logs.