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

Update Rollup 8 for System Center 2012 R2 Virtual Machine Manager #Sysctr #SCVMM

system-center-2012-r2-logo-new

Introduction

This article describes the issues that are fixed in Update Rollup 8 (UR8) for Microsoft System Center 2012 R2 Virtual Machine Manager. There are two updates available for System Center 2012 R2 Virtual Machine Manager: one for servers and one for the Administrator Console. This article also contains the installation instructions for Update Rollup 8 for System Center 2012 R2 Virtual Machine Manager.

Features that are added in this update rollup

  • Support for SQL Server 2014 SP1 as VMM database
    With Update Rollup 8 for SC VMM 2012 R2 you can now have Microsoft SQL Server 2014 SP1 as the VMM database. This support does not include deploying service templates by using the SQL profile type as SQL Server 2014 SP1. For the latest information about SQL Server requirements for System Center 2012 R2, see the reference here.
  • Support for VMWare vCenter 6.0 management scenarios
    With Update Rollup 7, we announced support for management scenarios for vCenter 5.5. Building on our roadmap for vCenter and VMM integration and supportability, we are now excited to announce support for VMWare vCenter 6.0 in Update Rollup 8. For a complete list of supported scenarios, click here.
  • Ability to set quotas for external IP addresses
    With Update Rollup 7, we announced support for multiple external IP addresses per virtual network, but the story was incomplete, as there was no option to set quotas on the number of NAT connections. With UR8, we are glad to announce end-to-end support for this functionality, as you can now set quotas on the number of external IP addresses allowed per user role. You can also manage this by using Windows Azure Pack (WAP).

Issues that are fixed in this update rollup

  • Issue 1
    Creation of Generation 2 VMs fails with the following error:

    Error (13206)
    Virtual Machine Manager cannot locate the boot or system volume on virtual machine <VM name>. The resulting virtual machine might not start or operate properly.
  • Issue 2
    VMM does not let you set the owner of a hardware profile with an owner name that contains the “$” symbol.
  • Issue 3
    HA VMs with VLAN configured on the network sites of a logical network cannot be migrated from one host to another. The following error is thrown when you try to migrate the VM:

    Error (26857)
    The VLAN ID (xxx) is not valid because the VM network (xxx) does not include the VLAN ID in a network site accessible by the host.
  • Issue 4
    The changes that are made by a tenant administrator (with deploy permissions to a cloud) to the Memory and CPU settings of a VM in the cloud through VMM Console do not stick. To work around this issue, change these settings by using PowerShell.
  • Issue 5
    When a VM is deployed and put on an SMB3 file share that’s hosted on NetApp filer 8.2.3 or later, the VM deployment process leaves a stale session open per VM deployed to the share. When many VMs are deployed by using this process, VM deployment starts to fail as the max limit of the allowed SMB session on the NetApp filer is reached.
  • Issue 6
    VMM hangs because of SQL Server performance issues when you perform VMM day-to-day operations. This issue occurs because of stale entries in the tbl_PCMT_PerfHistory_Raw table. With UR8, new stale entries are not created in the tbl_PCMT_PerfHistory_Raw table. However, the entries that existed before installation of UR8 will continue to exist. To delete the existing stale entries from the SQL Server tables, use the following SQL script:

    DELETE FROM tbl_PCMT_PerfHistory_Raw where TieredPerfCounterID NOT IN (SELECT DISTINCT tieredPerfCounterID FROM dbo.tbl_PCMT_TieredPerfCounter);

    DELETE FROM tbl_PCMT_PerfHistory_Hourly where TieredPerfCounterID NOT IN (SELECT DISTINCT tieredPerfCounterID FROM dbo.tbl_PCMT_TieredPerfCounter);

    DELETE FROM tbl_PCMT_PerfHistory_Daily where TieredPerfCounterID NOT IN (SELECT DISTINCT tieredPerfCounterID FROM dbo.tbl_PCMT_TieredPerfCounter);

  • Issue 7In a deployment with virtualized Fiber Channel adapters, VMM does not update the SMI-S storage provider, and it throws the following exception:
    Name : Reads Storage Provider
    Description : Reads Storage Provider
    Progress : 0 %
    Status : Failed
    CmdletName : Read-SCStorageProvider
    ErrorInfo : FailedtoAcquireLock (2606)This occurs because VMM first obtains the Write lock for an object and then later tries to obtain the Delete lock for the same object.
  • Issue 8
    For VMs with VHDs that are put on a Scale out File Server (SOFS) over SMB, the Disk Read Speed VM performance counter incorrectly displays zero in the VMM Admin Console. This prevents an enterprise from monitoring its top IOPS consumers.
  • Issue 9
    Dynamic Optimization fails, leaks a transaction, and prevents other jobs from executing. It is blocked on the SQL Server computer until SCVMM is recycled or the offending SPID in SQL is killed.
  • Issue 10
    V2V conversion fails when you try to migrate VMs from ESX host to Hyper-V host if the hard disk size of the VM on the ESX host is very large. The following mentioned error is thrown:

    Error (2901)
    The operation did not complete successfully because of a parameter or call sequence that is not valid. (The parameter is incorrect (0x80070057))
  • Issue 11
    Live migration of VMs in an HNV network takes longer than expected. You may also find pings to the migrating VM are lost. This is because during the live migration, the WNV Policy table is transferred (instead of only delta). Therefore, if the WNV Policy table is too long, the transfer is delayed and may cause VMs to lose connectivity on the new host.
  • Issue 12
    VMM obtains a wrong MAC address while generating the HNV policy in the deployments where F5 Load Balancers are used.
  • Issue 13
    For IBM SVC devices, enabling replication fails in VMM because there is a limitation in SVC in which the name of the consistency group should start with an alphabetical character (error code: 36900). This issue occurs because while enabling replication, VMM generates random strings for naming the “consistency groups” and “relationship” between the source and the target, and these contain alphanumeric characters. Therefore, the first character that’s generated by VMM may be a number, and this breaks the requirement by IBM SVC.
  • Issue 14
    In Update Rollup 6, we included a change that lets customers have a static MAC address even if the network adapter is not connected. This fix did not cover all scenarios correctly, and it triggers an exception when there’s a template with a connected network adapter, and then you later try to edit the static address in order to disconnect the network adapter.
  • Issue 15
    Post Update Rollup 6, as soon as a host goes into legacy mode, it does not come back to eventing for 20 days. Therefore, the VM properties are not refreshed, and no events are received from HyperV for 20 days.This issue occurs because of a change that’s included in UR6 that set the expiry as 20 days for both eventing mode and legacy mode. The legacy refresher, which should ideally run after 2 minutes, now runs after 20 days; and until then, eventing is disabled.Workaround:
    To work around this issue, manually run the legacy refresher by refreshing VM properties.
  • Issue 16
    Post-UR7, deleting a virtual network does not correctly clean up the cluster resources for the Network Virtualization Gateway. This causes the cluster role (cluster group) to go into a failed state when a failover of the HNV gateway cluster role occurs. This causes a failure status on the gateway

