Do you sometimes wonder how the pieces of your SQL Server systems are doing over time? Do you often wonder how they are doing in the moment? You can monitor the health and activity of your instances and databases using SQLFacts, a FREE suite of tools for SQL Server database engineers. Please refer to an earlier article for a general description of the SQLFacts toolkit.
SQLFacts provides many tools for performance tuning. A previous article covered the index-related performance tuning tools in SQLFacts. A previous article covered the query-related performance tuning tools in SQLFacts.
This article will focus on the monitoring