Viewing 15 posts - 376 through 390 (of 758 total)
GilaMonster (9/28/2012)
September 28, 2012 at 5:22 am
GilaMonster (9/28/2012)
Nothing to do with the buffer pool, it's a query that requires more workspace memory than is allowed.What query is it?
This is not a memory leak.
This happened a few...
September 28, 2012 at 5:08 am
Perry Whittle (9/28/2012)
you would have to force service on the 3rd node
Thanks
How would I do that?
Is that the same as failing-over ?
September 28, 2012 at 5:07 am
Perry Whittle (9/28/2012)
SQLSACT (9/28/2012)
Very interesting, do you know if it's possible to remove a nodes vote in a Windows 2012 Cluster?
Haven't had chance to look at the 2012 OS yet,...
September 28, 2012 at 4:07 am
Perry Whittle (9/27/2012)
However, take this scenario....
September 28, 2012 at 12:00 am
Perry Whittle (9/27/2012)
yes, correct
Thanks for your help
Because the 3 nodes involved in the same Cluster but only 2 of them will be partners to each other, what do you recommend...
September 27, 2012 at 8:31 am
Perry Whittle (9/27/2012)
September 27, 2012 at 8:23 am
Perry Whittle (9/27/2012)
Have you worked with windows server failover clusters before, do you understand the concepts?
Yes I have and I do, sort of
We currently have 2 node clusters combined...
September 27, 2012 at 7:48 am
Perry Whittle (9/27/2012)
SQLSACT (9/27/2012)
Non clustered instance "Clusternode3\INST2" installed to Clusternode3.
AO group called "AOGrp1" created between instances "SQLCLUST01\INST1" and "Clusternode3\INST2"
The above setup is an AG...
September 27, 2012 at 6:35 am
Perry Whittle (9/27/2012)
SQLSACT (9/27/2012)
For a setup of an AG between 2 servers without incorporating FCI, I just need 2 servers, with it's own storage, right?
That is correct, recall that...
September 27, 2012 at 5:43 am
Perry Whittle (9/20/2012)
SQLSACT (9/20/2012)
however, is it just me or does it become very complex when you start combining FCI ?Thanks
yes extremely, why do you think i wrote the article 😉
Hi...
September 27, 2012 at 4:25 am
GilaMonster (9/27/2012)
SQLSACT (9/27/2012)
Why would it need to read a blank page off disk?
Wouldn't it need another page to accomodate the page split?
Sure, but why would it need to read a...
September 27, 2012 at 2:59 am
GilaMonster (9/26/2012)
SQLSACT (9/26/2012)
If the page in memory cannot accomodate the insert, does SQL then just bring an extra page blank page from disk into memory?
Why would it need to read...
September 27, 2012 at 12:25 am
GilaMonster (9/26/2012)
Yes and yes.
This is a lot to take in for a newbie :hehe:
What happens in the case of a page split?
If the page in memory cannot accomodate the insert,...
September 26, 2012 at 8:55 am
GilaMonster (9/26/2012)
SQLSACT (9/26/2012)
This whole post is under the assumption that we're only querying data, we are not doing any Inserts, Updates or Deletes, right?No, not really.
Thanks
If SQL needs to insert/delete...
September 26, 2012 at 8:47 am
Viewing 15 posts - 376 through 390 (of 758 total)