SQL Server Activity Monitor

September 29, 2010 No comment

I know there are much more fancy tools you can buy on the market than the standaard build-in Activity Monitor from SQL Server, but is a usefull tool that can help you monitor your Server. You can find it when you right-click on the server instance and then click on Activity Monitor.

The 2 grids I watch most is:

A other tool (but payed) that can give you very good information about your SQL Sever is ‘SQL Sentry‘. You can download a trial from their website.