Usage of xp_servicecontrol is unsupported

I have seen some posts (and some forums) discussing about using xp_servicecontrol. There was also a ticket opened where xp_servicecontrol reports a wrong status of some of the SQL Server services. I wanted to make sure that everyone knows that xp_servicecontrol is an undocumented XP.  This XP has been a part of SQL Server since 7.0…

0

SQL Server 2008 transactional replication to DB2 subscriber can fail with: DB2OLEDBV2: Error "System.DllNotFoundException: Unable to load DLL ‘mseidrda.dll’: The specified module could not be found

Recently came across a situation where the DB2 subscriber was failing with the below <error>DB2OLEDBV2: Error “System.DllNotFoundException: Unable to load DLL ‘mseidrda.dll’: The specified module could not be found</error>DB2 provider was installed from the SQL Server 2008’s feature pack-http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4 To resolve this, we removed the Microsoft.HostIntegration.DataAccessLibrary.dll file located in the C:\Windows\assembly directoryAfter this, we were…

0

How to get Conexant AC link Audio working for old Compaq V2000 laptop with Win7

I have a old Compaq V2000 laptop (almost 4.5 years old) (Intel Centrino Mobile and 512 MB ram) and installed Windows 7 on that. I was scared that it will not install since the system does not meet prerequisite criteria (1 GB ram), but Win 7 got installed perfectly! But showed that 5 drivers were not…

0

sp_mergemetadataretentioncleanup not cleaning merge metadata during regular sync causing stale data in metadata tables

I recently came across an interesting situation in merge replication and thought I should write about it: Description: > There is a high volume replication setup with thousands of subscriber and a very volatile(lot of transactions per second) publisher database> Started observing huge blocking when multiple merge agents starts synchronizing> Even if merge agents are stopped, the time taken…

0

sp_who2 (or sysprocesses or sys.dm_exec_requests) might show your thread being blocked by SPID -4

You might find that when sp_who2 (or sys.sysprocesses or sys.dm_exec_requests) is executed on a SQL Server, the output has several threads facing blockingIf you track the blocking chain, you will reach to a thread that is being blocked by a SPID with number -4.About this -4 SPID, BOL says (http://msdn.microsoft.com/en-us/library/ms177648.aspx): -4 = Session ID of the…

0

SQLBrowser fails with "The SQLBrowser service was unable to process a client request"

Recently worked on an issue where sqlbrowser was getting bunch of errors:<error>   07/31/2009 12:20:58 PM SQLBrowser Error None 14 N/A NTMTVSQL24 The SQLBrowser processing of requests against a particular IP address has encountered a critical error.  Processing of requests on this address has been halted.   07/31/2009 12:20:58 PM SQLBrowser Error None 8 N/A NTMTVSQL24 The…

0

Replication Snapshot Folder Cleanup

Snapshot agent creates snapshots for the subscribers to initialize. These contain various different types of files (like: .bcp – actual native/character mode data file, .dri – foreign keys and check constraints, .idx – index creation statements, .sch – table/schema creation script, etc)These files are always kept in \unc\ folder (and/or under \ftp\ folder if you…

1

"Virtual" subscription entries in the Distribution..MSsubscriptions table

If you are using Transactional Replication, you may find entries in your Distribution..MSsubscriptions table which have subscriber_id= -1 and -2. Also, the subscriber db will be set to “virtual”You may find that for some of your Tran Publication, there are no “virtual” subscription entries while it is there for others. Reason:Whenever any one of “allow_anonymous”…

1

Behavior observed due to @immediate_sync parameter of Transaction Replication when adding new article to an existing publication

* sp_addPublication procedure for creating a new transactional replication has a parameter @immediate_sync. BOL has description about it as:<BOL>@immediate_sync=] ‘immediate_synchronization’Specifies if the synchronization files for the publication are created each time the Snapshot Agent runs. immediate_synchronization is nvarchar(5), with a default of FALSE. If true, the synchronization files are created or re-created each time the…

1

Links for using Performance Counters (perfmon) while troubleshooting SQL Server related issues

Understanding Performance Counters data while troubleshooting Performance issues in SQL Server: http://blogs.technet.com/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx External Links: http://www.extremeexperts.com/SQL/Articles/SQLCounters.aspx http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/User Settable queries: http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1110440_tax301334,00.html?adg=301324&bucket=REF#

1