Read-Only Routing in SQL Server Always On AG

  Рет қаралды 7,130

NightShiftDBA

NightShiftDBA

Күн бұрын

Пікірлер: 21
@satishkumarkatari4236
@satishkumarkatari4236 2 жыл бұрын
I don't see any videos you posted after Read Only Routing, I hope you are well :) and Thanks for this wonderful lecture.
@bimmerfan6538
@bimmerfan6538 Жыл бұрын
Great job explaining the concept and showing it!
@VillageLog
@VillageLog Жыл бұрын
Awesome lectures Please make cluster and multi subnet Ag .
@wanderertechie
@wanderertechie 3 жыл бұрын
You have clear understanding of the term
@danielkassa5196
@danielkassa5196 2 жыл бұрын
U nailed it. I can’t thank you enough.You have answered all my questions
@MushtaqRKhan
@MushtaqRKhan 6 ай бұрын
Indeed it is a very good explanation. My question is what if the secondary switches to the primary, will the application switch to the secondary server, or will remain connected to the primary?
@umakantkesgire7720
@umakantkesgire7720 Жыл бұрын
It's useful information. Thanks a lot
@VillageLog
@VillageLog Жыл бұрын
Awesome. Could you please make Cluster and Cluster less Availability Group.. How it works
@nagaraj09021993
@nagaraj09021993 3 жыл бұрын
Nice Video and can understand in better way..
@syedirfanhaider2346
@syedirfanhaider2346 Ай бұрын
Hi DBA can you please share any video for cleaning the transaction log file in sql server databases
@nnamdieze9851
@nnamdieze9851 2 жыл бұрын
Thank you ! Clear and concise
@P-series494
@P-series494 Жыл бұрын
Could any one suggestion what we can write in application server web config to route the read-only connections
@senthilkumarsundarrasu3309
@senthilkumarsundarrasu3309 Жыл бұрын
Hi Awesome.. are we possible to configured application specific to routing to secondary
@kotekr4383
@kotekr4383 3 жыл бұрын
if possible kindly make a video on cluster sir tq in adv
@veselingpetrov
@veselingpetrov Жыл бұрын
Nice video! What if we leave "Allow all connections" on Primary Role and "All" to Secondary role. If I execute a Read query withOUT ReadOnly, where it goes? And if I execute a Read query WITH ReadOnly, where it goes?
@limabegum9102
@limabegum9102 Жыл бұрын
withOUT ReadOnly --> Primary with Readonly --> R1/R2
@sansak9098
@sansak9098 8 ай бұрын
Hi can anybody let me know read only routing and read intent difference,i can not see any difference b/w both options,tq in advance.
@cricsnaps
@cricsnaps 8 ай бұрын
Helpful Video
@allaboutsqldata4810
@allaboutsqldata4810 Жыл бұрын
Great. thanks
@bharanivijaykumar6112
@bharanivijaykumar6112 2 жыл бұрын
Sir please send me clustering video I really exacting waiting for that video
@kotekr4383
@kotekr4383 3 жыл бұрын
very nice video
Readable Secondary to "Read-intent Only" or to "Yes"
11:48
NightShiftDBA
Рет қаралды 4,4 М.
SQL Server Quickie #45 - Availability Groups
18:24
SQLpassion
Рет қаралды 1,6 М.
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
Blocking and Locking: How to Find and Fight Concurrency Problems
58:29
Brent Ozar Unlimited
Рет қаралды 51 М.
Always On Latency Monitoring Alert
20:57
NightShiftDBA
Рет қаралды 6 М.
Designing SQL Server AlwaysOn Availability Groups Topology
31:26
Edwin M Sarmiento - SQL Server HA and DR
Рет қаралды 9 М.
High CPU Usage Caused by SQL Server
10:16
SQLMaestros
Рет қаралды 7 М.
How to Troubleshoot Different scenarios in Always on Availability Groups
1:25:28
Log_reuse_wait_desc as Availability_Replica - How to fix
37:10
Chandu's Technet
Рет қаралды 8 М.
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19