It's better to test by viewing the execution plans.

--

SQLBuddy

Did you check if this was caused by any Windows\Software\driver updates on the server ? Also did you check the SQL Server Error Logs and Windows Application and System logs...

Create a step 3 in the job and modify the job control for the Step2 as

On sucess -- Goto Step 3

On failure -- Exit reporting as failure.

In step...

whojdysz (4/2/2014)

---

Hi Guys,

I have an index consolidating issue which I have not been able to find a definitive answer to.

I have a clustered index and two non-clustered indexes on a...

Oracle_91 (4/3/2014)

---

Hi sqlbuddy,

Thanks for reply.

I wanted to setup monitoring for I/O issues.

Are there any benchmark values of how much a normal disk can handle and how much a...

JoshDBGuy (4/2/2014)

---

I've run into issues in the past dealing with extremely poorly written queries with LINQ. I've been under the impression for awhile that LINQ is fine for very simple...

Check the following SQL Server perfmon counters to find any I\O issues with the storage system. Are you experiencing any IO issues ?

Avg. Disk sec/Read

Avg. Disk sec/Write...

How frequently do you do...

matt.gyton (4/3/2014)

---

I'm still a little confused....I've found the following information about the exact scenario I was referring to:

SPID Type ...

Could you post the error message in the Job History ?

--

SQLBuddy

ramyours2003 (4/2/2014)

---

one of the tlog file is configured as initial 1 TB , because of that we doint have space on the drive , is it possible to...

phil.wong (4/3/2014)

---

We have decided to change one variable at a time and see how the changes look on the server and monitor if it impacts performance on both the SQL...

paul.knibbs (4/3/2014)

---

No, no backups from another source. What seems to be happening is that a previous backup simply never finishes for some reason (and there are 24 hours between backups,...

elhelalaoui (4/2/2014)

---

I've imported the package onto MSDB and here what i'm having now in both cases :

Case 1 : Running the step with the proxy :

errors ==> Job outcome :...

Because of this ..

.. saying that the operation is...