Viewing 15 posts - 1 through 15 (of 6,601 total)
Before you do that. What is your goal ?
February 6, 2020 at 1:30 pm
I would suspect the AD SPN.
I recall our cluster losing full control over that object during our tests.
Broke it down and rebuilt it. Never happened again. We built 10+ 2node...
February 3, 2020 at 8:02 pm
Did you enable the AlwaysOn XEvents session on all involved instances?
Did you install a monitoring solution to get an overview of failover events,..
I have a sqlagent job that is launched...
February 3, 2020 at 4:01 pm
did you check with all prerequisites ?
Prerequisites, Restrictions, and Recommendations for Always On availability groups
February 3, 2020 at 3:55 pm
BTW What's the advantage of an AG if you really need it to be hosted on a given server ?
It should be consumable in either situation.
February 3, 2020 at 3:47 pm
Check the SQLServer errorlog file !
Try the failover to A manually in SSMS and see what error comes up.
Implement failover monitoring so you can see which fases it passes or...
February 3, 2020 at 3:39 pm
What's wrong with a simple ALTER INDEX cl_ix ON schema.table REBUILD ... ? ( as that does not impact the non-clustered indexes )
Keep in mind this will also interfere with...
September 19, 2019 at 9:38 am
replay the deadlock with SentryOne PlanExplorer (free) ! It shows what is happening and causing the deadlock !!!
btw: this is the...
March 28, 2019 at 1:12 am
I would suggest BOL : https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups
Try to break it in your DBADEV environments, then figure out what and how to fix it. #YourMindIsYourStrength
March 12, 2019 at 4:55 am
Shrink file is the better choice because of its scopeKeep in mind you need to rebuild all indexes in that file after your shrink datafile ( not log )...
March 12, 2019 at 4:50 am
With SQLServer 2017 or the current Azure SQL Managed Instance, you also need to set configuration clr strict security to 0 ! ( it is 1 by default !!...
January 18, 2019 at 12:52 am
did you perform full database maintenance after the upgrade to the new engine ?
You've seen the "missing index", right ?
January 10, 2019 at 8:26 am
What's the cluster service account ? Does it have AD auth to register computer objects ?
January 9, 2019 at 2:47 am
You have to register the Listener computer object in AD yourself and grant the cluster computer object full authority to manage that listener object !
January 9, 2019 at 2:22 am
I always configure it using Powershell.As marked: did you restart the cluster resource to enable the listener ?
# create listener with default DHCP$NewAGListener =...
January 8, 2019 at 11:57 pm