question

StanislavDinkelis-7675 avatar image
0 Votes"
StanislavDinkelis-7675 asked StanislavDinkelis-7675 answered

Adding detailed transaction log file application throughput information to SQL Log

I've spent quite a few time searching on the matter, no luck so far, decided to post my question here.

I wonder is there a way at all to add (concatenate) TLog (rollforward) application throughput (speed) detail to the existing information in SQL Log for Standby database.

That is, literally, this

"RESTORE LOG successfully processed 24011 pages in 1.264 seconds (148.403 MB/sec)."

to this

"
Message
Log was restored. Database: <a user database name>, creation date(time): 2018/02/16(01:17:50), first LSN: 47072:120299:1, last LSN: 47076:54786:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'<path>\<db_name>_backup_2021_05_17_170006_0460796.trn'}). This is an informational message. No user action is required
"

to be something like

"
Message
Log was restored. Database: <a user database name>, creation date(time): 2018/02/16(01:17:50), first LSN: 47072:120299:1, last LSN: 47076:54786:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'<path>\<db_name>_backup_2021_05_17_170006_0460796.trn'}). This is an informational message. No user action is required

RESTORE LOG successfully processed 24011 pages in 1.264 seconds (148.403 MB/sec).
"
?

Thank you!

Stan

sql-server-general
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.

StanislavDinkelis-7675 avatar image
0 Votes"
StanislavDinkelis-7675 answered

Hi Amelia,

Thank you!

Stan

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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi StanislavDinkelis-7675,
I haven't found a Trace Flag that can help add “RESTORE LOG successfully processed xxxxx pages in xxx seconds (xxx MB/sec)” message to the error log.
I think we may not be able to add such message to error log, this may be by design.
And it seems we only can view the “RESTORE LOG successfully processed xxxxx pages in xxx seconds (xxx MB/sec).” in the message when restoring log in T-SQL.
97317-01.jpg

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



01.jpg (39.0 KiB)
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.