question

UdhamSingh-6769 avatar image
0 Votes"
UdhamSingh-6769 asked UdhamSingh-6769 commented

How to reduce "Longest Transaction Running Time" refresh time

Hi,

Is there any way to reduce the refresh time of "Longest Transaction Running Time" counter. By default this counter's value in sys.dm_os_performance_counters gets refreshed every 60 seconds.

There are occurances when my alert's response job failed to log the results.

Regards,
Udham Singh

sql-server-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @UdhamSingh-6769,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered UdhamSingh-6769 commented

Hi @UdhamSingh-6769,

As far as I know, it is impossible. And this counter only shows activity when the database is under read committed snapshot isolation level. It does not log any activity if the database is in any other isolation level.

Suggest you reading the blog TECHNIQUE TO SET SQL SERVER LONG RUNNING TRANSACTION ALERT, hope it could help you.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Adding to this, this counter also logs value when transaction is in SNAPSHOT TRANSACTION LEVEL.

0 Votes 0 ·