CloudWatch Custom Metrics for Windows Server

Posted on June 2, 2016 by Richa Pathak | Comments(0)

It’s not rare that users having requirements of sending custom metrics to CloudWatch. These metrics can be application based or server based. There are different ways we can send these metrics to CloudWatch like writing a simple PowerShell script and scheduling it in Task Scheduler to run periodically. Alternate way to accomplish this, which I personally find very easy is by making simple changes in EC2ConfigService in your windows instance. ADVANTAGES: It is very easy to implement. There is no need to write scripts which sometimes can be really lengthy. Task Scheduler is not required which in turn can save memory. Most Importantly, margin of making error is very less. Let’s take an example that you want to send Free disk and Memory utilization metrics to CloudWatch. PREREQUISITES: EC2Config version should be 2.2.5 or later. Create IAM user with following permissions. IMPLEMENTATION: 1. RDP into your windows instance and from the Start menu, click All Programs, and then click EC2ConfigService Settings. 2. Enable CloudWatch Logs Integration and click OK. 3. Go to C:\Program Files\Amazon\Ec2ConfigService\Settings\AWS.EC2.Windows.CloudWatch.json and replace below code in the file. 4. Go to Control Panel\System and Security\Administrative Tools\Settings and restart EC2 Config service. And It’s done. You

Continue reading…

Migration Tale of Databases – 6 Reasons to move from Oracle to Microsoft SQL

Posted on April 14, 2016 by Arzan A | Comments(0)

As far as I have seen, there are majorly two types of DBAs. The one who favor the Oracle and the others who favor Microsoft SQL. Each of the database systems are very well tested and designed with years of improvement done with experience. They share a long listing of similarities but also few differences which makes the software and system architects choose one from the two. This article doesn’t fall into discussing the differences between the two, but rather gives you a high level insight about the migration ideology behind moving the database workloads from Oracle to MS SQL. Why should I move my databases from Oracle to MS SQL? Does this question arise in your mind? Well, I can describe 6 reasons #1. Very limited cloud exposure of Oracle Systems. Cloud technology is the need of every organization today. Not necessary it is always a 100% migration case scenario but it can also be the case where cloud can be used as a part of hybrid implementation or disaster recovery site. With Microsoft SQL, we get options for implementing the database on cloud as well as on-premises. Even if the database is implemented on-premises, a very tight integration

Continue reading…

Introducing Run Command in EC2

Posted on December 9, 2015 by Ravi Theja | Comments(5)

In order to perform updates, patches, restart a particular process or running a particular powershell script in a Windows based EC2 instance we need to login to the machine and then make the required changes. Sometimes in a huge production environment this tends to be a cumbersome job for managing large fleet of machines. Therefore in order to make our lives easier AWS has introduced a new add-on feature for EC2 called as Command. Features of Run Command Using this feature we can perform system administrator tasks on Windows based EC2 machines. Currently the following actions are supported in Run Command. Configuring Cloud Watch Configuring Windows Update Install an Application Install PowerShell Module Join an EC2 instance to Directory Service Domain Run a PowerShell script Update EC2 config Security of Run Command Since Run Command runs from the AWS console and no username and password is required to access the instances, questions may arise as to how safe this feature is? Run Command incorporates with IAM policies and roles. Each and every command which is run using Run Command is stored in CloudTrail and also remains in the Console for 30 days. Run Command shows the output in the console for

Continue reading…

Recover EC2 Windows Password

Posted on November 5, 2015 by Vysakh Venugopal | Comments(1)

There are scenarios where we lose/forget our windows password and then trying out a way to login to the windows server. This turns out to be critical if it’s an admin credential that is lost. But still there’s a way to reset the password. Here’s how to do this: Before going through the steps, we assume that you have a running AWS EC2 Windows instance. For resetting the password we require a Linux machine, which we prefer is an Ubuntu Server in the same AZ as your windows instance. This method requires your EC2 windows instance to be taken offline for some time.