Newest Questions
105,402 questions
0
votes
0
answers
7
views
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads?
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads? My demo below seems to suggest so, but I find this impossible.
Take a fresh server (you really don't want these ...
- 1,398
1
vote
1
answer
23
views
How can I use Resource Governor purely as a monitoring tool?
It is clear that Resource Governor monitors how much work each group is doing. sys.dm_resource_governor_workload_groups makes this utterly obvious.
Suppose that:
I don't yet trust my ability to ...
- 1,398
1
vote
1
answer
22
views
What does the Dedicated Admin Connection offer that Resource Governor does not?
The Question
What resources does the Dedicated Admin Connection reserve that I cannot reserve myself with Resource Governor? If I were a genius with Resource Governor, could I turn the Remote DAC off ...
- 1,398
0
votes
0
answers
10
views
How do we know that SQL Server will give out up to 75% of Max Server Memory to query workspace across multiple queries?
People who I rate reasonably make claims such as this
Out of the box, any query can come along and ask for ~25% of your server’s max server memory setting, and SQL Server is willing to loan out ~75% ...
- 1,398
0
votes
1
answer
45
views
Why does my index not help and what would help?
I have a MS SQL Server table called UG. Columns include:
id - int
user - int
group - int
flag - bit
source - int
removed - bit
Over 1M rows. I need to run a query to update flag where source = 100 ...
0
votes
0
answers
14
views
PHPMyAdmin won't let me update a password for a user account, even though I'm logged into the root account
I'm trying to update the password for the user account in a MySql database managed through PHPMyAdmin. I'm logged in as root and I'm changing the password through User accounts/change password. Here's ...
- 101
5
votes
1
answer
137
views
Why does Postgres choose a different index when adding FOR UPDATE to the query?
Background
I have a PostgreSQL (version 16) event outbox table acting as a queue of messages to be processed.
This is the DDL of the table
CREATE TABLE public.event_outbox (
"no" int8 ...
- 151
1
vote
1
answer
24
views
Why does DMLRequestSort require a sort operator in this case?
I am currently undertaking a migration exercise for a partitioned table with ~4.2 billion rows to get it moved to a table with a bigint column rather than int.
Example tables
DROP TABLE IF EXISTS dbo....
- 88.8k
0
votes
0
answers
3
views
DolphinDB 3.00.4.2: Failed to recover database - Metadata intact but domain file modified, error "No available replica for the chunk FileBlock"
I'm using DolphinDB version 3.00.4.2 and encountered a database recovery failure. The issue occurred because the system restarted due to an out-of-memory error caused by excessively fast data writing. ...
- 1
0
votes
0
answers
15
views
SQL server generating different query_id for same query_text_id after mirroring failover
I am facing a strange problem with one of my SQL Server 2017 Clusters.
I faced a query regression in the past and forced a known good plan for that query_id in query store.
When the planned database ...
5
votes
1
answer
146
views
Update mask evaluation will be disabled in net_changes_function because the CLR configuration option is disabled
When I enable CDC on a database table on a SQL Server instance that has CLR disabled, I see this exception in the logging:
Update mask evaluation will be disabled in net_changes_function because the ...
- 274
1
vote
1
answer
28
views
Online index rebuild takes SCH-M lock from the start and doesn't release it
We have a SQL Server 2019 Enterprise were we want to do an online rebuild of an index. The table contains 41.870.300 rows and is approx 35GB in size.
The strange thing we see is an SCH-M lock as soon ...
- 2,142
0
votes
1
answer
22
views
Postgresql Incomplete log line in case of Update query
Below are the configurations for logs:
logging_collector = on
log_destination = 'csvlog'
log_directory = '/var/log/'
log_filename = 'postgresql-16-main'
log_statement = ddl
log_min_duration_statement =...
2
votes
1
answer
186
views
+50
Double lateral join query takes over a minute to run on RDS
I have 5 tables below in my application and I am trying to do a double lateral join to retrieve like counts, dislike counts...along with the latest items and the query takes more than a minute to ...
- 286
0
votes
0
answers
45
views
Cannot Start mysql.service on ubuntu after restore of files
I had to restore the MySQL files on Ubuntu from a system backup. Unfortunately mysqld will not start. I chowned the directory to mysql:mysql but I still get this error:
Defined-By: systemd
Support: ...
- 101