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 |
|
PaTRiCKDRD
Yak Posting Veteran
55 Posts |
 Posted - 2007-06-16 : 05:53:08
|
| Hi guys!I have built a website using asp.net 2005 that uses sql server 2005 database,my question is,which tool can I use to monitor the connections to the database,because I feel that some of them are left open for a very long time.Thanks in advance! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-16 : 17:40:05
|
| Use sp_who2, or look at them in ssms -> management -> activity monitor. |
 |
|
|
PaTRiCKDRD
Yak Posting Veteran
55 Posts |
Posted - 2007-06-17 : 05:42:17
|
| what is ssms and how do I run it? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 15:33:24
|
| It's sql server management studio, can install it with sql2k5 client and other sql tools. |
|
|
|
PaTRiCKDRD
Yak Posting Veteran
55 Posts |
Posted - 2007-06-17 : 18:22:05
|
| I'll try both of them, thank you very very much! |
|
|
|
|
|
|
connection monitoring tool