SQL Server DB, histroy of SQL run information with username, SQLID,SQL text

Ashwan 521

Hi we have production performance issue and looking to find out SQL run history information (already completed ) with username who run,time, SQLID ,SQLtext etc thorough SQL Script
SQL Version: 2016Sp3

any one knows with that information please share here.

many thanks

CathyJi-MSFT 21,086 Reputation points Microsoft Vendor

2022-05-27T07:22:03.55+00:00

Hi @Ashwan ,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know.

2 answers

CathyJi-MSFT 21,086 Reputation points Microsoft Vendor

2022-05-24T03:18:38.343+00:00

Hi @Ashwan ,

>we have production performance issue

Could you please describe your performance issue more clearly? CPU or I/O bottlenecks, slow query, etc?

> SQL run history information

You can get this information from SQL server log file. Or you can using SQL server profiler to trace this.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Please sign in to rate this answer.
Ashwan 521 Reputation points

2022-05-24T23:30:58.447+00:00

Hi Cath, I understand we can get information from SQL profiler. That take time to go through all one by one. and cant save to excel to have filters to find out more specific information .
QUERY STORE: does not have information related user who is running ?
thank you

CathyJi-MSFT 21,086 Reputation points Microsoft Vendor

2022-05-25T09:57:05.42+00:00

You can use third part tool ApexSQL Log to read SQL server transaction log file, then you can get the information that you need.

Ashwan 521 Reputation points

2022-05-25T11:42:04.633+00:00

Hi Cath , Is that free or chargeable ?

CathyJi-MSFT 21,086 Reputation points Microsoft Vendor

2022-05-26T01:59:32.64+00:00

Hi @Ashwan ,

You can click the free trial option on the link that i offered. It has a free trial period。

Ashwan 521 Reputation points

2022-05-27T20:23:10.553+00:00

Hi @CathyJi-MSFT thank you. I will try that . Since its expiring , do you know any when can use for fee in future as well .

thank you
Sign in to comment
Olaf Helper 40,736 Reputation points

2022-05-24T04:58:29.687+00:00

looking to find out SQL run history information

By default SQL Server don't log such information.
But with SQL Server version 2016 onward you can use the Query Store feature to log it.
See Monitor performance by using the Query Store
Please sign in to rate this answer.
Ashwan 521 Reputation points

2022-05-24T23:31:44.553+00:00

hi Ola yes its already enabled QUERY STORE. however does not have information related user who is running though?

thank you
Sign in to comment