Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 250460

SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.

0 votes

Issues with differential backup on random days

How big are your full backups, differentials and logs looking? What blocksize are your drives set to? I would recommend a minimum of 64K to follow best practices but depending on data size you might e …
Ron Zimmer's user avatar
1 vote

log send queue size and redo queue size in AG

I would also suggest tracking your send queue as I've found with our systems having 5 secondaries (2 reporting async, 2 failover async, 1 failover sync) that some of the asyncs hold onto a huge send q …
Ron Zimmer's user avatar