Viewing 15 posts - 2,251 through 2,265 (of 9,241 total)
Your current setup is not clear and you seem to be making incorrect use of the terminology.
Pablo Campanini-336244 (3/23/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 11:31 am
what makes you think you need to stop data movement or remove a database from an AG when applying Windows patches??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 11:22 am
you just switch the roles back.
Could you detail exactly what you did to switch the primary role from server A to server B?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:34 am
so what patches were applied since the date you have identified?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:32 am
why do you need to remove the database from the AG?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:28 am
why don't you configure a listener for the availability group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:23 am
Well firstly, the message you posted originally details the issue, you're facing memory pressure within the instance. This is confirmed by the fact you have 80GB RAM free on node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2015 at 5:34 pm
so node b and node c both have 128GB RAM and the 4 instances on node b have max memory set to 12GB?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2015 at 2:40 pm
check your server logs for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2015 at 11:11 am
How much physical RAM does NodeC have, what is the total of Max mem assigned to the 4 instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2015 at 11:10 am
can you provide more info on how this user maps into the database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 11:30 am
granting execute at schema level is the only other way but it OTP in this case by the sound of it.
The object grants you are currently performing are the only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 10:56 am
Reg_Mayfield (3/18/2015)
data center and node3 is in another datacenter serving as the DR node.
We...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 10:47 am
if you're going to be performing any of the backups against readable secondarys your backup scripts will need to employ a certain degree of logic to check which backups already...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 7:19 am
balasach82 (3/17/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 4:29 am
Viewing 15 posts - 2,251 through 2,265 (of 9,241 total)