Posts Categorized: Technical Blog

How SQL Server Browser Service Works

Some of you may wonder the role SQL browser service plays in the SQL Server instance. In this blog post, I’ll provide an overview of the how SQL Server browser plays crucial role in connectivity and understand the internals of it by capturing the network monitor output during the connectivity with different scenario. Here is an executive…

Unexpected Shutdown Caused by ASR

In past few days I had two incidents and an outage, for just a few minutes. However, outage in a production environment is related to cost relatively and strictly. The server that had outage was because of failing over and then failing back about 4 to 5 times in 15 minutes. I was holding pager,…

Using SaltStack for Configuration Management

In my last blog post I mentioned that SaltStack is a fully featured configuration management solution, but we never looked into using the tool in that way. Today we will begin to explore some basic examples of configuration management with SaltStack.  We will look at two aspects of configuration management, installing a package, and will…

Changing Failgroup of ASM Disks in Exadata

There was a discrepancy in the failgroups of couple of ASM disks in Exadata. In Exadata, the cell name corresponds to the failgroup name. But there were couple of disks with different failgroup names. Using the following plan to rectify the issue online without any downtime:

Small Files on MapR-FS

One of the well-known best practices for HDFS is to store data in few large files, rather than a large number of small ones. There are a few problems related to using many small files but the ultimate HDFS killer is that the memory consumption on the name node is proportional to the number of…

Cloudera Challenge 2014

Yesterday, Cloudera released the score reports for their Data Science Challenge 2014 and I was really ecstatic when I received mine with a “PASS” score! This was a real challenge for me and I had to put a LOT of effort into it, but it paid off in the end! Note: I won’t bother you…

Auditing Files in Linux

Stat command in Linux can be used to display a file or a file system status. I came across an issue in RHEL4 where a file’s ‘Change time’ is far ahead than the ‘Modification time’ without a change in uid, gid and mode. # stat /etc/php.ini File: `/etc/php.ini’ Size: 45809 Blocks: 96 IO Block: 4096…

Lock Timeout Error While Creating Database

Recently I worked on a issue where a third-party application was failing during the installation. Below was the error returned by the Application. Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222) The application was failing while it was trying to create a database. The application seemed to have a default timeout setting…

Page 4 of 61« First...23456...102030...Last »