Viewing 15 posts - 3,481 through 3,495 (of 9,241 total)
Martin Stephenson (3/10/2014)
test2 is the automatic failover synchronous non readable
The readable secondary is not important at this time, what are the connection settings when in the primary role for test2,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2014 at 3:51 am
Martin Stephenson (3/12/2014)
Because I simulated a failure by closing down the test1 server, the sql HA cluster failed over to test2 as expected
You don't have a sql a cluster you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2014 at 3:41 am
You shouldnt need to touch the cluster configuration, i'm assuming you mean that you have removed cluster votes from some of the nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2014 at 11:11 am
Oracle_91 (3/8/2014)
This question is out of curiosity and it left me in confusion whether service account as any role to play in sql server startup and shutdown?
Can anybody explain...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2014 at 11:01 am
muthyala_51 (3/11/2014)
500 GB RAM
Bit of an odd figure, i'm assuming that's 512GB RAM?
muthyala_51 (3/11/2014)
425 GB max memory setting.
Given the fact you have a lot of CLR and ext stored proc,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2014 at 10:33 am
How physical do you have and what is max server mem set to?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2014 at 12:33 am
muthyala_51 (3/8/2014)
any suggestions?
For what?
anything now would just be speculation since the instance was restarted
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2014 at 3:33 am
muthyala_51 (3/7/2014)
Yes Perry is right. I mean DBCC DROPCLEANBUFFERS. Edited the previous post.
You need to checkpoint the database(s) before dropping clean buffers. Did you run checkpoint first?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2014 at 12:07 am
I'm assuming the OP is referring to
DBCC DROPCLEANBUFFERS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 12:31 pm
Do you have lock pages in memory policy set or any trace flags
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 10:22 am
muthyala_51 (3/7/2014)
When we failover as the sql services gets restarted, how the memory behaves with during this period.
Same as any other time. The services go offline so SQL Servers memory...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 9:27 am
ramyours2003 (3/6/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 5:26 am
@murali (3/6/2014)
I would like to enforce password policy for non-AD accounts.
when I select enfocre password policy on SQL server it will enforce default policy (minimum 8 char with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 5:21 am
Thomas Mucha (3/7/2014)
I think the problem is down to the lack of fqdn. So will try to create a fake one via the hosts file.Tom
No it's not. Mirroring will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 12:45 am
Grant Fritchey (3/6/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2014 at 4:40 am
Viewing 15 posts - 3,481 through 3,495 (of 9,241 total)