Viewing 15 posts - 46 through 60 (of 194 total)
Set up time isnt an issue, as you say, weekend is fine.
The issue lies with the software the clusters are supporting and the providers have which stated that we have...
'Only he who wanders finds new paths'
January 20, 2014 at 10:06 am
Yes and that's where the issue lies as the DR (SQL instance) sits on the pre-production (windows) cluster, so yes we'd have to have that within the same cluster and...
'Only he who wanders finds new paths'
January 20, 2014 at 9:19 am
Actually Perry its beginning to sink in and yes, that's exactly where I was getting confused...well one of the points!
Each of our clusters has 2 nodes, A/P. In order...
'Only he who wanders finds new paths'
January 20, 2014 at 9:01 am
Am I right in thinking that if we had disk replication then we could add the other node into an availability group?
I have spent some time looking into this and...
'Only he who wanders finds new paths'
January 20, 2014 at 8:20 am
There are 2 separate clusters, production at the main site and pre-production that has 2 SQL instances on it (pre-production and disaster recovery).
D
'Only he who wanders finds new paths'
January 20, 2014 at 7:56 am
Thanks Perry!
Yes I did think it was still mirroring under the hood so to speak.
Here's perhaps the question, only the named instance on the 2nd cluster (DR) should be part...
'Only he who wanders finds new paths'
January 20, 2014 at 7:35 am
No, I know what it is...sorted!
D
'Only he who wanders finds new paths'
January 7, 2014 at 10:47 am
Talib123 (1/7/2014)
How do I find the query cost in the cache plan.
If you hover over an element you will see Estimated Subtree Cost - that's what you're after I believe.
'Only he who wanders finds new paths'
January 7, 2014 at 9:56 am
I tend to use the following article:
http://technet.microsoft.com/en-us/library/ms345408.aspx
D
'Only he who wanders finds new paths'
January 6, 2014 at 7:58 am
Yes, fully understood 🙂 Thanks Grant.
'Only he who wanders finds new paths'
January 2, 2014 at 6:01 am
Brilliant, thanks Gail/Grant - that has put my mind at ease! 🙂
D
'Only he who wanders finds new paths'
January 2, 2014 at 5:47 am
Grant Fritchey (1/2/2014)
'Only he who wanders finds new paths'
January 2, 2014 at 5:47 am
Actually, would a maintenance plan that is scheduled show as management studio rather than a sql agent job.
'Only he who wanders finds new paths'
January 2, 2014 at 5:03 am
Thanks Gail that was pretty much what I thought!
Merry xmas 🙂
D
'Only he who wanders finds new paths'
December 24, 2013 at 5:43 am
Outstanding answer sir thank you very much, clears that up!
D
'Only he who wanders finds new paths'
December 16, 2013 at 6:31 am
Viewing 15 posts - 46 through 60 (of 194 total)