Thanks! I guess I Was looking too much into the last subtree cost and seeing the separate plans made me think that the separate would be better, but I suppose...

Thanks everyone! I got some great ideas from SQLCruise to integrate with the suggestions here. This way I can nail down the culprits as well as get a better handle...

Perry Whittle (1/28/2015)

---

You are correct a fileshare witness does not hold a full copy of the cluster database, it's really designed for stretched clusters. Since you're not planning this here...

Perry Whittle (1/28/2015)

---

SQLKnowItAll (1/26/2015)

---

Not to beat a dead horse... but does anyone see any issues with the quorum disk moving between nodes of this 4 node cluster where only nodes...

Not to beat a dead horse... but does anyone see any issues with the quorum disk moving between nodes of this 4 node cluster where only nodes A and B...

Hi Perry,

It will not be multi-site, quorum will be a disk since it is not multi-site, and the only reason it will be FCI on the reporting side is because...

Hi Perry,

Let me clarify, as I believe I didn't do such a good job. The OS is Windows Server 2012R2 (Not SQL lol). My bad... Edited to make clearer above....

We used RSScripter, by Jasper Smith, and it worked really well for us. Can't find an original link, but Google gives many results and reviews.

Can you expand under "Other Resources", I believe there should not be anything expandable, but only one entry. The only resource in your cluster is the availability group, right? Also,...

cygne17_2 77208 (10/29/2014)

---

Hi,

We use SQL Server 2012 sp1.

We want to install a feature that we did not install the first time.

So we run the "SQL Server Installation Center" from our...

Jeff Moden (10/24/2014)

---

SQLKnowItAll (10/23/2014)

---

My end game here is to show a dev team that they don't need more memory, but by seeing paging and not understanding it, I may not...

So... Idera described what I was looking at as "It is the sum of Memory\ Pages Input/sec and Memory\ Pages Output/sec. " So, I now know that PLE going up...

sqlslacker (10/24/2014)

---

I'm a developer so I'm a little biased, but I'm not sure that "right-sizing" memory is the best approach. Memory is a relatively cheap way to increase performance for...

It looks like this is "the dynamic memory currently in use by SQL." I'll be honest, I'm not really sure I understand what that means other than it is SQL...

Good question. This is through Idera's SQLdm and was defined as "the number of pages being swapped in and out of memory per second."

I assumed this meant pages of...