An interesting issue with Peer to Peer Replication

I recently ran into an interesting issue when setting up Peer 2 Peer Replication across 3 instances. The primary instance was SM-UTSQL, where we configured a Peer-to-Peer publication named "PUBLISH1" on the database "DDS-TRANS". Next, we proceeded to configure Peer-to-Peer topology (right-click on publication, click on "Configure Peer-To-Peer topology"), and added the other 2 instances…

2

Something to watch out for when using IS_MEMBER() in TSQL

I recently worked on an interesting issue with my good friend Igor (@sqlsantos), where we were facing performance issues with a piece of code that used the IS_MEMBER () function. Basically, the IS_MEMBER function is used to find out whether the current user (windows/sql login used for the current session) is a member of the…

8

SQL Server patch fails with "Could not find any resources appropriate for the specified culture or the neutral culture"

I recently worked on a number of issues where SQL Server Service Pack/patch installation would fail, and we would see this error in the relevant Detail.txt (located in C:Program FilesMicrosoft SQL Server100Setup BootstrapLog<Date time of the installation attempt> for SQL 2008/2008 R2):   2013-04-07 20:14:07 Slp: Package sql_bids_Cpu64: – The path of cached MSI package…

0

How To: Troubleshooting SQL Server I/O bottlenecks

One of the most common reason for server performance issues with respect to SQL Server is the presence of an I/O bottleneck on the system. When I say I/O bottleneck, it can mean issues like slow disks, other processes hogging I/O, out-dated drivers, etc. In this blog, I will seek to outline the approach for…

27

SQL 2005 patch fails with 1642 “Unable to install Windows Installer MSP file”

This one is for all my DBA friends out there. I recently ran into this issue when running a security patch installation for a SQL 2005 instance on SP4. The setup failed, and when I looked into the “C:Program FilesMicrosoft SQL Server90Setup BootstrapLogHotfix” folder (this is where the patch setup files for 2005 are to…

1

SQL 2005 Patch on cluster might fail with “No Passive nodes were successfully patched”

This is one of those “rare” setup issues you might run into, on a “Bad luck” day. The patch fails, and in the summary.txt, you see this at the bottom:- Summary      No passive nodes were successfully patched      Exit Code Returned: 11009 Looking at the hotfix.log, you find this:- 03/18/2012 11:57:51.200 MSP Error: 29527 …

2