Thanks Jeff. I didn't notice that. Good Catch. Actually, I didn't click the link.

--

SQLBuddy

I think you should take the SQL Server resource Offline which prevents the failover to the other node. Once you are done with the maintenance you can bring the resource...

fsession12 39949 (3/12/2014)

---

Many thanks for the website link through PM matey, great add-on.

Just had a potential reduce right here so my site may well not been employed before, all up...

Deadlock occurs when 2 or more processes block one another permanently and unless deadlock situation has been resolved no process can go ahead and complete it's task.

Monitoring is just...

PHXHoward (3/12/2014)

---

I can set all three replicas to synchronous commit but I can only pick two replicas for automatic failover. Was hoping that the functionality existed but it looks like...

We can't change that directly on FCI. But the same can...

Identify the SPID and kill it.

May be you can check these 2 tables msdb.dbo.sysdtspackagelog and msdb.dbo.sysdtssteplog for the status.

--

SQLBuddy

jralston88 (8/6/2013)

---

Hello everyone,

I'm reviewing a SQL Server 2000 database. When using the SQL Server 2008 upgrade advisor, it flags the server as having DTS software.

I queried the sysdtspackages table....

There is difference between Change Tracking and Change Data Capture. CDC stores previous versions. CT doesn't. Check if CT helps for your scenario.

http://technet.microsoft.com/en-us/library/cc280519(v=sql.105).aspx

--

SQLBuddy

Definitely SP2. Are you doing DB maintenance on the new server (Index Rebuilds, Update Stats) ?

And check for the Server level settings (Memory, CPU etc ..). Also try to...

Index doesn't get rebuild automatically. To reduce the time you can do index reorg nightly and rebuild once during weekend.

Or just rebuild indexes for that table.

You can use...

Also check if you are having blocking\ resource contention happening on the server ? Did you check the error log around timeout ?

--

SQLBuddy

Most probably, No. Are your package calling any .NET assembly ?

--

SQLBuddy

Create an SQL Agent SSIS proxy with a Credential using your ID.

--

SQLBuddy

ms-techie (3/12/2014)

---

It works and sometimes fails , without any change in the code .

The error message is as below

We inoke the SSIS package via the DTExec.exe

DTExec /File "\\Server1\SSISPackage1.dtsx"

/ConfigFile ...