1

I have a problem with the company I work in, some people are using SQL in the wrong way causing blocks that naturally crash the whole system, but we are not able to catch who is doing this, because when perceiving the person for the process.

I wonder if there is any way to save the data from the blocks?

As soon as something happens it will save the data as SPID, Login, HostName, DBName, Command and of course if possible to pull and save the script that the guy is running. I usually see through:

 dbcc inputbuffer (SPID)

I already gave a Google and I did not find it, so I came here.

Thanks in advance.

PS: Sorry for the English from Google Translate

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Gabriel Sarzi
  • 23
  • 3
  • 1
    What version of SQL Server? If you are looking to capture this information over a time period you could look at Extended Events. Check this link: https://www.brentozar.com/archive/2014/03/extended-events-doesnt-hard/ – Jacob H Sep 05 '18 at 16:48
  • Oh, thank you, I believe this article will help me – Gabriel Sarzi Sep 05 '18 at 19:00

0 Answers0