Archive for April, 2014

OPSMGR execution of CLR code

Thursday, April 17th, 2014

if you just installed SCOm m, and received the following ERRO , this is because CLR is not enabled  on your SQL Server

image

in order to resolve this issue , run the following command in SQL server that host your SQL server DBs

image

DPM 2012 R2 Installation ERROR

Thursday, April 17th, 2014

 

DPM 2012 R2 doesn’t come anymore with SQL server , you either have to install an instance of SQL server in the same Machine , or use a remote SQL server to host the Database

During  the  installation of DPM 2012 R2 you may receive the following Error

SNAGHTML23e560d5

the cause of the error that DPM  need to have reporting server with HTTPS configured , in order to resolve this issue you need to Configure SSRS with HTTPS ()

image

Migrate VMware to Hyper-V

Saturday, April 12th, 2014

there is a lot of tools in the market  can help in converting VMware VMs to Hyper-v , however one of the best tools that I always recommend is Disk2VHD , and recently it has been refreshed to support VHDX as well.

image

however when you start creating VHDX from a VMware machine , and you mount the VM  in Hyper-v you except that it will work  , unfortunately you will get a Blue Screen of death (BSOD) and 0x0000007B – “Inaccessible Boot Device” error. This is due to the fact the converted VM will have no Primary IDE Channel since VMware recommend by default SCSI Disk and Hyper-V will presume that the converted disk is IDE type and located on the Primary IDE Channel.

There are two workaround to fix this issue :

1- First Solution : Repair the installation and hope that it will not affect the Software installed (I don’t recommend)

2- Second Solution:

