Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nandac
Starting Member
27 Posts |
 Posted - 2008-12-03 : 09:41:44
|
| 1. transactions which have been running for over 15 minutes.2. transactions which have been blocked by other transactions. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 09:45:29
|
| 1. transactions which have been running for over 15 minutes.SQL Profiler with Duration> 15min2. transactions which have been blocked by other transactions.sp_who2 activeactivity monitorsys.processes |
 |
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-03 : 09:52:14
|
| no, i need to get it from a system table or view. |
|
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-03 : 09:53:30
|
| is it sys.processes or sysprocesses? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 09:54:42
|
| Do one thing:Look at standard reports that comes with SQL 2005.They have all info. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 09:55:18
|
quote:
Originally posted by nandac
is it sys.processes or sysprocesses?
oops!! its sys.sysprocesses in 2005. |
|
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-03 : 10:02:32
|
| how/where can i see the standard reports?and how do i get a label for a column?for example : select db_name(dbid) from sys.sysprocesseshow can i get a title/lable for the dbname? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 11:46:20
|
| You can see in summary page for Reports. Look at Spid and find the statements with DBCC inputbuffer(spid). |
|
|
|
|
|
|
how do i get