Hi

do you think it would be a big performance loss to store tempDB data and Logs on the same Raid?

in our BI(OLAP) enviroment , we use

1. RAID 10 for...

Thanks to everyone for all the great responses.

this turned out to be a very informative thread....

Cheers,

GAJ

I haven't read all of the replies to this article yet, but I appreciated it's detail to the RAID configurations, their penalties, and the calculation for the IOPS.

The only other...

With the proliferation of SSD disk and its costs going down, some RAID levels with low write performances are no longer so low. Put an SSD in your life. I've...

A questoin; out of curiosity:

You quoted some PerfMon stats on your production environment.

Given your analysis, would I be correct in assuming your produciton environment already runs an array of >...

Hi Santhosh,

sounds like an ugly problem.

Private Message me and I'll see if I can help you out.

GAJ

I found this to definitely be true

GAJ

James,

Thanks for reaching out....I really appreciate the info.

GAJ

Kevin,

thanks so much for the information....

Keep up the good work on that Engine

🙂

Greg J

I'll let you know what we come up with......

I'll probably just write an article on it as it seems to be a common problem....

G~

Good idea Graham....

I currently have a utility they can run prior to the Refresh or Baselining....

the script dumps every table out to a txt file. then After the baseline, they...

exactly.

I'm leaning towards pushing back on them to take ownership of their test data and of their process.

I'll schedule Baslines ahead of time and they'll have to prepare accordingly.....

not too...

Good Morning....

thanks for the comment.

You could use Trnxn-Replication to copy the data to your staging server and then SSIS to ETL the data from the staging server to you reporting...

I Believe its the FAS3070 iSCSI SAN

yeah Patrick. Thanks for the post.

I think you and I are definately on the same page......

I've had the same experience as you in the past.

The vendor keeps saying "Well....new...