casinos

Posts Tagged ‘Management’

Rejuvenate and feel better instantly December 24th, 2013

Vinod Kumar

Most people spend more time and energy going around problems than in trying to solve them – Henry Ford

In this era of fast food and easy-merry-go-life we want to do things instantly. And I am sure after a dull boring day we want instant energy back into our system to do things we would cherish doing – playing a game with our kids, taking your wife for a movie or taking parents to dinner. Some of these are great needs, but sometimes in middle of a busy day we need to be high on energy as we switch between meetings. How can we achieve this never deteriorating stream of energy every single day? So here are some of my best and easy steps I thought to pen down. Let me know if you used any of these methods in your life anytime.

The energy of the mind is the essence of life – Aristotle

  1. Stretch out: This is the simplest of the lot. Snap away from what you are doing, watch some greenery and stretch and bend your back.
  2. Step out for a walk: Just like above, this is one of the easiest and most used mechanism by many. Get outside your cubicle and get some fresh air and it helps clear your mind.
  3. Calling a friend: Sometime we get energy by symbiotic ways. Just calling one of your close friend and listening to their cheerful voice can get us all the energy we need to go for rest of the day.
  4. Dress for the occasion: If you are at home and not getting all the energy, just by dressing formally can get you in that mindset and you will be able to run the extra mile.
  5. Listen to music: Cutting yourself of the clutter and listening to some melody from your favorite composer can get you an extra ounce of energy increasing your concentration to do the next task in hand.
  6. Laugh your way out: There is no substitute to happy mind. Watching some funny videos (on youtube) that can bring a smile can surely rejuvenate the rest of the day.
  7. Read motivational stuff: This is something I do quite a bit. I keep reading lots of books and it brings back so much motivation that it keep me running.
  8. Control your breath cycles: If you are into Yoga then a few deep breaths of mini-pranayams can get some new positive energy flowing into your system.
  9. Snap and help someone in need: They say life comes in circles, so if you create a positive vibes in someone else’s life, you are going to get positive energy flowing into your life too.
  10. Do yourself a favor: The best way to revitalize is to do something meaningful to you. If you do something you have been wanting to do for a long time, it brings back so much of satisfaction and energy back in the system. This can be as simple as taking your Guitar and playing a few strings.
  11. Savor your success: The best way to boost yourself is to think about your recent successes for not more than 30 seconds. It can bring goosebumps yet reminds you that if you have done things in the past, it is quite possible in future too.

Passion is energy. Feel the power that comes from focusing on what excites you.

Understand that everything that happens in life is never good or bad, it is just our perception that makes them good or bad. I am sure you have found your own way to emotionally boost yourself when you get stuck in situation to give yourself that extra bit of energy. Do let me know – “what do you do to make yourself feel better when life puts a U turn and puts you down?”. Let me know.

Continue reading...


 

Life teaches us when we get on wrong direction December 20th, 2013

Vinod Kumar

Life is like a game of cards. The hand that is dealt you represents determinism; the way you play it is free will – Jawaharlal Nehru

I am sure all of you have gone through a feeling where you always said – “Life is not fair”, “I shouldn’t be getting into this”, “This shouldn’t have happened to me” etc. Now these are human instincts and our mind plays games with us. There is nothing wrong in these feelings and all of us sail in the same boat. Having said that, how can we avoid such feelings in the future? Life gives us enough hints and we ignore to get out of our comfort zone to acknowledge and take corrective steps. This is not simple and clear as it seems. Let me take a shot at this concept and what is currently running in my mind.

There are things known and there are things unknown, and in between are the doors of perception – Aldous Huxley

Most of us are engulfed in too many distractions around us that we forget and miss out these signals that is right in front of us.

Make your OWN decisions

This is the simple of the lot. If you always take decisions which are recommended by others you are leading a life filled with defaults which are never governed by you. These are dangerous and don’t try to be one of them. Live your life in your own terms – define it, build your sculpture and enjoy every moment.

Don’t take the path of least resistance

Who said life is going to be easy. Life is filled with challenges and do expect it to be this way. It adds spice to our lives and pushes us every single time. Even water flows in the least resistance path, but over a period of time it even cuts through stones and engulfs the anything in its path.

