In SQL Server 2008 when we open activity monitor we can see SPID and information related for that SPID . But what if we want to get detail information for that SPID.
In SQL Server 2008 MS has provided a easy way for this , when we right click on this process , menu has one more option available "Trace Process in SQL Server Profiler".
So it will directly open profiler ,filter it for that SPID and start to trace this SPID. This can be handy many times for trouble shooting or monitoring activity for selected SPID
Cheers
In SQL Server 2008 MS has provided a easy way for this , when we right click on this process , menu has one more option available "Trace Process in SQL Server Profiler".
So it will directly open profiler ,filter it for that SPID and start to trace this SPID. This can be handy many times for trouble shooting or monitoring activity for selected SPID
Cheers
1 comment:
Post a Comment