GSquared (9/12/2011)

---

Ninja's_RGR'us (9/12/2011)

---

Steve Jones - SSC Editor (9/12/2011)

---

I don't understand why Celko keeps posting on these forums. It is completely obvious that he doesn't want to aswer the questions, so...

Tara-1044200 (9/12/2011)

---

HI, All of these qey's are giving me restore % which is 100% but it is actaully recovering after the restore from the past few days not sure when...

Steve Jones - SSC Editor (9/12/2011)

---

I don't understand why Celko keeps posting on these forums. It is completely obvious that he doesn't want to aswer the questions, so why take...

Are you sure this is OLTP?

I've never seen an avg cost of 36!!!

I'd really look at the top n worst queries by time, IO & cpu. I'm sure you...

You have sql monitor installed. Go the...

Still good content to read! 🙂

Can you run this version?

O

SELECT

optz.counter

, optz.occurrence

, CONVERT(DECIMAL(18,2), optz.value) AS AvgValue

, conf.name

, conf.value

, conf.value_in_use

, Uptime.DaysUptime...

My method will go way more precise than this.

That code keeps history of previous work. So after a few runs, you can check the history to see avg run...

rmechaber (9/12/2011)

---

Ninja's_RGR'us (9/12/2011)

---

rmechaber (9/12/2011)

---

Gianluca Sartori (9/9/2011)

---

You can start the job with sp_start_job and wait for its completion in a loop.

If the job exceeds the timeout you set, stop it...

rmechaber (9/12/2011)

---

But...

In case you want to read up on cxpacket and why it <often> a non-issue.

Cost threshold for parallelism (CXPACKET) http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

Paul White: Understanding parallelism http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/

Hit google with this one. ...

I'm getting out of my expertize zone here. Entering data gathering phase so that others can take over if I can't thal.

Ok then 2 more queries that have intersting...

In the Dataset, get the column as a real datetime column. Then you won't have to waste time with that convert cr@p.

The convert should be done only once in...

Looks pretty much like an OLAP system!

Please rerun the same query but filter out the CXPACKET too.

For formatting I'd try pasting the results to a txt file and then saving...