Hi SQL-Lover 🙂

I've been watching the responses given since our last discussion on this.

Theoretical limits are always nonsense as a SAN is a shared device (if the disks aren't, the...

On our IBM SAN (V7000) we have three physical enclosures which have two RAID 6 sets in them..... so you *should* be able to get split out....

Hope you get the...

Ah ok 🙂 hehe suck eggs! Sorry!

Hmmm well I thought the performance you posted is good. I'm assuming the sets you've posted are the fastest results out of the...

Hi sql lover,

I'm doing a similar exercise with a clients SAN here in NZ.

Before I even did SQLIO, I actually spent a few 30 minute sessions with our SAN tech...

Robert,

You said in your explaination of dirty pages:

'Dirty page: A page that has changed (has transactions committed to it) and has not been written back to disk.'

Reference: http://support.microsoft.com/kb/78363

Quote:...

Robert Davis (3/25/2012)

---

I'll make this simple. ALL READS COME FROM CACHE.

SQL operates with pages in cache only. It requests pages from cache. If the page doesn't exist in cache, a...

I think we're crossing wires here...

My example was Update has occurred and then select whilst update page still dirty.

You're taking my example and reversing it round to: Select and then...

The default isolation level in SQL Server is Read Committed.

Please refer to here: http://msdn.microsoft.com/en-us/library/ms189122.aspx

Mid way down - there is a table which shows whether or not dirty reads,...

If you have a dirty page in memory and another user does a SELECT that would pull the same page - does it take from the disk or the buffer...

The proper term (I've been googling :)) is 'Dirty Page Latency'...!

Thanks

GilaMonster (3/25/2012)

---

eforta.it (3/25/2012)

---

It's important to realise that if you have a high changing OLTP database, it's likely you'll have high physical reads as the cache will contain old physical block...

Full Version number of your release?

Might need a CU or SP?

Hi there

Can you give a bit more information about the table and query...

a) How many rows in your data sets?

b) What is the query?

c) How many rows do you expect?

d)...

rudy komacsar - Doctor "X" (3/22/2012)

---

is not necessarily correct ... unless 'threads' are are construed to mean 'logical CPUs' or...

Me again 🙂

I don't think you can buy 2012 licence and run 2008 R2 instead...

I'd ask the MS rep if you could - particularly if you have access to...