Grant Fritchey (4/30/2014)

---

I strongly recommend looking over the execution plan for the query and do your own investigation and tuning. The DTA is notorious for making poor choices at times...

Thank you again for the reply , very helpful.

Grant Fritchey (4/29/2014)

---

Just what the actual waits are. You already have two that are interesting. PREEMPTIVE_OS_WRITEFILEGATHER is an indication of file growth...

Thanks for the reply.

"First, please, for clarity's sake, rename that index. Anytime I open a server and see _dta at the start of an index, I almost want to cry."

Can...

Interested in this thread. We have just taken on some consultancy hours from an Azure MVP via Microsoft regarding moving a write heavy application to Azure. Turns our table storage...

Thank you for the reply and the reformatting.

I was close then with this attempt before posting 🙂

update J

set J.JTypeID = Jtype.JTypeID

from jtype

inner join J on J.DID = D.DID

inner join D...

Thanks for the NOLOCK info. Partially understood the side effects but the information you have posted is a great help. I understand READ_COMMITTED_SNAPSHOT is the way to go...

--== Now for a solution ==--

SELECT a.ID, a.DEVICE, a.VALUE

FROM (SELECT ID, DEVICE, VALUE,

ROW_NUMBER() OVER(PARTITION BY DEVICE ORDER BY ID) AS pos

...

Thanks for the reply , will give the above a go.

Sorry for poor explanation.

Current row = the row i am querying , bearing in mind i need to query...

@query_result_separator='', (i.e TAB between quotation marks)

Thanks you so much , this worked for me . Simply cut and paste in today my query and BING , i get...

Hi, would it be possible to post the full script you got working please. Thank you.

Thank you.

These stats sold me on proposal 3, isolating tempDB on RAID1 by stealing 2 disks from LOG array moving log array from RAID10 to RAID1. Basing much of this...

One final sticking point which i hope the below can clarify.

--------------------------------------------

PROPOSAL 2

8x600gb raid 10 mdf array

4x600gb raid 10 ldf array

--------------------------------------------

PROPOSAL 3

8x600gb raid 10 mdf array

2x600gb raid 1 ldf array

2x600gb raid...

Thanks for the feedback. One quick point:

DB.2

reads= 36m

writes= 341m

DB.S

reads= 315m

writes= 343k

TEMPDB

reads= 69m

writes= 39m

Isolating tempDB to its own raid1 array would have benefits based on the above values taking the 69m...

Found this helpful.

SELECT

[Database] = DB_NAME ( qt.dbid ),

[Execution Count] = SUM ( qs.execution_count ),

[Total Execution Time] = SUM...