SQL Solution center round-up – May 31st, 2014 – SQL Server monitoring and creating databases on multiple servers

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.

Related posts:

  1. SQL Solution center round-up – August 1st, 2014 – SQL Server and operating system performance monitoring
  2. SQL Solution center round-up – October 17th, 2014 – Monitor SQL Server queries – find poor performers, and Italian and French translations of SQL Solution center articles
  3. SQL Solution center round-up – December 31st, 2013 – FERPA compliance for SQL Server DBAs, monitoring SQL Server performance
  4. SQL Solution center round-up – January 31st, 2014 – HIPAA compliance, SQL formatting, SQL Server memory performance, single table recovery, and SELECT statements auditing
  5. SQL Solution center round-up – December 15th, 2013 – compliance guidelines for SQL DBAs, SQL Server performance monitoring, rules of SQL formatting
May 31, 2014