In the last two weeks, SQL Solution center articles focused on SQL Server instance and database monitoring and creating SQL Server databases on multiple servers.
How to monitor your SQL Server instances and databases explains why SQL Server monitoring and performance goals are important and what metrics to monitor. We presented and compared two SQL Server Management Studio built-in monitoring solutions – Activity Monitor and Data Collector, and ApexSQL Monitor.
In Create a SQL database on multiple servers using multiple scripts, we showed how to create a SQL database across multiple SQL Servers instances using three scripts. We showed how to run these scripts using PowerShell, the SQLCMD utility, SQL Server Management Studio, and ApexSQL Build.
May 31, 2014