Share via

SQL Transaction Information Failed

Anouer Shili 0 Reputation points
2024-02-16T06:10:03.5166667+00:00

Hi, I have an SQL 2017 cluster connected to my sharepoint 2019 farm, and i am getting a lot of alert about SQL Transaction Information Failed with below details :

Service

SQL Transaction Information - MSSQLSERVER

Metric that triggered the notification

full scans per second

State Transition

Normal to Failed

Service Metrics

Latch waits per second 0
Latch waits per second 0
Full scans per second 70
User connections 143
Logins per second 0

Also, on the primary noeud, on sql profiler i can see the details of this full scan per second in PJ. the sql querry is running by my sharepoint farm account.

Could you please help me to understoud the origin of this issue. Regards.SQL-error.png

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,422 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.