You can download RollUpdate 8 for System Center 2012 R2 VMM here

Here you can download RollUpdate 8 for System Center 2012 R2 Suite


Leave a comment

UPDATE #Microsoft System Center Management Pack for #SQL Server 2014 #Sysctr #SCOM

SQL SCOM Dashboard

Microsoft System Center Management Pack for SQL Server 2014 enables the discovery and monitoring of SQL Server 2014 Database Engines, Databases, SQL Server Agents and other related components. This Management Pack is designed to run by Operations Manager 2007 R2 (except dashboards), Operations Manager 2012 or Operations Manager 2012 R2.

The monitoring provided by this management pack includes performance, availability, and configuration monitoring, as well as performance and events data collection. All monitoring workflows have predefined thresholds and complimentary knowledge base articles. You can integrate the monitoring of SQL Server 2014 components into your service-oriented monitoring scenarios.

In addition to health monitoring capabilities, this management pack includes dashboards, diagram views, state views, performance views, alert views and diagnostic tasks that enable near real-time diagnostics and remediation of detected issues.

Note: This management pack does not depend on Microsoft SQL Server Library management pack. You do not need to import it to enable the monitoring of SQL Server 2014.
Note: This management pack is only for SQL Server 2014. Please use this link to download Microsoft Operations Manager Management Pack for SQL Server 2005/2008/2012.

