SQL Journey

A blog about real-life SQL Server Troubleshooting, providing solutions that actually work. By a SQL Server Enthusiast.

Browse by Tags

Tagged Content List
  • Blog Post: When using SSL, SQL Failover Cluster Instance fails to start with error 17182

    I recently worked on an interesting issue with a SQL Server Failover Cluster Instance (FCI). We were trying to use an SSL certificate on the instance, and we followed these steps: Made sure the certificate was requested according to the requirements defined here . Loaded the certificate into the Personal...
  • Blog Post: An interesting issue with SQL Server Script upgrade mode

    Here's another common issue that I've seen quite a few people run into of late. When you run a patch against SQL Server, the patch installs successfully, but on restart, SQL goes into "script upgrade mode" and you're unable to connect to it. Upon looking at the errorlog, you see something like...
  • Blog Post: An in-depth look at SQL Server Memory–Part 3

    In part 1 and part 2 of the series, we talked about the memory architecture and the Procedure Cache respectively. In this third and final instalment of the SQL Server Memory series, I will look to focus on troubleshooting SQL Server Memory pressure issues.   Before we start on the troubleshooting...
  • Blog Post: An in-depth look at SQL Server Memory–Part 2

    Before you read this, I would strongly recommend reading Part 1 first. The memory architecture evolved in a big way from SQL 2000 to 2005. Basically, in 2000, all we had was the procedure cache (used to cache compiled plans and execution plans, execution contexts, etc.) and the buffer pool. However,...
  • Blog Post: An in-depth look at SQL Server Memory–Part 1

    I know that memory management in SQL Server is one area that’s a bit of an enigma for a lot of people, and most of us only tend to know as much about memory as is related to our day-to-day activities. In this post(and others in this series), I shall seek to do a deep dive into SQL Server memory...
  • Blog Post: SQL Server Cluster Failover Root Cause Analysis–the what, where and how

    I know many of you get into situations where SQL Server fails over from one node of a cluster to the other, and you’re hard-pressed to find out why. In this post, I shall seek to answer quite a few questions about how to about conducting a post-mortem analysis for SQL Server cluster failover, aka Cluster...
  • Blog Post: Migrating TFS from SQL Server Enterprise to Standard can cause problems due to compression

    When migrating a Team Foundation Server from SQL Server Enterprise to Standard , you might run into this error: Restore Failed For Server ‘< Servername >’, (Microsoít.SqlServer.SmoExtended) Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft...
  • Blog Post: When DBMail started complaining about the servername being NULL

    I recently came across an issue, where, for some reason, DBMail was not working. To be more specific, we were unable to create a profile for DBMail, let alone send emails. When trying to add the profile to the account, we were getting this error: TITLE: Configuring... ----------------------------...
  • Blog Post: An interesting issue with SQL Replication and a rogue system spid

    I recently came across this interesting issue with SQL Replication. We were trying to create a new publication, and the new publication wizard would just hang. Upon doing some investigation, we found that we were hitting the connect article mentioned here . However, the connect article mentions that...
  • Blog Post: An in-depth look at Ghost Records in SQL Server

    Ghost records are something that are a bit of an enigma for most folks working with SQL Server, and not just because of the name. Today, I’ll seek to explain the concept, as well as identify some troubleshooting techniques. The main reason behind introducing the concept of Ghost records was...
  • Blog Post: SQL 2008/2008 R2/2012/2014 setup disappears/fails when installing Setup Support files

    I’m sure many of you would have seen this issue when running SQL 2008/2008 R2/2012 setup on a new server. The setup will proceed to install Setup support files, the window will disappear but, strangely enough, the next window never shows up. Here’s what you need to do: Click on start->run and type...
  • Blog Post: SQL Server Resource database corruption–yes, it’s possible

    It’s very rare that I run into an issue with the Resource database, and the one I ran into recently was rarer still. But before I get into the nitty-gritty of the issue, let us begin by outlining a few details about the resource database: The Resource database The resource database is a hidden...
  • Blog Post: Access Violation dumps and metadata corruption

    This is an issue that I had been busy working on these past few days. We were getting AV dumps on the DB, and when I looked at the stack, I found that SQL was calling a function to get the name of a column(given a table name), an index id and key id. This function call resulted in a an exception being...
  • Blog Post: VSS backups might cause SQL to generate Non-Yielding Scheduler dumps if Backup verification is turned on

    Found an interesting Non-Yielding scheduler recently. Opened the dump, and found function calls related to backup verification (such as validating the file name, verifying that the drive is part of the cluster group, etc.) at the top of the stack: Child-SP RetAddr Call Site 00000000`29cda478 000007fe...
  • Blog Post: SQL Server Service Pack installation may fail if your instance name is a Windows reserved word

    Okay, so I woke up one morning and decided that this was a good day to patch my SQL Server 2008 R2 instance (named LPT2) to Service Pack 1. So I just downloaded the Service Pack from the Microsoft website, ran it, and was going through the screens, whistling softly to myself, when….CRASH…...
Page 1 of 1 (15 items)