Search Results
| 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 network
Search options answers only
not deleted
user 126936
1
vote
Multi-insert batch executed remotely 5x slower than locally
I converted that file into a dynamic SQL batch, and it takes me 34sec just to send the batch to Azure SQL Database, and there's no wait stat that tracks that time. eg
declare @sql nvarchar(max) = …
- 47.7k
3
votes
Multi-homed SQL Server with High Availability Groups
But you can ensure that the ATL-ATL traffic goes over the 192 network by using host file entries on the ATL servers, as @Tony Hinkle suggests. …
- 47.7k
2
votes
Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I co...
do I need a DC?
No you can use SQL Authentication, or Windows Auth (NTLM) with "workgroup auth". And to use a DC you would have to join both of your boxes to the domain, so I wouldn't bother.
is t …
- 47.7k
1
vote
Domain Controller on Multi Subnet Always on Availability Group
Suppose if the Primary site goes down the server on the DR will still be able to used cached credentials.
Assuming the DCs and the rest of your infrastructure will fail over to DR by some other …
- 47.7k
3
votes
Accepted
What is the max network latency between synchronous-commit AlwaysOn Availability Groups
There is no maximum for the supported latency for synchronous replicas. You will sometimes opt for a higher-latency deployment in return for a RPO=0 for a broader range of failures.
The most commo …
- 47.7k
1
vote
Web server accessing the database server in Always on availability group
what if the network team dont allow access to that port
A "normal" DMZ has external access to hosts in the DMZ and limited access from the DMZ to the internal network. … If the network team won't allow connectivity from the web server to the databse server, you can put the database server in the DMZ or use a cloud hoster instead of a DMZ. …
- 47.7k