Don’t let your fears conquer you from doing what is right. Step out of your comfort zone and from time to time take some riskiest choices that will mold you as a better person. Understand that you never know how long you need to run while chasing your dreams – it can last a lifetime too.

All that we see or seem is but a dream within a dream – Edgar Allan Poe

Differentiate Obstacles Vs Opportunities

This is in continuation to precious point, but the fundamental difference between obstacles and opportunities is the way we see both. In this world there is no limit to the problems around us, just in pursuit to solving them is a ton loads of opportunities in front of us. So my request is to look past the negatives and look at the goodness life is filled with.

You work hard going nowhere

To achieve success in life we need to be focusing the right things with the right attitude and driving all your way in the right direction. Working hard is not enough and we have heard this in tons of management books out there. All jobs are created with different complexity. So don’t get caught up with the random odd jobs. Doing a random urgent job is not of any consequence if it was not of any importance.

Also the other thing about people is they start and don’t have the extra energy to finish. Understand that we are judged by the work that we finish not what all we started in life. This applies to professional life and personal life. Passion helps you take off, it is determination that helps you finish the job in hand.

Wherever you see a successful business, someone once made a courageous decision – Peter Drucker

As I finish this post, let me sign off saying nothing in life is permanent, our today steers the decisions we take and guides us through to what we do. Do everything with a positive mind because what you do today is what guarantees you to where you will be.

Continue reading...


 

Virtualization Journey with SQL Server–Windows Server 2012 December 17th, 2013

Vinod Kumar

This is in continuation to the previous post Virtualization Journey with SQL Server where we were trying to understand the WHY part. In this post, let me walk through some of the hardware innovations that one needs to be aware when working with Windows Server 2012 and Virtualization in specific. These are the same conversation I have with customers day-in-day-out when they come to MTC for sessions.

Windows Server 2012 provides a number of compelling capabilities to help organizations gain greater scalability and build reliable virtualized infrastructure for their mission-critical workloads like SQL Server 2012. Don’t worry, this whole integration of specific version of hardware with various versions of software is like a jigsaw puzzle and I will try to bring parts of them together for you from an easily understandable format. I don’t consider myself a virtualization expert but I am surely learning quite a lot of this concepts which I plan to share with you all.

Hardware Innovations and considerations

The hardware requirements of Windows Server 2012 Hyper-V help to ensure that it is installed correctly and makes optimum use of virtualization technology. Hyper-V requires a 64-bit processor that includes hardware-assisted virtualization and hardware-enforced Data Execution Prevention (DEP). Let me take a quick stab at what these actually are:

Hardware-assisted virtualization: This is available in processors that include a virtualization option to enable the full virtualization of host machines. The Windows Server 2012 Hyper-V role supports hardware assisted virtualization processers from the Intel VT and AMD-V processor families. Using this feature, Hyper-V puts a layer between the processors enabled with hardware-assisted virtualization and the host operating system. This facilitates interaction between guest operating systems and the underlying hardware via the host or main operating system for better performance and control over hardware resources.

Hardware-enforced Data Execution Prevention must be available and enabled. Specifically, you must enable Intel XD bit (execute disable bit) or AMD NX bit (no execute bit). More details on specifics can be read from Wikipedia. To use this feature you need to enable knobs from the BIOS and this will vary from the chip manufacturer as mentioned above.

Windows Server 2012 provides different deployment options, including Server with a GUI and Server Core Installation. The Server with a GUI option is the Windows Server 2012 equivalent of the full installation option available in Windows Server 2008 R2. The Server Core Installation option reduces the space required on disk, the potential attack surface, and especially the requirements for servicing and restarting the server.

What I recommend folks are, use the Server Core Installation option for setting up a SQL Server virtualization environment. This helps to reduce the space required on disk and the potential attack surface. It also helps to better separate management and deployment activities, reduce the overhead of updating patches, and minimize the requirements for servicing and restarting the server.

Note: I highly recommend checking the Windows Server Catalog lists for thousands of hardware and software items compatible with Windows Server 2012.

Scalability by numbers with Windows Server 2012 

