After struggling a lot and working with vendor, identified list of exclusions for SQL Server related to Anti Virus Software (McAfee, Symantec, etc.), the details can be found in this link, last one is important as it impacts performance.   https://support.microsoft.com/en-us/help/309422/how-to-choose-antivirus-software-to-run-on-computers-that-are-running-sql-server   Directories and file-name extensions to exclude from virus scanning When you configure your antivirus software settings, make sure that you exclude the following files or directories (as applicable) from virus scanning. Doing this […]

Issue: While trying to restart SQL Service, it failed and following error found in error logs,   yyyy-mm-dd hh:mm:ss.xx Server Error: 17182, Severity: 16, State: 1. yyyy-mm-dd hh:mm:ss.xx Server TDSSNIClient initialization failed with error 0xd, status code 0x10. Reason: Unable to retrieve registry settings from TCP/IP protocol’s ‘IPAll’ configuration key. The data is invalid.   yyyy-mm-dd hh:mm:ss.xx Server Error: 17182, Severity: 16, State: 1. yyyy-mm-dd hh:mm:ss.xx Server TDSSNIClient initialization failed with error 0xd, status code […]

While deleting a task in task manager, received following error reported by my team,   Error: “transaction support within the specified resource manager is not started or was shutdown due to an error”     We tried multiple options to modify job and delete but nothing worked, On further google search found that issue is similar to found on following forum,   http://answers.microsoft.com/en-us/windows/forum/windows_7-performance/transaction-support-within-the-specified-resource/fba64f34-4c16-4551-82d7-f22169be0d97?auth=1   Executed following command on server, fsutil resource setautoreset true c:\   […]

Came across weird situation where received alert for SQL Server transaction log file full and found log_reuse_wait_desc=replication from sys.databases   Now before mentioning troubleshooting step, setup of the database is question is little bit complex because Database is part of SQL Server replication where database publisher is at vendor side and we don’t have access to publisher DB Oracle Golden Gate replication is configured from this database to Oracle DB Database in question is in […]

While trying to troubleshoot the mirroring timeout issues which was in milliseconds, came across recommendation by a MS engineer to enable NetSH, below are instructions on how to enable it and capture logs, the logs can be supplied to Network vendor for further analysis.   Run following command to enable Netsh   Netsh trace start capture=yes scenario=netconnection maxsize=2000 filemode=circular overwrite=yes report=no persistent=yes tracefile=c:\%computername%.etl   Note: Please make sure you place this on a drive which […]

Came across a unique issue on a friend’s laptop where he has high resolution screen but when trying to remote desktop any server then the remote server also inheriting the same resolution and text looks very small, MSTSC settings, desktop resolution settings, etc. everything is tried what possible but it didn’t fixed the issue. To resolve this, he found following solution to fix. Note: I am writing this post to keep a record of this […]

While working on a simple data import from MySQL to MSSSQL, have to install MySQL as there is no workaround to import MySQL dump directly to SQL server, below are few commands used,   Note: There is no way you can EASILY import MySQL dump in .sql format directly to any other data source like MSSQL or Access DB, better to have MySQL installed locally and import MySQL dump there and then link it to […]

While trying to drop a linked server received following error,   Drop failed for LinkedServer ‘XYZ.ABC.COM’. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000.34+((KJ_SP3).140819-1214+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+LinkedServer&LinkId=20476—————————–ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)——————————Cannot drop server ‘XYZ.ABC.COM’ because it is used as a Distributor in replication. (Microsoft SQL Server, Error: 20581)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6525&EvtSrc=MSSQLServer&EvtID=20581&LinkId=20476 After going through online posts, found following script to drop distributor settings on Pinal Dave site (link),   EXEC sp_dropdistributor @no_checks = 1, @ignore_distributor = 1 […]

While configuring Linked server to oracle database from SQL server, faced following error,   Error: “ORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA” (Microsoft SQL Server Error: 7303)     I did following validation checks to ensure things are in place: Tnsnames.ora – validated that SID is present in tnsnames.ora file which is generally located in C:\Oracle\product\11.2.0\client_1\network\admin\ folder Validate syntax of connection string, it should be in below format, ORA123 = (DESCRIPTION = […]

Faced unique issue when updating my outlook desktop client (Outlook 2013) linked to outlook360 account, issue and fix is as below,   Issue: I created a new temp folder in my inbox and moved all my items including the items older than 6 months from inbox to temp, after 1 day again move them back to inbox, the number of emails remained same. I had to move again for some work but when I moved […]