Feature Summary
The following list gives an overview of the features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2014. Please refer to Microsoft SQL Server 2014 Management Pack Guide for more details.

  • Discovery and monitoring of SQL Server 2014 roles like DB Engine, Integrations Services.
  • Discovery of SQL Server 2014 components: Databases, SQL Agent and SQL jobs.
  • The management pack introduces 100+ monitors and 380+ rules to provide a deep monitoring of SQL Server 2014. Please refer to Microsoft SQL Server 2014 Management Pack Guide for the complete list of monitoring scenarios and workflow inventory.
  • Monitoring of SQL Server 2014 AlwaysOn:
    • Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
    • Health roll-up from availability database to availability replicas.
    • Detailed knowledge for each related monitoring workflow.
  • Seamless integration with SQL Server 2014 policy based management (PBM):
    • Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
    • Rollup of policy execution health to the health of related SCOM entity.
  • Monitoring of SQL Server In-Memory OLTP.
  • Reports for long-term analysis of different problematic areas related to SQL Server 2014, such as SQL Server lock analysis, top deadlocked databases, SQL Server service pack levels, user connection activity. In addition, generic reports from the Microsoft Generic Report Library can be used to review availability and performance of objects discovered by Microsoft System Center Operations Manager Management Pack for SQL Server 2014.
  • Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
  • Support for Mirroring Monitoring
    • Discover mirroring databases, witness, and mirroring group.
    • Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
    • Custom diagram view to represent the primary and the mirrored databases visually.

New features and fixes:

  • Fixed performance
  • Added a support for disabled TCP/IP protocol
  • Fixed performance metrics error that may occur on some localized versions of Windows
  • Fixed incorrect performance of Transaction log free space monitor
  • Added new type of events from failed discoveries; added a new rule that collects such events
  • Added overrides to prevent various scripts timeout failure
  • Removed some 1X1 tiles from Summary Dashboards
  • Filestream filegroups are excluded from discovery for now
  • 2008/2012 Summary Dashboards tiles were reorganized
  • Added KB for Microsoft.SQLServer.2014.Mirroring.MirroringCommonGroupDiscovery
  • Summary Dashboard: added monitor/performance tiles to class “SQL Server 2014 Mirroring Groups”
  • Some minor fixes

You can download the Microsoft System Center Management Pack for SQL Server 2014 here

system-center-2012-r2-logo-new


Leave a comment

#Microsoft Virtual Academy is the place to be……. #Learning #sysctr #Azure #SQL #Office365 #Sharepoint #MVA

MVA Learning

What is MVA?

Successful technologists never stop learning and great technology never stops evolving. Microsoft Virtual Academy (MVA) offers online Microsoft training delivered by experts to help technologists continually learn, with hundreds of Microsoft training courses, in 14 different languages. Our mission is to help developers, knowledgeable IT professionals and advanced students learn the latest technology, build their skills, and advance their careers. Through MVA, we offer free Microsoft training, and the entire service is hosted on Windows Azure.

Become an MVA member so that you can earn points for your learning, achieve different levels of badges and status relative to others in your country or around the world, and get certificates when you complete an entire online training course. Your personal dashboard helps you track your progress against your personal learning plans.

MVA learning opportunities combine on-demand Microsoft training courses and live events:
•On-demand, free Microsoft training courses help you learn at your own pace, and when the time is right for your busy schedule.
•MVA’s exciting live online courses include Jump Start training, where you can interact with experts and a worldwide audience of learners from around the world. Through this method of interactive online training, our instructors and subject matter experts will answer the questions you pose in real time chat sessions so that you can apply what you learn right away.

Developers who want to learn how to build apps for the web, Windows or Windows Phone can explore our free Microsoft training courses on App Development training, HTML5 training, C# training including XAML, Game Development training, Cloud Development, Mobile App Development, Web Development and mobile development training.

IT Pros who are looking to evaluate, deploy, administer, update, and manage infrastructure in their organization should checkout our hundreds of online IT training courses. Topics include Management and Security training, Windows Server training, Office 365 training, Windows 8 training, Windows Azure training, Virtualization, Hybrid Cloud Training and Business Intelligence.

From here you go to Microsoft Virtual Academy

Virtual Labs
Go to Microsoft Virtuallabs for Virtual environments


Leave a comment

UPDATE System Center Management Pack for SQL Server 2014 #SCOM #SQL2014 #sysctr #SQL

Instance SummaryInstance Summary Dashboard.

The System Center Management Pack for SQL Server 2014 enables the discovery and monitoring of SQL Server 2014 Database Engines, Databases, SQL Server Agents and other related components. This Management Pack is designed to run by Operations Manager 2007 R2 (except dashboards), Operations Manager 2012 or Operations Manager 2012 R2.

