A blog about real-life SQL Server Troubleshooting, providing solutions that actually work. By a SQL Server Enthusiast.
Caching in SQL
Cluster Failover RCA
Cluster Failover Root Cause Analysis
Could not clear 'DIFFERENTIAL' bitmap in database
could not find a login matching the name provided
Exit Code Returned: 11009
Failed mirror comes online after restart
failed to find installation media path due to datastore exception in FindSetupFolder()
Failed to launch local setup100.exe: 0x80070003
failed to run patch request for instance
Ghost record cleanup
how it works
index cannot be created
IO requests taking longer than 15 seconds
large delete statement
MSP returned 1603: A fatal error occurred during installation
Peer 2 Peer Replication
service account format
Space not getting free
SQL Server 2008 R2
SQL 2008 R2
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server could not spawn FRunCommunicationsManager thread
SQL server memory management
Subject Alternative Name
the differential or bulk-logged bitmap overstates the amount of change that will occur with the next differential or log backup
The statement has been terminated. (Microsoft SQL Server
troubleshooting I/O performance
Unable to create new account test for SMTP server Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer
Verify Backup Integrity
Windows Internal Database
Browse by Tags
sql server 2008 r2
Tagged Content List
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...
15 Mar 2013
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,...
12 Feb 2013
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...
3 Sep 2012
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...
3 Sep 2012
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... ----------------------------...
22 Aug 2012
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...
9 Aug 2012
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...
7 May 2012
SQL, Sharepoint and the Windows Internal Database – an interesting saga
This one is for all my friends out there who use Sharepoint. A default Sharepoint installation enables/installs the Windows Internal database, and creates its databases on it. The Windows Internal Database is, in a way, a special edition of SQL Server, in the sense that it’s not a Full version...
6 Apr 2012
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...
26 Mar 2012
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…...
15 Mar 2012
Page 1 of 1 (10 items)
© 2014 Microsoft Corporation.
Privacy & Cookies