Sakthi's SQL Server Channel

A window to express my views about SQL Server Database Management System.

User realm discovery failed from ADOMD

This is a short blog post to share a solution to the error "User realm discovery failed". This is a...

Author: Sakthivel Chidambaram Date: 01/25/2018

Error: "Could not retrieve backup settings for primary" in Log shipping Backup job

This one is simple but interesting... Log shipping which was running for an year, suddenly stopped...

Author: Sakthivel Chidambaram Date: 06/13/2012

Wow... We have MAXDOP calculator for SQL Server... It makes my job easier...

So after Max. Server Memory calculator, to make your life much more easier, here is the Max Degree...

Author: Sakthivel Chidambaram Date: 05/23/2012

Cool... Now we have a calculator for finding out a Max. Server Memory value

This calculator is now withdrawn since I'm not able to invest my time to improve it to make it "stay...

Author: Sakthivel Chidambaram Date: 05/18/2012

SQL Server 2012 Upgrade Technical Guide & What's new Whitepaper Released

SQL Server team has published the "SQL Server 2012 Upgrade Technical Guide" at...

Author: Sakthivel Chidambaram Date: 05/15/2012

INF:What happens to a database when transaction rollback fails?

Today while working on a SQL Server performance case, I was asked this question "What happens to a...

Author: Sakthivel Chidambaram Date: 05/08/2012

"Failed to save Local Policy Database" while granting any privilege to SQL Service SID in Group Policy Editor

When you try to grant any privilege to SQL Server Service SID using Group Policy Editor in Windows...

Author: Sakthivel Chidambaram Date: 05/05/2012

"stop before startup" after "Using large pages for buffer pool" during SQL Server startup

Worked on a SQL Server startup issue which I would like to share here: Here is how the SQL Server...

Author: Sakthivel Chidambaram Date: 04/18/2012

Restore database stuck at 90% waiting on PREEMPTIVE_OS_WRITEFILEGATHER

There are already few blogs and a KB to talk about this problem so I'm trying to tie them together...

Author: Sakthivel Chidambaram Date: 04/11/2012

Re-configure Replication after restoring publication database from Backup - Replication Scenario

Sharing one of the interesting scenario I worked today. Somebody messed up the data at publication...

Author: Sakthivel Chidambaram Date: 03/14/2012

Now Connect PHP website running in Linux Apache Webserver to SQL Server

How? Here is the answer: Preview of SQL Server ODBC driver for Linux is now available for download:...

Author: Sakthivel Chidambaram Date: 11/29/2011

Snapshot replication fails after adding a column to a table (article)

This post is all about "replicate_dll" property in sp_addpublication, so if you are aware of this...

Author: Sakthivel Chidambaram Date: 11/29/2011

OPTIMIZE FOR UNKNOWN in SQL Server 2005

Just helped a performance problem with the information below and thought of sharing since it might...

Author: Sakthivel Chidambaram Date: 11/29/2011

Error: 17127 "No memory for kernel buffer hash table" during startup along with FAIL_PAGE_ALLOCATION 262

This is a simple information sharing post because there is nothing much to troubleshoot... SQL...

Author: Sakthivel Chidambaram Date: 11/15/2011

Large Network Packet Size and Memory Pressure in SQL Server

Today I worked on a interesting performance issue whereby SQL Server 2005 x86 (32-bit) had sever...

Author: Sakthivel Chidambaram Date: 11/09/2011

How to troubleshoot - "Incorrect syntax near - Source: MSSQLServer, Error number: 102)" errors in replication

A quick guide on how to troubleshoot Incorrect syntax near - Source: MSSQLServer, Error number:...

Author: Sakthivel Chidambaram Date: 10/06/2011

-MaxBCPThread parameter for Snapshot and Distribution Agent in SQL Server Replication

If you have researched about replication enhancement, for sure you would have heard about this...

Author: Sakthivel Chidambaram Date: 08/07/2011

Error: 18056 State: 29 The client was unable to reuse a session. The failure ID is 29 after upgrading SQL 2000 to SQL 2008 SP2

I want to share this troubleshooting scenario since it may help you: After upgrading SQL Server 2000...

Author: Sakthivel Chidambaram Date: 07/06/2011

Video Tutorial on Managing Virtual Log Files (VLF) in SQL Server

Do you know what is VLF? Are you aware that as a SQL Server DBA, you need to take care of the VLF...

Author: Sakthivel Chidambaram Date: 06/11/2011

AUTO_CLOSE and performance issue in a .NET application

One of the interesting scenario I worked recently. .NET application which has multiple tabs showing...

Author: Sakthivel Chidambaram Date: 05/23/2011

SQLSPIDAnalyzer.sql - My way of monitoring a particular request in SQL Server

