I've never touched SSIS, can you upload the package over here?

Ya but I'd use this instead.

http://sqlfool.com/2010/04/index-defrag-script-v4-0

That doesn't update the stats, but if the db is small enough donig fullscan updates on all index will run...

The name will match the index. Then

http://msdn.microsoft.com/en-us/library/ms177623(v=SQL.100).aspx

http://msdn.microsoft.com/en-us/library/ms190330(v=SQL.100).aspx

Ya nothing overly complicated over there.

Have you checked your machine's eventlog for hardware issues?

Just check at the db level :

SELECT * FROM sys.databases

Then stats level :

SELECT * FROM...

I've called in more hands to test this query. My system's executing 1000+ jobs per day and I don't anything in the cache. There must be something different...

That's just what I...

I've seen this but never by that much. The most I've seen is a few more seconds, not 10 fold. It's actaully showing the graph plan that takes...

sjimmo (8/1/2011)

---

I sure wish we...

Should be roughly 1.5X for tempdb.

The thing is that you'll do this 1 index at a time, so the real idea is to find the biggest of them all and...

Ya that's what I was afraid of.

Running the same query with cross apply all dbs will literally kill the server.

I don't see the point of running any more tests. ...

Need help to figure out if sql agent is uselessly filling the plan cache or if it's due to 3rd party application (commvault) >>

http://www.sqlservercentral.com/Forums/Topic1151929-146-1.aspx

Indianrock (8/1/2011)

---

We do have commvault running transaction log backups every 15 minutes in production, but I see many of the same plans on a test box that only runs nightly...

sjimmo (8/1/2011)

---

Ninja,

I find that to be really dangerous. The poin of checkdb is to find errors when the drive fails and to find them before the server needs to access...