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...
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...
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...
Date: 05/23/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...
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...
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...
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...
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...
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...
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:...
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...
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...
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...
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...
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:...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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:...
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...
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...
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...
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:...
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....
Date: 05/26/2010