Check processes last night

  • Hi guys,

    One of our users reported that there are reports that did not run last night and he wanted me to check the processes or applications that blocked it. Where should I check that in SQL Server? or how should I check that?

    Thank you in advance for your help!

  • If you don't have setup any monitoring that will save the results, there is no way to investigate historic actions. You could look at the different LOG files to see if any errors occured during that time.

    For future reference you should setup a (third party or custome made) monitoring tool that will register all information you need to investigate the raised issues.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply