Author Archive

SQL Server health check using PowerShell and T-SQL   15 comments

I am back with another interesting blog which hopefully the production DBAs would find more useful. We often have the need to capture aggregated data related to SQL Server health which can not only be captured quickly but also be able to customize as per the requirements.

We have many tools available to capture the performance data but it mostly has some data lag and does not tell us what’s currently running on the system.

Since last few days, I have been working on a script based solution which helps us to perform quick health check of our production instance to resolve any production issue with this blog, I intend to share the solution as I have found it quite useful Read the rest of this entry »

Query Store: Exploring new features in SQL Server – vNext   1 comment

Troubleshooting performance problem is one of the challenging and most often faced situation in DBA’s life. Following diagram shows three major scenarios where DBA’s get involved and spend nights troubleshooting performance problems.

Note: This is with community technical preview 2 of SQL Server 2016, things may change with the RTM release

18

Read the rest of this entry »

[Part-5]Private Cloud: Some common issues and troubleshooting tips   Leave a comment

This is the fifth and final 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:

 

1. PrivateCloud_Icon[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 this blog I will provide some troubleshooting tips e.g. where to look in case of any error and few scenarios.

When it comes to troubleshooting, usually, the following questions comes into mind:

  1. Log files: Where and what to look at?
  2. Troubleshooting example
  3. Common issues/errors

I am going to cover the above mentioned topics in this blog post. Read the rest of this entry »

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

This is fourth 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 this blog post, we will create a plan, assign this plan to the user and then provision a Virtual Machine and a Database.

Before we proceed, let me explain what is a plan and why do we need to assign a user to it. Read the rest of this entry »

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

This is third 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 this blog post, we will install and configure WAP followed by configuration of SPF, SCVMM and SQL Server on WAP. I have divided it in two sections:

Section-1: Install and Configure Windows Azure Pack

  • Installing Windows Azure Pack: Online installation
  • Installing Windows Azure Pack: Offline installation
  • Configure Windows Azure Pack

Section-2: Configure SPF, SCVMM and SQL Server on Window Azure Pack

  • Configure SPF and SCVMM on Windows Azure Pack
  • Configure SQL Server on Windows Azure Pack

Read the rest of this entry »

[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 »