No No. The point is not to play them all together for the same database.

They need to understand in theory, how it works and what effort it takes.

Hi Gila,

Thanks for your inputs.

Of course, i will factor the break fixes and other testing separately.

With respect to these activities, say for a size of 250GB in total, are you...

Absolutely.

I have roughly made something like this:

Friends, need some input on this please

I am unable to add the server in other subnet to the windows failover cluster. Need help around that area..

what do I need to ask them?

I am able to ping the servers from each other

GilaMonster (8/28/2015)

---

The one thing you should do is remove the extra log files. There is no benefit from multiple log files, SQL uses them in sequence.

Second, how many files depends...

krypto69 (8/27/2015)

---

We do exactly what you are saying here.

We have a NODEA and a NODEB and we report only from NODEB using application intent= readonly.

Works fine, but there are...

I see 2 physical processors when I run the msinfo.exe.

6 cores per...

Jayanth_Kurup (8/27/2015)

---

Is this an OLTP system ? the defaults are the best usually when you don't know what value to set. SQL automatically decides when to use a parallel plan...

2 physical CPU's, hyper threaded ratio at 12 which makes it 24 logical CPU's.

Is there a script I can use to pull the...

codykonior (8/27/2015)

---

IMHO yes. Let others know what you're doing first so they have the right of refusal, but otherwise while other DBAs will tell you to test thoroughly first, this...

Friends,

I got some clarity on the requirement.

The plan is to have high availability plus reporting solution.

That means Server A and Server B could be in always on purely as a...

The client currently has log shipping and they arent quiet happy with it.

Can I have secondary replicas in always on for reporting as well?

as minimal as possible:-)