Based on this Troubleshoot a process (SPID) using tools & TSQL queries blog post I have been asked to provide same information within SQL Server 2000 version, as that talks about SQL 2005 version specific. Within SQL 2000 to troubleshoot further about a SPID you can use: DECLARE @Handle binary(20...
You might have observed errors when using Performance Dashboard reports that is available (recently) for SQL Server 2005, the error below is mostly ocurred: Difference of two datetime columns caused overflow at runtime. Based on the forums & other blogs on the web suggests that The fix for that error...
Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow a database administrator to quickly identify whether...