You can check Current Server Status Through Alarms and Events
Status of Multiple Servers
Check Status Details of a Single Server
SQL mini, A Query Tool Through Which You Can Write SQL, and Check the Plan and Object Information