SQLRNNR (6/13/2014)

---

GilaMonster (6/13/2014)

---

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

- Wait, the UDFs have cursors

-...

I doubt anyone knows who the responsible party is. Tuning a client's system, one that's been developed by 'experts' and enhanced by everyone and their dog and has been around...

That would be handy.

Maybe bump this thread mid next month, as Steve's on vacation.

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

- Wait, the UDFs have cursors

- I'm going...

Server-side trace or extended events session

It will not.

Please in future post new questions in a new thread. Thanks

Ok, that really is something running CheckDB. From the username, looks like it might be coming from BackupExec. BackupExec may be doing a checkDB before each full backup, that could...

Are you absolutely sure that something/someone didn't run a full backup between the two?

adzuanamir (6/12/2014)

---

Why "DBCC CHECKDB WITH physical_only executed" run across my instance for every database although i did not run in manually ? Is it by default a new feature that...

No. Index maintenance will invalidate all plans anyway, they'll recompile on their next execution.

Don't just think about it. 😀

The reason it helped here is that the 2005+ statistics have a different structure than the 2000...

In that case you need to analyse first whether you have IO bottlenecks. Pointless splitting files if you aren't bottlenecked on IO. You need to look for tables accessed together...

I said nothing about the login being a user in the database....

There's a bunch of problems with that procedure. Start with these two blog posts:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/

Fixing those two problems should help a lot.

Again,...