Since a long time I wanted to leverage the details from the DMV dm_tran_database_transactions into...

Author: Sakthivel Chidambaram Date: 05/21/2011

Best Performer: Distributed query (Four-part) or OPENQUERY when executing linked server queries in SQL Server

I wanted to share this information to all those who are searching for better performer when it comes...

Author: Sakthivel Chidambaram Date: 05/08/2011

What is WRITELOG waittype and how to troubleshoot and fix this wait in SQL Server

<<This blog has been updated on 12/23/2014>> What does WRITELOG waittype mean? SQL...

Author: Sakthivel Chidambaram Date: 04/16/2011

Service Broker "Fire and Forget Scenario" and Memory Allocation failure

"Fire and Forget" is a scenario in Service Broker where Initiator starts a conversation -> Sends...

Author: Sakthivel Chidambaram Date: 04/04/2011

Max. Worker Threads and when you should change it

This is a get started post for this topic and I will be adding more content as and when it is...

Author: Sakthivel Chidambaram Date: 03/13/2011

Importance of setting Max Server Memory in SQL Server and How to Set it

UPDATE: This blog is applicable for SQL Server versions till SQL 2008 R2. Memory Manager has changed...

Author: Sakthivel Chidambaram Date: 03/11/2011

"Show Server Trace" Feature for SQL Server 2005 to analyze Stored Procedure and T-SQL Execution

Many of you might be missing the "Show Server Trace" feature of SQL Server 2000 Query Analyzer in...

Author: Sakthivel Chidambaram Date: 03/10/2011

T-SQL Query Script to monitor Memory Usage of a SQL Server Instance

If you are using Task Manager to monitor the Memory Usage of SQL Server, please note that Working...

Author: Sakthivel Chidambaram Date: 02/28/2011

Query to find what modules are loaded inside SQL Server VAS (Virtual Address Space)

Code of sqlservr.exe and any other dll's it depends on need to be loaded into SQL Server memory...

Author: Sakthivel Chidambaram Date: 02/23/2011

Difference between KILL and KILL WITH STATUSONLY – Estimate Rollback completion time

While I was talking to a customer during a replication scenario, customer asked me a question about...

Author: Sakthivel Chidambaram Date: 02/23/2011

Convert Page ID offset address to Page Number

Here is a handy reference for converting Page ID offset address to corresponding Page Number in SQL...

Author: Sakthivel Chidambaram Date: 02/23/2011

Troubleshooting slow running query using Extended Events Wait info event

Extended Events introduced in SQL Server 2008 is a detailed event infrastructure for SQL Server. If...

Author: Sakthivel Chidambaram Date: 02/20/2011

Troubleshooting SQL Server I/O requests taking longer than 15 seconds - I/O stalls & Disk latency

SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete...

Author: Sakthivel Chidambaram Date: 02/09/2011

Different Status of a SPID in SQL Server and What do they mean

You can check the status of a SPID using any of these queries: SELECT status,* FROM sys.sysprocesses...

Author: Sakthivel Chidambaram Date: 02/08/2011

Troubleshoot Connectivity/Login failures (18456 State x) with SQL Server

I know that there are lot of articles over the internet world with this topic... But this article is...

Author: Sakthivel Chidambaram Date: 02/06/2011

Script existing server side trace to create a new trace with same definition

I wrote this script today and thought of sharing since it might be useful for you. I wrote it...

Author: Sakthivel Chidambaram Date: 12/21/2010

Login failed for user 'sa' while installing SQL Server 2005

I was working in a SQL Server 2005 setup case which failed while starting SQL Service with error:...

Author: Sakthivel Chidambaram Date: 09/01/2010

Rule "Same architecture installation" failed while installing SQL Server 2008 R2

Error: Installating DEFAULT instance of SQL Server 2008 R2 Express Edition with Advanced Services on...

Author: Sakthivel Chidambaram Date: 08/31/2010

"Wait on the Database Engine recovery handle failed" while installing SQL Server 2008

I worked on a customer service request where SQL Server 2008 Enterprise edition installation was...

Author: Sakthivel Chidambaram Date: 08/31/2010

How to define backup interval for Full, Differential, TLog

Designing an effective SQL Server backup/Restore strategy Designing an affective backup and restore...

Author: Sakthivel Chidambaram Date: 06/02/2010

Who is connected when in Single User Mode

Here is how to find out who is connected to your server when you are in single user mode: METHOD 1:...

Author: Sakthivel Chidambaram Date: 06/01/2010

Welcome to my MSDN Blog

Hello! My name is Sakthivel Chidambaram. I work with SQL Server Product Support team at Microsoft....

Author: Sakthivel Chidambaram Date: 05/26/2010