charipg (12/19/2012)

---

Environment:sqlserver2008R2 instance on windows server2008R2 2-node cluster.

I want to copy data files of system database in a seperate folder,but as service is running, it is not allowing me...

I am not following you. The 64...

Michael Valentine Jones (12/18/2012)

---

The 64K random read and random write tests may be OK, but I would not call them spectacular, especially the 64K random write.

You should probably test again,...

runal_jagtap (12/12/2012)

---

Hi All,

need advice from the Experts ..

I have been asked to do archieving of the data..

because

The data in the databases are large in amount.. die to which if some...

Answering myself ... 😉 ... it looks CRYSTALDISKMARK is designed for root drives, not mount points (someone correct me if I am wrong)

But this question pointed me to SQLIO....

Perry Whittle (11/14/2012)

Yes i would. Commonly you would use mount points to get round the drive limitations of the OS, but i think that mount points help to keep everything...

I'm a happy DBA now, or kind of ...

Clarified the issue with them, but still work ahead (different stuff )

I know the concept, but I haven't used it before. Primarily because we were using a different approach on my previous work.

It's using...

Thanks for the MS link, will be useful indeed.

Now, about this remark ...

You'll want to provide some redundancy on your Public connection so 2 or 3 adapters teamed for the...

-We won't use any NIC for backups

-They want more NICs so people can connect from other subnets (no sense, in my opinion and current network layout)

-We are using cross over...

My bad, we all know 3 is what we need ... 🙂 .... that's what I've being doing since 2003, when I built my 1st cluster.

My question is, what are,...

Wohooo! ... 😛 ... success ....

I'll have a "beefy" machine on two months, in our main data centers; a full VMware Server, but had to work with these specs for now. That's the reason for...

Here...

I can help you and modify yours 😉 ... or give you screenshots. I may do this two or three times for learning purposes and prior my business trip next...