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 |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2003-08-21 : 04:54:07
|
| Dear All,I would like to do the following at database level.1. I would like to know the current activities for a database2. Which users initiated the above activities and what query they fired3. I would also like to keep a history of the aboveWhat counters should I use and how do I maintain a history..???Pls. helpRegards |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-08-21 : 06:45:45
|
| sp_who2 will tell you the current activity on the database. DBCC INPUTBUFFER (process id) will show you the code being executed by each user process.-------Moo. :) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-21 : 12:30:26
|
| You could also run SQL Profiler to get detailed information. I would not recommend maintaining a history though because you are going to be tracking quite a bit of information.Tara |
|
|
|
|
|
|
SQL Counters !!!