Author Archives: Sudeepta Ganguly

About Sudeepta Ganguly

A SQL Server User... Still Learning

Unable to access SQL Error Log using SSMS

Posted on January 5, 2016

Recently my laptop was upgraded to Windows 10. Today while I was trying to access the SQL Server error log on my express instance (by executing xp_readerrorlog), I received the below error. Msg 22004, Level 16, State 1, Line 0Failed … Continue reading →

Posted in How To, Just Learned, SQL Server, SQL Server Log, SQL2012 | Tagged , , , | Leave a comment

Setup LAB: 06 Installing Windows Failover Cluster to setup AlwaysOn

Posted on December 28, 2015

In the last post, I had configured the iSCSI target service to share the disk between two servers. I am going to use those two servers as Windows server Failover Cluster nodes and setup AlwaysOn availability group using that. To … Continue reading →

Posted in AlwaysOn, Clustering, How To, Setup LAB, SQL2012, TestLab | Tagged , , , , , | Leave a comment

Setup LAB: 05 Configuring the iSCSI Target

Posted on December 24, 2015

In the previous post, I had installed the iSCSI Target service and create the volume using File and Storage Service. In this post, let’s configure the iSCSI Target Service. To begin with, open Server Manager, expand File and Storage Service … Continue reading →

Posted in AlwaysOn, Clustering, How To, Setup LAB, SQL2012, Storage Server, TestLab | Tagged , , , , , , | 1 Comment

Setup LAB: 04 Setting up a Storage Server

Posted on December 17, 2015

Whenever we setup a Cluster in a LAB environment, often the biggest challenges in the whole process is, how to configure the storage server. A user reported that, the configuration steps mentioned on my blog for the FreeNAS server is … Continue reading →

Posted in AlwaysOn, Clustering, How To, Setup LAB, SQL2012, Storage Server, TestLab | Tagged , , , , , , | 1 Comment

Availability Group Listeners Creation Issue

Posted on September 30, 2015

I must admit, that I was facing this issue since a while. I was trying to setup a lab to have a hands on with AlwaysOn feature; however the Availability Group Listeners creation was failing. As I started looking into … Continue reading →

Posted in AlwaysOn, How To, Just Learned, Setup LAB, SQL Server, SQL Server Configuration, SQL Server HA, SQL2012, TestLab | Tagged , , , , , , | Leave a comment

Removing a SPN Entry

Posted on August 3, 2015

At times, we may require to remove a wrongly created SPN entry. The syntax for removing a SPN entry is: setspn.exe -D “SPN entry, which needs to be removed” “Service Account or Server Name” Over the weekend, I was working … Continue reading →

Posted in SQL Server | Tagged , , , , , | Leave a comment

SQL Server is consuming more than 17000 handles !!!

Posted on July 7, 2015

Well, these days, this is a topic of discussion most of the time & when this evening I encountered this again, I thought of writing this post for my future reference. While analysing a slow performance issue on a server, … Continue reading →

Posted in How To, SQL Server | Tagged , | Leave a comment