Microsoft codename “Atlanta” is a new secure cloud service that proactively monitors your Microsoft SQL Server deployments. It helps you avoid configuration problems, reduce downtime, improve performance and efficiency of Microsoft SQL Server.
Atlanta cloud service analyzes SQL Server configuration data to identify issues and recommendations. DBA can view configuration data and alerts on the Atlanta portal.
Alerts provide information about particular issue that was detected, the cause, and how to address this issue. Each alert also contains link to additional information contained in article from the Microsoft Knowledge Base. Moreover, you can track current and historical configuration information for the computers being analyzed.
The Beta 1 release of Atlanta supports configuration monitoring of the SQL Engine within SQL Server 2008 and SQL Server 2008 R2 deployments running on Windows Server 2008 or Windows Server 2008 R2.
The production version of the service will be available in the first half of the 2011 calendar year.
To start using beta version of Atlanta (available since 8th of November, 2010) you need to complete the following steps:
-
-
Download and install the Atlanta gateway and agent.
An agent needs to be installed on each server in your environment (where SQL Server is installed). It’s main role is to scan the server and aggregate management data.
A gateway component should be installed on one server with internet access.
It periodically uploads the aggregated data from agents to a secured web service.
A gateway can also store data from agents installed on non-internet connected servers.
-
Begin analyzing your systems.
Final reports can look like these presented below:
Alerts for detected issues and resolution steps.
Monitoring server configuration and tracking changes.
Adding and removing monitored servers.
More technical details on Microsoft Codename “Atlanta” you can find under the following links: