Adding node to SQL 2008 cluster does not require SQL restart.

Adding node to SQL 2008 cluster does not require SQL restart. Chris Skorlinski SQL Server Escalation Services We had this question about SQL 2008 virtual cluster.  Question:  Is it possible to add node in existing SQL Server 2008 or 2008 R2 Failover cluster instance without downtime (without stopping SQL Server or MSCS services)? Answer: Absolutely!…


Unexplained Latency in the Distribution Agent using Named Pipe

Unexplained Latency in the Distribution Agent using Named Pipe Chris Skorlinski Microsoft SQL Server Escalation Services. Just wanted to give a heads up about a SQL Replication Distribution Agent Latency problem we observed today.  The Distribution Agent to 1 subscriber was only delivering about 500 cmds/sec while other subscribers were getting 4000 cmds/sec.  We noticed…


ORA-01830: date format picture ends before converting entire input string

ORA-01830: date format picture ends before converting entire input string Chris Skorlinski Microsoft SQL Server Escalation Services Microsoft SQL Server has the ability to REPLICATE data changes to Oracle.  We see more and more customers migrating to SQL Server, then setting up SQL data Replication to move change SQL data back to a legacy Oracle…


How to cleanup Replication Bits

How to cleanup Replication Bits Chris Skorlinski Microsoft SQL Server Escalation Services For SQL 2005 and SQL 2008 the sp_removedbreplication stored procedure works great for removing the SQL Replication bits from a database.  SQL 2000 has an older version of this SP which doesn’t always cleanup the database.  You can use the following steps in…


Finalization Uncovered

I’ve talked about finalization before but based on seeing questions related to it it appears that it deserves some clarification.   First of all, finalization is a mechanism we provide in the CLR wheras Dispose is a programming pattern. See Clearing up some confusion over finalization and other areas in GC for an explanation why…


Customer-Connected Engineering (CCE)

Note: This articles is updated at Customer-Connected Development. I’ve originally shared this in other places and other ways, but I’m consolidating here to make it easier to share a link.  As more teams ask me about Customer-Connected Engineering (CCE), it’s easier to just point them here for a quick overview. Customer Connected Engineering is a…


Unexplained slowness in SQL 2008 on Windows 2008 R2

Chris Skorlinski Microsoft SQL Server Escalation Services A customer called today about an unexplained slowness in SQL Server 2008 on Windows 2008 R2.  All SQL data looked great, no blocking, no obvious IO bottlenecks, just overall slow performance. 976700  An application stops responding, experiences low performance, or experiences high privileged CPU usage if many large…


Published Database Transaction Log continues to Grow!

Chris Skorlinski Microsoft SQL Server Escalation Services A customer recently noticed their Published database transaction log would continue to grow until they backed up the Distribution database.  DBCC OPENTRAN() Oldest distributed LSN     : (0:0:0) Oldest non-distributed LSN : (982:100898:1) –> 0x000003D6 : 00018A22 : 001 — Commit Tran(sp_replshowcmds)  0x000003D6:00018A22:0004 select  [Current LSN],[Operation],[Transaction ID], Left([Description],20) from::fn_dblog(‘0x000003D6:00018A22:001′,’0x000003D6:00018A22:0004’)…


Determine Transactional Replication workload to help resolve data latency

Chris Skorlinski Microsoft SQL Server Escalation Services Latency problems are often caused when series of transactions are trying to move a large batch of commands from the Publisher to the Distributor to the Subscribers.  The queries below show overall rows counts and index statistics for commands stored in the Distribution database. Use the results of…