1) you should never have messed with processor affinities. set back to using all automatically, not explicit ones.

2) The problem here isn't your CPUs, it is one...

I too would like to see the exact statement used for one of these online indexing operations.

Your poor performance is almost certainly due to an insufficient IO subsystem. Indexing...

Sure woulda been nice if you...

pardeshkumar (4/17/2011)

---

i created a store proc

i created a temp table and data is passed using another temp table

now i am using dynamic sql and calling the temp table and it...

1) Stop using maintenance plans, ESPECIALLY for index defrag stuff. Go to ola.hallengren.com and get the free suite of maintenance stored procedures there. Fully documented, and they even...

If I had a nickel for all the times I have seen this kind of post . . . 😀

I have helped several clients with this and often the fastest mechanism is USB drive(s). If you do have multiple USB 2.0 ports on separate busses on the server...

My vote is to stop using maintenance plans altogether!! They are horrible. Go to ola.hallengren.com and get the FREE goodness there. Complete MX suite, including creating agent...

Ninja's_RGR'us (4/14/2011)

---

No doubt there.

That was supposed to be a quick 2 minutes "job" to test the outcome of full recompile.

I'm well aware of logging limits and single thread, but why...

I agree with Steve - if this is a production system you REALLY REALLY need to engage a qualified consultant. Given the questions you are asking and the lack...

The plan cache in SQL 2005 RTM can use over 75% of your total RAM too. Gets ugly.

If your system is a production one and you quickly need to...

Gotta say that I am absolutely stunned that we have spent this much effort to try to concatenate a string that has a cursor-driven solution that offers many benefits:

1) incredibly...

There are MANY unanswered questions here. Chief among them:

1) what is max memory setting for sql server?

2) what else is running on the server?

3) what is the underlying IO...

If your "reorg" job actually does a rebuild, then that would update stats, which will clear the cache and thus get you new plans that could be optimal for existing...

Given that your query runs in 90 seconds from SSMS I am betting you have a suboptimal plan cached that is being used by the Agent job. The sledge...