The monitoring provided by this management pack includes performance, availability, and configuration monitoring, as well as performance and events data collection. All monitoring workflows have predefined thresholds and complimentary knowledge base articles. You can integrate the monitoring of SQL Server 2014 components into your service-oriented monitoring scenarios.

In addition to health monitoring capabilities, this management pack includes dashboards, diagram views, state views, performance views, alert views and diagnostic tasks that enable near real-time diagnostics and remediation of detected issues.

Note: This management pack does not depend on SQL Server Library management pack. You do not need to import it to enable the monitoring of SQL Server 2014.
Note: This management pack is only for SQL Server 2014. Please use this link to download the Operations Manager Management Pack for SQL Server 2005/2008/2012.

Feature Summary
The following list gives an overview of features introduced by System Center Operations Manager Management Pack for SQL Server 2014. Please refer to the SQL Server 2014 Management Pack Guide for more details.

  • Discovery and monitoring of SQL Server 2014 roles like DB Engine, Integrations Services.
  • Discovery of SQL Server 2014 components: Databases, SQL Agent and SQL jobs.
  • The management pack introduces 100+ monitors and 380+ rules to provide a deep monitoring of SQL Server 2014. Please refer to the SQL Server 2014 Management Pack Guide for the full list of monitoring scenarios and workflow inventory.
  • Monitoring of SQL Server 2014 AlwaysOn:
    • Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
    • Health roll-up from availability database to availability replicas.
    • Detailed knowledge for each related monitoring workflow.
  • Seamless integration with SQL Server 2014 policy based management (PBM):
    • Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
    • Rollup of policy execution health to the health of related SCOM entity.
  • Monitoring of SQL Server In-Memory OLTP.
  • Reports for long-term analysis of different problematic areas related to SQL Server 2014, such as SQL Server lock analysis, top deadlocked databases, SQL Server service pack levels, user connection activity. Also, generic reports from the Microsoft Generic Report Library can be used to review availability and performance of objects discovered by System Center Operations Manager Management Pack for SQL Server 2014.
  • Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
  • Support for Mirroring Monitoring
    • Discover mirroring databases, witness, and mirroring group.
    • Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
    • Custom diagram view to visually represent the primary and the mirrored databases.

New features

  • Added Mirroring monitoring scenarios for SQL Server 2014 product
  • SPN monitor now has ‘search scope’ parameter which allows the end user to choose between LDAP and Global Catalog
  • Fixed Timeout error in CPU utilization monitoring scenario
  • Monitoring SQL Server Instances on the same server with their own network interfaces and default port is now available
  • SQL Server instances with underscores and other allowed special symbols in names can be monitored
  • Minor fixes.

Improvements:

  • Dependency on SQL Server Library management pack has been eliminated.
  • Support of Localized performance counter for CPU and Logical Disk Metrics.
  • SQL Server Integration Services monitoring seed discovery.
  • SQL Server Integration Services moved to separate management pack.
  • SQL Server non-default port is now supported.
  • Optimized performance collection replaced with raw performance collection to guarantee accuracy of hourly and daily aggregated data.

Fixes:

  • Standard Edition Databases discovery issue fixed.
  • AlwaysOn: Endpoint URL points to a non-computer name.
  • AlwaysOn: read intent is not supported, false alert message removed.

Other changes:

  • Monitoring of SQL Server Reporting Services has been deprecated. This component will be monitored by dedicated management pack.
  • Monitoring of SQL Server Analysis Services has been deprecated. This component will be monitored by dedicated management pack.
  • Monitoring of SQL Server Replication has been deprecated. This component will be monitored by dedicated management pack.

You can download the Microsoft System Center Management Pack for SQL Server 2014 here


Leave a comment

#Microsoft Virtual Academy Free E-books Site #MVA #sysctr #Hyperv #Azure #SQL #Winserv #Education

MVA Ebooks Site

When you want to learn more about all the Microsoft Products like :

  • Windows Server 2012 R2
  • Windows Server 2012 R2 Hyper-V
  • System Center 2012 R2
  • Microsoft Azure
  • App Development in the Microsoft Azure Cloud
  • Microsoft SQL Server 2014
  • Windows 8.1
  • and More……….

You have to go to this awesome Microsoft Virtual Academy site for Free E-books

MVA Elevate

And ofcourse you can follow online Microsoft Courses and Live Events at Microsoft Virtual Academy site for Free