SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• AG Lease timeout

  Hi Experts, Have some question related to Lease timeout behaviour in AG. 2020-12-28 02:14:39.540 Se…

  vsamantha35

  1 replies

  4 years, 11 months ago

  By: Site Owners

• TDE- Transparent Data Encryption related question

  Hi Experts, Looking for suggestions on TDE encryption. We have a 3TB database in UAT env. Its in 2-…

  vsamantha35

  5 replies

  4 years, 12 months ago

  By: oogibah

• Availability group

  I have two nodes as part of availability group with Multi subnet. Secondary is in DR location and w…

  Admingod

  1 replies

  5 years ago

  By: Admingod

• Always on AG group

  One of our DR server went down over the weekend with blue screen and cause the synchronization to f…

  Admingod

  1 replies

  5 years ago

  By: as_1234

• Linked server failure

  When i try to do test connection in linked server  from server A to Server B, Linked server failed …

  premkuttan

  1 replies

  5 years ago

  By: Mr. Brian Gale

• Chance data Capture with AG

  Since CDC uses log reader to read the changes from the Log. If the SQL server is configured for AOA…

  Admingod

  2 replies

  5 years ago

  By: Admingod

• SQL Server Performance Counters

  Here's a question that feels like I'm asking if a tree falls in the woods and nobody is there to se…

  alex.sqldba

  7 replies

  5 years ago

  By: WillemG

• Installing SQL server with DBAtools

  Hi I'm looking to automate installing SQL 2017 as part of an automated server build script. I think…

  alex.palmer

  3 replies

  5 years ago

  By: Ant-Green

• SQL Server Mirroring - Principal cannot set endpoint to Mirror

  I followed the below guide & I am stuck on the very last step where you set the endpoint to ref…

  arshishb

  1 replies

  5 years ago

  By: arshishb

• alias SQL multisubnet failover = true

  Good morning all , I have an always on instance to configure with a listener in mutlisubnet mode on…

  abdalah.mehdoini

  1 replies

  5 years ago

  By: abdalah.mehdoini

• HA Availability Group Listener

  I was looking for a specific definition for the Active Directory / DNS team as to what I need set u…

  stevec883

  1 replies

  5 years ago

  By: Johan Bijnens

• FCI Vs Always on AG

  I have configured failover clustering and Always on AG group and planning to test the failover usin…

  Admingod

  6 replies

  5 years ago

  By: Ant-Green

• RegisterAllProvidersIP = 0 and timeout in failover

  Good morning all , I have an alwayson instance with a multisubnet listener I configured RegisterAll…

  abdalah.mehdoini

  2 replies

  5 years ago

  By: Ant-Green

• IndicatorsPool events causing memory pressure?

  Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of memory. I think w…

  Ian (SSC)

  3 replies

  5 years ago

  By: Ian (SSC)

• SQL Server Collations

  So can anybody tell me if they have experienced issues when running a SQL instance level collation …

  PearlJammer1

  1 replies

  5 years ago

  By: Mr. Brian Gale