This has been in prod for over 1 year without any issues. It's based on version 4.0 of the script (4.1 is out now).

I've tweaked the settings for my...

GSquared (10/13/2011)

---

That'll work. Might end up with problems in terms of cached execution plans being good for one or the other but not both, and so on.

You might want...

patrickmcginnis59 (10/13/2011)

---

Sure, if you want to consider SQL Server as one big blob of program then thats fine, I'm not...

Do you have a time limit?

DB or objet exclusion?

Worse comes to worse I can always give you my version of the code.

DTA is for when you don't know what you are doing (and it's even more dangerous for those people).

This is the correct way to go :

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

P.S. 50 GB trace...

sd 31430 (10/13/2011)

---

@Gila:

Thank you.

I had a quick view about your excellent article.You are quite cool.

I guess, you are right. It appears to me there isn't really an easy way to...

pavel 74570 (10/13/2011)

---

Hi,

THanks for your fast reply first!

I know, I'm using enabled EXECUTE dbo.dba_indexDefrag_sp @executeSQL = 1 statement in a script.

I'm sure I'm doing something wrong, but can't find...

When you hit no, it stops the saving of the changes. But it does not change the state of the table edit gui in which you are in. ...

That creates the script objects. You need to call the sp for it to run.

This will allow you to mount a copy of the db without doing the restore.

Free trial : http://www.red-gate.com/products/dba/sql-virtual-restore/

As in 100% exact copy in every way. Size included.

GilaMonster (10/13/2011)

---

sd 31430 (10/13/2011)

---

We already run some time with this lack of performance.

I would like to learn how to improve the performance step by step and I would be...

tsql <> query?

Who the heck are you kidding with this?

GilaMonster (10/13/2011)

---

Tune the code, tune the queries, there's no 'go faster' switch in SQL (shrink however is a very nice 'go slower' switch)

I wrote a 2-part article over at Simple...

I'm available for a consult. If this is urgent, there's no way this can be done over a forum or by someone without experience.

I've done imrovement by as much...