mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud


Leave a comment

#Microsoft System Center Management Packs (CTP1) for #SQL Server #Sysctr #MSOMS

Instance View

INSTANCE VIEW

The new features and fixes introduced in CTP1 management packs are as follows:

New SQL Server 2008/2008 R2/2012 MP Features and Fixes

  • Added support for databases stored on SMB Shares
  • Fixed error logging in a script for Blocking Sessions monitor
  • SQL 2005 MP files were excluded from the installer
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed Non-Readable Replica detection (Always On)
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

New SQL Server 2014/2016 MP Features and Fixes

  • Memory-Optimized Data Garbage Collection Fill Factor monitor and rule were disabled by default
  • Memory-Optimized Data workflows were disabled for all SQL Server instances, except for Developer, Enterprise, and Evaluation editions
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed issue: in some cases, Set Database Online/Offline tasks did not work for databases of SQL Server 2016 cluster instance
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.

The Operations Manager team encourages you to provide any feedbacks on the management packs by sending them to sqlmpsfeedback@microsoft.com

Creating Datacenter and Instance Dashboards

SQL Dash

With this System Center Management Pack CTP1 for SQL Server there is also an Awesome SQL Server Dashboard Guide to help you
building your own Dashboards in SCOM.

Entity Health

Here you can download the System Center Management Pack CTP1 for SQL Server and the Documentation.

 

SCUG Banner

Advertisements


Leave a comment

Migrating #Microsoft #SQL Server Databases to #Azure Guidelines

Azure SQL CloudThis blogpost will give you the information about migrating Microsoft SQL Server databases to Azure.
I see a lot of questions on the Microsoft TechNetMSDN forums about how to get my database secure in Microsoft Azure

Before you do a SQL migrate you can do a SQL Assessment via Microsoft Operations Management Suite.

OMS SQL Recommendations

You can see a step-by-step blogpost on my blog for the results for example :
 ‘Do your SQL Assessment with Microsoft OMS before your New Project Starts in Production’

Here you find Microsoft Azure technical documentation on Migrate to Azure :

SQL Migrating

SQL Server database migration to SQL Database in the cloud

For export and import Azure SQL Databases :

export-history

Export a BACPAC of a SQL Database

Import a BACPAC of a SQL Database

Copy a SQL Database

Migrating SQL to Azure1

There is also an Awesome Free Microsoft E-Book about Migrating SQL Server Databases to Azure by Carl Rabeler

MVA Course Migrating SQL to Azure

You find here a brand New  Microsoft Virtual Academy video Course about Migrating SQL Databases to Azure

SCUG Banner


Leave a comment

Microsoft #SQL Server #Backup to Microsoft #Azure Tool

SQL Server Backup to Azure

Overview:

SQL Server 2012 SP1 CU2 and SQL Server 2014 have built in capability to back up to Windows Azure storage. The SQL Server Backup to Windows Azure tool provides the same functionality for previous versions of SQL Server. It can also be used to provide encryption and compression for your backups.

Using the 3-step wizard, you can specify a rule or set of rules that are applied to any SQL Server backup. One example of a rule could be to redirect all local backups to the specified Windows Azure storage. Another example of a rule would be to use compression or encryption for backups stored in a specific location.

Once you configure the rules, these rules are applied to SQL Server Backup files. If the rule is set to use a Windows Azure storage account, the tool redirects the backups to the specified Windows Azure storage account, but leaves a stub file in the local storage with metadata information to be used during restore.

 

Benefits:

  • Support for backups to Windows Azure Storage for SQL Server versions that do not have the built-in capability. Using Windows Azure storage for your backups has several benefits, such as providing off-site storage for disaster recovery, accessibility regardless of location, etc. For more information, see SQL Server Backup and Restore with Windows Azure.
  • Encryption support for SQL Server versions that do not have the built in capability. Currently only SQL Server 2014 has encryption support.
  • Compression support for SQL Server versions that do not have the built in capability. Currently, SQL Server 2008 supports compression in Enterprise edition only, but SQL Server 2008 R2 and later, encryption is supported on Enterprise and Standard editions.

SQL Server and Operating Systems Support:

This tool is supported on SQL Server 2005 or later, and Operating System versions: Windows Server 2008 or later for Servers, and Windows 7 or later for Client Operating Systems.

Here you can download the Microsoft SQL Server Backup to Microsoft Azure Tool

SQL logo