Viewing 15 posts - 31 through 45 (of 540 total)
Setup a trace using profiler and see what's causing it.
November 19, 2018 at 3:07 pm
You can set a session timeout to greater that 10 seconds in AG properties.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/de428459-f8c1-4e66-b712-8367cf455107/changing-the-session-timeout-in-an-availability-group
Which quorum settings are you using?
November 2, 2018 at 12:48 pm
You will see "backupthread" waits during restores and backups. It all depends on your database size and if you are using compression.
You can check the progress of the...
October 18, 2018 at 2:43 pm
myNumeric
845.53
myDecimal
525.34
You don't need an error when extra digits are...
October 5, 2018 at 10:26 am
This is what I've done so far (my dodgy notes):-
Login TestUser (created as...
September 7, 2018 at 11:56 am
Matt
Can you describe your always on setup in your 10 SQL instances?
July 13, 2018 at 2:00 pm
Have you tried using
IF fn_hadr_group_is_primary('AG_Name') = 1
BEGIN
"YOUR SQL HERE"
END
ELSE
BEGIN
PRINT 'This is not the primary replica - exiting with success';
July 13, 2018 at 1:08 pm
June 11, 2018 at 10:16 am
May 29, 2018 at 12:27 pm
May 17, 2018 at 2:08 pm
May 9, 2018 at 9:24 am
Can someone please let me know how does one take backup or restore of Microsoft...
May 7, 2018 at 9:40 am
I have gathered a number of scripts over the years that give me partial...
May 3, 2018 at 2:45 pm
April 30, 2018 at 11:46 am
Viewing 15 posts - 31 through 45 (of 540 total)