Grant Fritchey (7/29/2014)

---

The issue, whatever is causing the slowdown, could very well be within SQL Server. Absolutely. But the timeout itself is controlled at the application connection setting.

So, to troubleshoot...

That is the thing. I don't see that information in the error log. However, I ran a trace on the server and it appears that the application isn't sending the...

I completely agree with you. I am not sure why they did that to begin with I will create a new optimization job later, but for right now I have...

If we look at the job schedule in terms of yesterday and today.

The job to optimize runs at about 8pm 04/07/2013, at the end it returns them to full....

So I found the issue. Apparently the previous DBA has a job that is changing the database from Full to Simple to do a database optimization. I don't understand why...

GilaMonster (4/6/2013)

---

Since we're going nowhere fast here...

Finish this script (the file name) and then run this trace for a couple of days. It will pick up all backups, all restores...

GilaMonster (4/5/2013)

---

mqbk (4/5/2013)

---

GilaMonster (4/5/2013)

---

Check the SQL error log. Are you seeing recovery model changes? Do you have any other scheduled jobs that do anything to the log (including truncate it)?...

if I try to manually run it, it tells me that it doesn't have access to the file

GilaMonster (4/5/2013)

---

Check the SQL error log. Are you seeing recovery model changes? Do you have any other scheduled jobs that do anything to the log (including truncate it)? Do you...

It's Full and as near as I can tell, always has been.

That's what every forum I've seen has said. As near as I can tell, It hasn't been changed from simple back to full, but just to make sure I ran...

the full backup runs in full model. Also I don't see anything truncating the log file. this is really frustrating because all of the other databases are running smoothly just...

When you say check the event logs, do you mean the windows event logs?