we got some connections timeouts running a stored procedure in a SQL Server 2008 instance. after a while, the DB started to work as usual, and there weren't any additional timeout errors.
So I'm trying to get additional info about the error.
Does SQL server 2008 have any kind of error log that I can look into?
Do exist any auditing/logging features that I can activate to trace the error (if it happens again)?