Windows Server 2012 Hyper-V provides significant scalability improvements over Windows Server 2008 R2 Hyper-V. These below features help to ensure that the virtualization infrastructure is compatible with the largest scale-up servers and can support the configuration of large, high-performance virtual machines to handle workloads that might need to scale up significantly.

System  Resource  Windows Server 2008 R2 Hyper-V  Windows Server 2012 Hyper-V 
Host  Logical Processors  64 320
Physical Memory  1 TB  4 TB 
Virtual CPUs per Host  512 2048
VM  Virtual CPUs per VM  4 64
Memory per VM  64 GB  1 TB 
Active VMs per Host  384 1024
Guest NUMA  No  Yes 
Cluster  Maximum Nodes  16 64
Maximum VMs  1000 8000

Significant improvements also have been made within Windows Server 2012 Hyper-V to support increased cluster size and a higher number of active virtual machines per host. Windows Server 2012 Hyper-V supports up to 8,000 virtual machines on a 64-node failover cluster. In addition, more advanced performance features such as in-guest NUMA are supported by Windows Server 2012 Hyper-V virtual machines.

I think this is lot of information to digest in a single day and do research, the next blog on this series will be around Virtualization and understanding computation (Logical Processors, Virtual Processors, NUMA, host reserve etc). Stay tuned.

Continue reading...


 

Virtualization Journey with SQL Server December 16th, 2013

Vinod Kumar

With the proliferation of applications in everyday use, enterprises have an increasing need for more instances of databases such as SQL Server. Most applications have their own set of database requirements, leading to the use of multiple versions of databases and to significant costs related to the databases and related hardware resources. More importantly, the hardware deployed for databases is not fully utilized or there is a demand to scale up hardware resources to meet peak utilization on certain databases. Therefore, it has become important to control the cost of databases  and related hardware resources, and to optimize and scale the use of hardware resources in different scenarios to provide better flexibility and maintain service level agreements (SLAs). An ideal solution to this problem is virtualization.

Virtualization is fairly common now. Many organizations worldwide have moved beyond the nascent stage into being more advanced users of server virtualization, specifically. These organizations have gained benefits in the areas of costs, efficiency, operations, availability, agility, and resiliency.

Microsoft SQL Server 2012 and Windows Server 2012 provide a host of new features that can be used to effectively virtualize demanding database workloads that previously were not considered for virtualization. Let me take baby steps in this understanding of Virtualization and what one needs to know in this topic area – this is most likely to be multiple part post, let me start on some basics.

Note: This is an important topic because close to 50% enterprises I get to talk with have already deployed their Tier-2 application already in an virtualized environments and close to 25% or more are planning to deploy in the immediate near future too. So these discussions I have with folks are always around the best practices.

Why Virtualize?

Organizations today want the ability to consistently and coherently develop, deploy, and manage their services and applications across on-premises and cloud environments. New and enhanced capabilities in Windows Server 2012 Hyper-V can help customers reduce costs, while at the same time providing increased agility and flexibility.

Performance and Scalability: Because SQL Server can use an operating system’s maximum processor and memory capacity, Windows Server 2012 provides support for up to 640 logical processors (cores) over 64 sockets and up to 4 TB of memory (RAM).

The NIC Teaming feature in Windows Server 2012 helps improve the reliability of the networking system and ensures high availability of the network. It also improves the network throughput for SQL Server data. (These days, I recommend this feature to all my customers with this).

Windows Server 2012 features improvements in Server Message Block (SMB), including the ability to store SQL Server database files on remote file shares, it also offers multiple deployment options for database server storage. More about storage in future blogs.

Availability: Windows Server 2012 supports running SQL Server 2012 on Windows Server Core. This helps to reduce the surface area for attack and reduces the need to apply patches at the operating system level.

With the Cluster Aware Update feature of Windows Server 2012, maintenance of SQL Server cluster nodes can be automated, reducing downtime and improving reliability. With dynamic quorum management and the SQL Server AlwaysOn features, SQL Server clusters can achieve extremely high availability.

