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

Me too, don't rub it in! :hehe:

degree of parallelism.

So process only 1 thread at a time. 😉

SQLRNNR (7/28/2011)

---

Ninja's_RGR'us (7/28/2011)

---

Michael Valentine Jones (7/28/2011)

---

I have had people on my team that are full time work from home for the last 10 years, and I am happy with the...

JimS-Indy (7/28/2011)

---

On another note, see the "Val" function? My project numbers are of the form "C99999", though a few are totally non-numeric. Val() works nicely by returning a zero for...

P.S. I really need to see the execution plan to pinpoint the real problems.

Easier to read this way.

SELECT

tblCER.CERNbr

, tblProjects.ProjectNbr AS Project

, tblProjects.ProjectDescription

...

Ya too many answers in parallel, I should start answering with MAXDOP...

Yup, thank the author (top comment).

Don't want to take the credit when it's not mine ;-),

Glad it work.

Maybe make sure to keep a backup of the "correct" objects in case both start failing at the same time.

brown-415622 (7/28/2011)

---

The script worked guys thank you very much. I really appreciate it.

If your curious the results of the query were

"RESTORE DATABASE successfully processed 0 pages in 4.004 seconds...

brown-415622 (7/28/2011)

---

The script worked guys thank you very much. I really appreciate it.

If your curious the results of the query were

"RESTORE DATABASE successfully processed 0 pages in 4.004 seconds...

This all needs to be dynamic too...

...

Is it getting blocked?

--http://sqlfrndz.com/2011/06/09/activity-monitor-script-to-find-head-blocker-sql-server-2005-2008-and-later/

SELECT

[Session ID] = s.session_id,

[User Process] = CONVERT(CHAR(1), s.is_user_process),

[Login] ...

Doing the same amount of work?

On a similar server?

With a similar load?

Please post the actual execution plan on the "fast" server and the actual plan (get it from the plan...

Yes to what??