Browsing articles from "July, 2016"
Jul
25
2016

Windows Task Scheduler Error – transaction support within the specified resource manager is not started

072516_1642_WindowsTask1.png

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:\   […]

Jul
15
2016

Transaction log file full because of log_reuse_wait_desc=replication, CDC, goldengate

071516_1725_Transaction1.png

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 […]

Jul
11
2016

How to: Run NETSH trace for Network monitoring/timeout captures

071116_2036_HowtoRunNET1.png

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 […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 457 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

July 2016
M T W T F S S
« May   Apr »
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: