EnvironmentDolphinDB Version: 3.00.2.6Deployment Type: Cluster (control node + 2 data nodes)OS: Windows Server 2019Problem DescriptionI'm encountering a metadata persistence issue on the ...

I am using extended events and its not capturing anti patterns properly. It is missing many ant pattern queries.What might be the reason ?

Looking at the two methods illustrated here and here to retrieve the most recently run queries in a certain timeframe (and their parameters), is there a way to group or link queries by the connection ...

Query performance was significantly degraded, in some cases hitting a 20min connection timeout with a query that normally runs in < 1min. Web applications that are heavily dependent on DB queries ...

I am trying to detect, from within a SQL Agent job step itself, whether the current step is being retried (i.e., whether it has already failed once in the same job execution).My SQL Agent job is ...

We are migrating from SQL Server 2022 to Postgres 18.We were using CIText for case insensitive functionality similar to SQL Server with collation English_United Kingdom.1252.With the release of ...

Users of SQL Server 2022 can use SAN snapshots to seed an Availability Group, as shown here. However, this uses 2022 constructs like BACKUP DATABASE ... WITH METADATA_ONLY.I am on SQL Server 2022, ...

I am hosting a SQL Server database at a customer and need to run sp_updatestats.My user that has been assigned does have db_owner permissions but they cannot give me sysadmin permissions. From what I'...

I have a DolphinDB table dfs://derived_financial_metrics_bk.financial_metrics which is partitioned by DAY and uses the TSDB engine.I successfully backed up the entire table using the backup function ...

Team have Database architecute where orgnisation having 10 datacenter . On primary datacenter databasee having 3 node Group replication cluster and Group replication cluster replicating data across ...

I’m migrating an on‑prem SSAS 2019 Tabular model from SQL Server (local) to Snowflake. The model is deployed, and I’ve added a new legacy data source via 64‑bit ODBC. Processing a table in SSMS ...

I am a relatively new DBA in a small university which is in the process of large scale infrastructural change. It's my first official role as DBA.While I'm in charge of the Oracle cloud database (...

For example, if a table has columns A, B, ID, and (ID) is the primary key, and (A) is a secondary index.I wonder if the leaf nodes on the secondary index (A) is sorted by (A,ID), or just (A), and the ...

Postgres 17 cluster is in Windows server in Estonian locale. Databases are defined likeCREATE DATABASE mydb WITH OWNER = mydb_owner ENCODING = 'UTF8' LC_COLLATE = 'et-EE' LC_CTYPE ...

The documentation tells us what happens when session timeout for a synchronous Availability Group replica expires"Even if a disconnected replica is configured for synchronous-commit mode, ...