Viewing 15 posts - 16 through 30 (of 1,341 total)
Hi Experts,
I am observing strange deadlock behaviour where one deadlock graph have 2 isolated databases involved. Can any experts here shed some light on this?
Regards
Synonyms. Views. Joins that...
March 25, 2024 at 11:40 am
Can you save and post the deadlock graph ? An .xdl file can directly be opened by e.g. Solarwinds Plan Explorer (free tool), which has a great replay...
March 25, 2024 at 11:39 am
Sharing the deadlock graph / XML will help people to see what went on, otherwise people will be shooting blind without the actual information.
Sorry missed the attachment. Uploaded the...
March 25, 2024 at 11:38 am
Thanks all the experts.Sorry I missed the attachment. Please have a look at the attached.
March 25, 2024 at 11:36 am
Seems like the issue is due to parallelism, Any experts here can give more insight.
March 18, 2024 at 8:12 am
Try to start SQL in single user mode, IIRC that would disable the logon trigger and allow you to drop it, to start in normal mode and resume operation.
Thanks...
January 16, 2024 at 12:42 pm
The setup is: OS - Win Server 2022 & MSSQL - SQL Server 2022 AlwaysOn Availability Groups are enabled on two (primary + secondary) replicas and use WSFC. Several availability...
January 4, 2024 at 8:35 am
Very interesting topic Steve. What I have observed very common is the data type mismatch in LINQ queries which causes the queries to do Table scan instead of seek even...
January 4, 2024 at 8:32 am
I am trying to mirror a TDE Encrypted Database. (SQL 2019). When I try to start mirroring with the GUI it says "Database not configured for mirroring". Same if...
March 15, 2023 at 5:54 am
Thanks Emperor100 but my question is about the open transaction .
The query is from Informatica tool which is causing this issue. Anyone have any idea why this is happening.
March 13, 2023 at 6:13 am
What would you usually be creating a maintenance plan to do?
DBCC CHECKDB
Database backups
Index maintenance
So doing a quick google search (other providers available) “do I need to run dbcc checkdb...
March 2, 2023 at 8:56 am
From your post I believe you are mentioning about job output file. Do you have the output file in place? Create a file with the mentioned name in SQL job...
January 13, 2023 at 10:05 am
Anyone experienced on migrating VLDB from 2014 to 2019
December 16, 2022 at 9:09 am
Thanks Grant for the reply,
how can we identify which connection it is? it is not resolved yet .
December 16, 2022 at 9:06 am
Viewing 15 posts - 16 through 30 (of 1,341 total)