Questions tagged [sql-server-2019]
SQL Server 2019 (major build version 15.00.xxxx). Please also tag sql-server.
1,155 questions
1
vote
1
answer
70
views
Semantic search database installed but not functional
I am trying to get Semantic Search feature running in my SQL Server 2019 by doing the following:
SELECT
SERVERPROPERTY('IsFullTextInstalled');
1 (this means it is installed)
SELECT
...
- 13
0
votes
2
answers
132
views
SQL Server 2019 (v15) : tempdb related files eat up about 80 GB on C disk, how to make it small and free up some space in C
On Windows Server 2016 and with SQL Server 2019 (v15.0), the tempdb file size is huge at about 80GB and it is divided into many files such as:
tempdb.mdf,
tempdb_mssql_2.ndf
tempdb_mssql_3.ndf
...
...
- 111
1
vote
1
answer
214
views
Log file AutoGrow Cancelled/timed out
WE have our Autogrowth on our Database set to the following:
ROWs Data - Size 25000MB - Autogrowth by 10%, Unlimited
Log - Size 345789 - Autogrowth by 10%, Limited to 2097152MB
Database is throwing ...
- 143
0
votes
0
answers
34
views
Retrospectively applying data retention to temporal tables
I've been asked to look at trimming the amount of change information that we're currently storing in a temporal table. The background to this is:
When the organisation that I work for initially ...
- 101
0
votes
1
answer
49
views
Issue when trying to replicate SQL DB with log shipping from AWS to OnPrem infra
I am trying to establish DB replication using Log shipping on MS SQL 2019 Enterprise but when I restore DB's on both nodes AWS and OnPrem data center I am getting error.
After this log shipping cannot ...
1
vote
0
answers
96
views
Columns With No Statistics Warning, though the statistics exists
I have a SQL Server query which has suddenly started picking a "bad" plan.
I can see a warning on a clustered index seek saying there are columns with no statistics
However, I can see that ...
- 2,256
0
votes
1
answer
100
views
Strange CheckDB Results
I think I have a failing disk sub-system on a Proxmox VM running Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5065222) - 15.0.4445.1 (X64) Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 ...
- 432
1
vote
0
answers
60
views
How to let multiple SQL Server instances use PolyBase (best practice with ?Linked Servers)?
I know PolyBase can only be installed on one SQL Server instance per host.
In my setup:
Instance A already uses PolyBase for its own external data queries.
Instance B (on the same server) also needs ...
- 21
-1
votes
1
answer
86
views
How Ola Hallengren Parallel Processing works
Can anyone please point me in the direction of an article that could help or please help in shedding some light on how Ola Hallengren Parallel Backup and DBCC processing work. I know that the scripts ...
- 447
2
votes
1
answer
216
views
Log File Growing Despite Usage being nowhere near capaciity
I have a SQL Server database that is in SIMPLE recovery model and every now and then, the transaction log is growing, despite its actual usage being well below the capacity of the file.
Below is a ...
- 2,256
0
votes
1
answer
85
views
Sch-M/Sch-S deadlock
I was looking into some deadlock logs on my system today and saw one I didn't understand - deadlocks on Sch-M and Sch-S locks. The documentation said it had to do with schema definition changes, ...
- 381
3
votes
1
answer
126
views
Inoptimal Fill Factor on objects in sys schema
I have run the legendary sp_blitz on one of my servers, which has thrown up a warning about some fill factors that have been changed.
When I run the query from brentozar.com/go/fillfactor which ...
- 2,256
5
votes
1
answer
302
views
Do I need to run sp_refreshview and sp_refreshsqlmodule after changing column collations?
I look after a database for a vendor’s application that our system team uses to store passwords. This database is part of a three-node AlwaysOn Availability Group. The instance and database currently ...
- 51
4
votes
0
answers
297
views
SQL Server 2022 vs 2019 Query Performance gap
I am facing a performance issue with an SQL query.
The query is generated dynamically via the webapp, I am testing with a static version to make things simpler.
The SQL query includes temp tables and ...
- 41
0
votes
1
answer
48
views
Advice on transaction log based Reporting Server
I have a reporting database that is kept in sync with the transactional database using transaction log files. The seed file is provided every 3 months and we get 15 min log files.
This database needs ...
- 1