Viewing 15 posts - 2,506 through 2,520 (of 9,241 total)
not sure I'm clear on what you're asking, could you explain a little more please, what are you trying to achieve?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2015 at 1:52 pm
its perfectly valid to have instances with different patch levels, this is one of the main reasons why you would ring fence a particular apps database to a separate instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2015 at 1:51 pm
you may have a windows server failover cluster that employs physical and virtual nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2015 at 1:48 pm
snomadj (1/16/2015)
is it pinging / checking access to the database / checking at the app level? ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2015 at 9:38 am
what are you referring to as Pand M
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2015 at 7:21 am
Perry Whittle (1/19/2015)
Are any of these mirror sessions asynchronous?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2015 at 4:39 am
SQLSACT (1/20/2015)
Hi allWe are looking at implementing AlwaysOn AG combined with a Failover Clustered Instance of SQL Server.
First question is why?
You're taking the decision to implement an AlwaysOn group...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2015 at 4:36 am
kjed (1/19/2015)
then when connection is on secondary there are no locks.
be aware that when you enable a read only secondary in an AlwaysOn group, all isolation levels are automatically...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2015 at 2:39 pm
ramyours2003 (1/18/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2015 at 4:49 am
have you checked the setup log?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2015 at 1:58 pm
sounds like its been uninstalled, what do you see in sql server configuration manager on the node itself
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2015 at 4:44 am
do the disk paths match on the primary and secondary servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2015 at 4:41 am
why on earth would you want that scenario?
Firstly check why you have the disconnections, you undoubtedly have an underlying issue maybe with the network (most common)?
What does a cluster validation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2015 at 11:08 am
Joy Smith San (1/15/2015)
I have never set up a SQL Server cluster hence not familiar with cluster setup.
I just want to know what are the prerequisites for installing a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2015 at 7:20 am
I get that totally thats why i said page allocations shift to account for more space in one file than another.
In a previous database i came across with 52 files...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2015 at 1:25 am
Viewing 15 posts - 2,506 through 2,520 (of 9,241 total)