SQL Server: Why is it necessary to capture and store information on sessions i.e. spid(s) running on a SQL instance for troubleshooting purpose.
Many a times a DBA wishes for the below information, during performance troubleshooting, Can I get to know what was being executed 30 minutes back. Can I get to know which …
SQL Server: Why is it necessary to capture and store information on sessions i.e. spid(s) running on a SQL instance for troubleshooting purpose. Read More