[Part-2]Private Cloud: Configure SCVMM and SPF   3 comments

This is second post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 

Here is a list of topics for the entire series:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In the first part of the series, we installed SCVMM and SPF. Now, we will configure SCVMM to make it cloud aware followed by configuration of SPF. Here is a quick overview of what we are going to do in this post:

 

1.   Configure System Center virtual machine manager (SCVMM)

1.1. Create and add a sysprep VHD file to VMM library

1.2. Add a physical host to VMM

1.3. Create a hardware profile for your VM’s.

1.4. Create a VM template and attach hardware profile and sysprep VHD to template

1.5. Create a logical network

1.6. Create a cloud and attach all the above details to cloud.

 

2.   Configure Service Provider Foundation (SPF)

Read the rest of this entry »

[Part-1]Private Cloud: Introduction and installation of pre-requisites   4 comments

Today, I am going to kick off an interesting series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 

The series will be divided into the following five posts:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

Let’s have a quick introduction to Windows Azure Pack (WAP) before you proceed further.

Read the rest of this entry »

Jan 14th 2015: PASS DBA VC Presentation on SQL Server Dump Analysis   2 comments

Further to my blog post I would like to thank you all for attending my recent presentation on SQL Server Dump Analysis for PASS DBA Virtual Chapter on  Jan 14th 2015.

The presentation was well received with a good number of attendees joining the session. Post presentation, I was asked to present extended multiple deep-dive sessions which I will be planning  for.

For those, who either could not attend or want to see it again, I have embedded the presentation materials in this post.

Here are the slides of the presentation:

Read the rest of this entry »

Learn n Win : Presenting on “SQL Server Dump Analysis” at PASS DBA Virtual Chapter   6 comments

pass_vc_dba_logoI am excited to be speaking at PASS DBA Virtual Chapter on Wednesday Jan 14th. Here is the topic, abstract and schedule of the session:

 SQL SERVER DUMP ANALYSIS (SPONSORED BY DELL SOFTWARE)

While dealing with SQL Server administration, you might have come across scenarios when a  session terminates abruptly, SQL Server instance crashes, SQL Server cluster fails over without a  graceful message. Most often, it leaves a dump file behind which is unfortunately not in a human readable format. In this one hour session, you will learn the basics of a dump file, the tools available for reading thru a dump, the different types of dumps and demos on various debugger commands, how to analyze a dump file to establish the root cause.

DateJanuary 14th 12:00 noon Mountain time (click here to see it in your local time)

If you are a SQL Server DBA willing to dig into dump files which you can’t read just like you read the ERRORLOG, come and join us on this Wednesday Jan 14th to find the exciting stuff. This is a FREE session, you just need to be a member of PASS in order to register. You also stand a chance to win a $100 gift card from Amazon once you register for the session. The winner will be declared through a draw.

Registration: You must register if you want to attend. You can register here

We already have a number of registrants. Hurry up and do share and tweet about this.

See you on Wednesday!
Happy learning!!

FIX:Replicated transactions are waiting for next Log backup or for mirroring partner to catch up   2 comments

Recently I have come across one challenging issue and thought of sharing with you all.

We have a SQL Server instance with replication setup. This replication setup is little different than normal. Customer is using script based replication setup wherein for each table they have separate publisher and subscriber. There were around 100 such publishers.

The issue started when log reader agent at subscriber failed with the error message below:

"Replicated transactions are waiting for next Log backup or for mirroring partner to catch up."

Read the rest of this entry »

How to recover database from In-Memory table corruption   3 comments

Hello All,

Corruption in your production database!! Always sounds scary isn’t it?

How about corruption in In-Memory OLTP table?? It’s even scarier…..

You may have situation where you have created an In-Memory database which contains both disk based and memory optimized tables. What will happen if you have corruption in one of the memory optimized tables? You will find the database in Restore_Pending state.

Easiest way to come out from this situation to restore from backup. Unfortunately in this situation we do not have backup so somehow we need to bring the database online. Remember, we cannot run DBCC CHECKDB on Memory optimized tables as well. Stuck, isn’t it? Read the rest of this entry »

Why is affinity mask negative in sp_configure   Leave a comment

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value.

 

name                                minimum     maximum     config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask                       -2147483648 2147483647  -1066394617  -1066394617

 

This output was from a SQL Server 2008 R2 instance running on Windows Server 2008 R2.

 

Affinity mask is a SQL Server configuration option which is used to assign processors to specific threads for improved performance. To know more about affinity mask, read this. Usually, the value for affinity mask is a positive integer (decimal format) in sp_configure. The article in previous link shows an example of binary bit mask and corresponding decimal value to be set in sp_configure. Read the rest of this entry »