By combining Windows Server 2012 with System Center 2012, administrators can comprehensively manage demanding applications (such as SQL Server 2012 workloads) as well as the infrastructure – including physical and virtual resources—in an integrated and unified manner. Some of the benefits I talk with customers are:

  1. Higher capacity vCPUs (up to 64), Memory (up to 1  TB), and virtual machine density (up to 8,000 per cluster).
  2. Hyper-V support on Non-Uniform Memory Access (NUMA) and Fibre Channel.
  3. Faster and simultaneous live migration and dynamic quorum support in SQL
    Server AlwaysOn cluster.
  4. Same management tool (System Center) for SQL Server virtual machines in both private and public clouds.

Now that I have put the fundamental building blocks or reasons to virtualize, I will blog in future posts around:

  1. Hardware innovations
  2. Compute considerations
  3. Storage considerations
  4. Networking considerations
  5. SQL Configurations etc

As this is an important topic, let me know if you want me to write on specific topic around Virtualization and SQL Server. And also let me also know if your organizations are running SQL Server inside a virtualized environments? Are there problems that you wished were explained anywhere? Let me know and I will cover them in future posts.

Continue reading...


 

SQL Server AlwaysOn–Adding node fails December 11th, 2013

Vinod Kumar

Last week I got a call from our internal deployment teams that when they were adding a node to Windows Cluster for SQL Server AlwaysOn it was timing out and it was some sort of latency issues. It was interesting because the latencies between the two datacenters which were far apart (Delhi and Hyderabad) was around 28ms. The best way for me to understand what was going on was to understand what is happening behind the scenes.

First, I asked what their current setup was. They explained they were planning to achieve the architecture as shown below. They were able to setup on the Primary DC1 the two servers SRV1 and SRV2. Now on the Windows Cluster they were trying to add the third node (SRV3) and it was throwing an error. The same was the case when they tried to add SRV4 node.

The usual ping, tracert etc yielded no big information for us. Infact there was no problem in connectivity between the sites when this operation was performed. At this point in time, it got clear it is not an SQL Server AlwaysOn problem but more of a Windows Cluster Problem that we had in our hands.

The next step was to actually get the Cluster Error Logs and most importantly we wanted to see the actual error message.

Failed to access remote registry on ‘OLTPDB.POC.MYDOMAIN.IN’. Ensure that the remote registry service is running, and have remote administration enabled.

The error message was interesting because it didn’t mention anything about latencies and the deployment partner was actually troubleshooting in the wrong direction.

Actual Solution

It is interesting to find what could have gone wrong.

  1. Firewall is blocking Remote Registry connection between SRV1 and SRV3/SRV4
  2. Though Cluster port 3343 is open, Remote Registry is needed.
  3. Remote Registry works on RPC which uses Dynamic Ports + Port 135

Once we figured out this problem, we had to involve the Network Team to open Firewall for Dynamic Ports or Open for all communications for the specifically Cluster nodes on both sides.

If you are interested in knowing about Remote Registry and how to query the ports, use the Port Query Tool.

It is worth to mention the ports assignment for RPC:

 Service Name

UDP

TCP

HTTP

80, 443, 593

80, 443, 593

Named Pipes

445

445

RPC Endpoint Mapper

135

135

RPC Server Programs

<Dynamically assigned>

<Dynamically assigned>

On customer side the port analysis revealed something interesting. We had to open the communication port of 445 in this specific case.

Port

Protocol

Mode

Status

1433

TCP

Two way

Listening

5022

TCP

Two way

Listening

3343

TCP/UDP

Two way

Listening

135

TCP

Two way

Listening

137

UDP

Two way

Listening

445

UDP/TCP

Two way

Not Listening

The issue was closed as soon as the team worked with the networking team. This was an important learning for us in multiple ways:

  1. SQL Server AlwaysOn is just not about SQL Server, we need to have our Windows Team also involved.
  2. Sometimes a Windows Error message can lead us to Network and Infrastructure requirements that we normally oversee off.
  3. It is a team work of ALL parties (SQL Administrator, Windows Administrator and Network Administrator).

Finally, wanted to mention – Learning is a journey and I seem to be learning something every single day.

This post is inspired from Book content: SQL Server 2012 AlwaysOn Joes 2 Pros®: A Tutorial for Implementing High Availability and Disaster Recovery using AlwaysOn Availability Groups” (Paperback, Kindle).

Continue reading...