a. For each VMware VM , add a new IDE disk drive  (any size will do let’s say 5 GB), Make sure that you select “Adapter: IDE 0 Device: 0” under “Virtual Device Node” while creating the new disk (otherwise we might end up with yet another SCSI disk.

b. Boot up the VM with both drives connected and check that it detects the new IDE drive (along with a primary IDE channel and a disk device driver). You should be able to see the new drive as "not initialized" in Disk Management.

c. Now the VM has the IDE Disk

D. start running your DISK2VHD

System Center Virtual Machine Manger and NetAPP SMIS not responding

Saturday, April 12th, 2014

 

Some times after you configure NetAPP SMIS  with SCVMM , the SMIS-S server shows Not  responding with warning sign  

image

In My case , i found it the SMIS has an issue to authenticate ,  after some research, I found that by setting up the enableAuthentication to false fix the problem , this is how to do it

login on  the machine that you have already installed SMI-S Provider

open a Command prompt as Administrator

show the config property first : as you see the enableAuthentication= true

image

to change to  false , set enableauthentication = False

image

Go back to VMM and refresh

image

image

SQL Cluster installation Error

Thursday, April 10th, 2014

I am installing SQL Cluster to host my SCOM DB in the lab ,

During the installation i got  the following error

image

the cause for this  error is that I have some error that I know about them in the validation report, and since it is a lab environment i don’t really care

the workaround is

  • For an integrated failover Add-Note setup, run the following command on each node that is being added:

    Setup /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster

  • For an advanced or enterprise installation, run the following command:

    Setup /SkipRules=Cluster_VerifyForErrors /Action=CompleteFailoverCluster

  • If you receive this validation failure when you add a node to an existing failover installation, run the following command on each node that is being added: 

    Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode

  • DPM Backup Summary Report

    Wednesday, April 9th, 2014

    Another clever work around for reporting from Steve

    available at the Gallery : http://gallery.technet.microsoft.com/DPM-Backup-Summary-Report-4533bcc6

    The DPM Backup Summary Report is a free SSRS based report that you can load in your DPM environment. This report works with DPM 2010 and DPM 2012/R2. For now the report is only for disk and tape based backups. In the future we are looking to extend this in the future to show online (Azure) as well. The features and data points contained in the report are:

    • Ability to select day, week, month (Time range)
    • Ability to select a single server or many
    • Ability to select a single protection group or many
    • Ability to select disk, tape or both backup type
    • Summary of the backup success and failures with a percentage of the successes (Success Rate/SLA)
    • Health trend of backups (day, week, month)
    • Backup detail including:Individual data sources (What was actually backed up)
      •      The status including the error (if there is an error)
      •      Date and time the backup was created
      •      How much data was transferred during the backup
      •      Total time it took to backup to complete

    More information about the report here: http://www.buchatech.com/2014/04/free-dpm-backup-summary-report/

    Screenshot of the report:

    Scaling out protection for virtual machines

    Wednesday, April 9th, 2014

    Since DPM 2012 SP1, you can scale out protection of Hyper-V clusters. The new scale-out feature removes the limit of a one-to-one relationship between a Hyper-V cluster and a DPM server, and the DPM protection agent that runs on a virtual machine can attach itself to multiple DPM servers. Therefore you can add the virtual machine to a protection group on any of the recognized DPM servers. Note the following:

    I found  that a lot of folks don’t know about this feature , This feature is only available for virtual machines that are hosted on servers that are running Windows Server 2012.

    Deployment scenario :

    you have 2 DPM servers (DPM1, DPM2) one large Cluster comprised of two nodes ,

    Scale out deployment for DPM

    the Steps to protect the Cluster using DPM1 and DPM 2 are

    1- Deploy DPM protection agents : from DPM 1 install the agent using the GUI

    2- Connect DPM2 to Node 1 and Node 2 using the following command

    SetDpmServer.exe Add –dpmServerName DPM2

    3- Attached all the VMs to DPM 2  either using power shell cmd-let or the GUI the
    Attach-ProductionServer.ps1 DPMServerName nodeN <user name> <password> <domain>
    Or use DPM’s administrator console, management, Agents, click “Install” and select the “attach agents” as shown below

    By following the above steps, all DPM servers are connected to all nodes on the cluster

    TechEd 2014 North America

    Wednesday, April 9th, 2014

     

    Yes , I am presenting at TechEd 2014 , Shereesh and I will be talking about protecting large Private cloud,  using DPM , please come an listen to this presentation it is demo driven session

    image

    New SCOM DPM Dashboard Download Link

    Wednesday, April 9th, 2014

    From Steve’s Blog

    A company named AIO Technology published a SCOM DPM dashboard a while ago. They recently removed it as they no longer offer this. I was the one that built this dashboard. I am posting about it here for anyone that may be looking to download it. You can now find this on TechNet Gallery here:http://gallery.technet.microsoft.com/SCOM-DPM-Dashboard-8eef9b58 

    Information about the dashboard:

    OVERVIEW

    This dashboard shows the overall health of your Data Protection Manager (DPM) backups. It includes all DPM servers in your environment in a central location. Great for daily spot checking of your backup health and getting to the root of any problems faster.

    Installing is as simple as importing into your Operations Manager (SCOM) server. You do need DPM management packs and central console deployed to your SCOM before installing this dashboard.

    clip_image001

    FEATURES

    • Centralized health of all DPM servers
    • Protection Group health aggregate
    • Protected Data Source health aggregate
    • Storage Pool health aggregate
    • Tape/Tape Library health aggregate

    Monitor SQL Availability Groups Using SCOM

    Monday, April 7th, 2014

    last year Microsoft released an updated Management for SQL Server , this MP was update to monitor Always on and SQL server 2012.

    I found that SQL server 2012 is missing a lot of monitoring and alerts for Always On and its replicas.

    in this blog , i will demonstrate how to use the latest SQL server MP to monitor SQL server and specially Always On

    1. Import SQL server Management Pack (Administration-> Management Packs –> right click and select Import MP—> Click Add from Catalog): make sure to choose version 6.4.1.0 SNAGHTML3d9a9b83
    2. In SCOM Monitor Tab expand Microsoft SQL Server MPimage
    3. Management Pack Inventory :
    4. Monitor Performance for AlwaysOn Availability Groups (AG):

    As I mentioned , there are a lot of monitors and rules to monitor Always On Availability Group In this management pack ,  I will choose only the most common rules that reflect the AG health

    1. The size of the log send queue on this replica: that Indicates the amount of log records in the log files of the primary database that have not been sent to the secondary replica,
      1. the rule name that monitor the log send queue is Log Send Queue Rule, the default Frequency to check is 900 sec – 15 min , I always recommend to override it 5 min = 300 sec ,
      2. To override : Go to Authoring –> Rules –> in the  search look for Log Send Queue Rule
        SNAGHTML43681407
      3. Right click and Choose override , Change the Frequency to 300 instead of 900
      4. now  when you go to Management pack SQL Server -> AlwaysOn High Availability –> Database Replica Performance->  and select Log send Queue for your replica , ideally you want always to see log send queue equal to zero , that means no log records are queued up image
      5. How to Alerts:You have to create a custom monitor based on a static threshold , the threshold should be Zero , that means , if the log send size is over  zero for N Consecutive sample raise an alert where N is the number of samples that SCOM collect, in our case ,N = 2
    2. imagein the general Tab , Type the name of the monitor, select Availability Group in the monitor Target  and leave the Parent Monitor (don’t uncheck Monitor is enable  )imagein the performance Counter  the easiest way to Click on select and choose the Perfmon counter “Log send Queue”image

    image

    In the Configure Health Change the Condition false to  Critical , and the Condition True to health and click next and finish

    image

    how do you Check that all is setup correctly :

    Go to SQL MP , Availability Group , right click on your  AG , then open the health explorer , in order to receive alerts , you need to subscribe to this monitor

    SNAGHTML43bb32a7

    in the next blog I will talk about another rule in SCOM to continue monitoring your AG