Questions tagged [windows-server-2019]
17 questions
4
votes
1 answer
No parallelism in Express Edition of SQL Server
I have SQL Server 2019 Express Edition (CU8) on Windows Server 2019 (1809 version) and all of my queries go serial with NoParallelPlansInDesktopOrExpressEdition in NoparallelPlanReason property.
Is it that Express Edition never goes parallel? I…
jericzech
- 977
- 8
- 22
2
votes
0 answers
SQL Browser Service Stops After One Minute
I am encountering an issue with the SQL Browser service where the service will start, run for around 60-90 seconds and then stop. No error is logged, the event logs show three informational entries:
The SQL Server Browser service has started.
The…
HandyD
- 10,432
- 1
- 13
- 27
1
vote
1 answer
Azure VM Drive size configuration for MS-SQL
I have run into a scenario for a production server where I was recommended to create a separate drive for each one of the bigger clients (based on database sizes) whereas all other smaller clients can be placed on the same drive in Azure VM for…
Bishal Basyal
- 7
- 1
1
vote
1 answer
SQL Server Cluster and Windows Server Storage Replication
I am currently investigating on how to setup a SQL Server stretch cluster in combination with storage replication for which I want to use Windows Server Storage Replication. However, I am no sure on how to configure the storage replication exactly…
Niels Broertjes
- 549
- 3
- 19
1
vote
0 answers
Keep 2 instances of SQL Server synced
We want to set up a second instance/server of SQL Server such that both instances will be kept in sync. The reason is we need to separate some users and processes out to a separate server for business reasons.
More information (requested in…
user3071284
- 111
- 4
0
votes
1 answer
Impact of timezone change during sql server migration
We are migrating from our legacy SQL Server 2017 on Windows 2016 host to SQL Server 2019 on Windows 2019. In above migration the bigger change has been the difference in timezone between legacy and new build Windows host. Earlier we used to have mix…
Newbie-DBA
- 804
- 6
- 22
0
votes
1 answer
Create pgSQL DBs on different drives in ms windows
I have PostgreSQL 15 installed on a Windows Server 2019 Standard VM. I've installed pgSQL using the default configuration on the C:\ drive. I'm currently using the default data directory of C:...\data. I also have a D:\ drive that I would like to…
Larry Layne
- 1
- 2
0
votes
2 answers
Can I change the password of the domain account which I used to create the failover cluster?
Can I change the password of the domain account which I used to create the failover cluster? Will it affect the cluster at all?
I have also created the Always On availability groups using that domain account, will it be affected?
Regards.
TechAnons
0
votes
2 answers
SQL Server 2019 DAG WFC - Manual Failover won't work (MSSQL Error 41131)
We set up a distributed failover cluster with 2 Windows Server 2019 Datacenter nodes, each of them running SQL Server 2019 Enterprise + SSMS18.
The two nodes are located in two different sites with two different IP-Subnets.
Each Host is a ESXI VM…
DevDino
- 1
- 3
0
votes
1 answer
How to check whether or not dynamic quorum and dynamic witness is enabled on WSFC?
Dynamic quorum and dynamic witness are abilities of the WSFC to dynamically adjust the vote of the nodes and witness to prevent unnecessary failovers.
Where can I check whether the WSFC configuration is configured such that it performs dynamic…
variable
- 3,590
- 4
- 37
- 100
0
votes
0 answers
SQL Server Launchpad Service keeps shutting down
We have a problem with the Launchpad Service shutting down and doesn't come back up. The service is has startup type "automatic", but when the server is restarted, or the sevice is stopped for some other reason, it's unable to start Launchpad…
Johan
- 101
- 1
- 2
0
votes
1 answer
ORA-12631 using Database Links with Oracle DBMS 19c on Windows Server 2019
We had a set of long-time Oracle 12c Database installations (multiple instances on separate VMs) on Windows Server. Over the past year we transitioned to Oracle 19c on Windows Server 2019. We found that database links that worked in the 12c…
M Herbener
- 213
- 1
- 8
0
votes
1 answer
Upgrading Operating System only. OS 2016 - 2019
Currently we have a number of Servers that are using Windows 2016 with SQL Server 2017. The support team want to do an in-place upgrade of the OS to 2019 due to 2016 Mainstream support ending in Jan 2022. I don't want to upgrade the SQL Server…
craig king
- 63
- 6
0
votes
2 answers
Windows Server 2019 and SQL Server Backups issue?
I have an issue with SQL Server that is really driving me nuts so I wanted to ask if anyone has any suggestions.
I have a program that does a daily backup of the SQL Server database. This has worked for two years.
Now, today, we had to upgrade our…
M_Lyons10
- 13
- 2
0
votes
1 answer
Windows Server 2019 non-owner node cannot see Cluster Name or IP
I am trying to build a SQL Server AlwaysOn Availability Group with 2 nodes in Azure. I have created 2 SQL Server VMs and Managed to create a Cluster with both Nodes as members of that cluster.
I have followed the steps in this Article of building…
M.Ali
- 1,970
- 10
- 27
- 38