Monitoring SQL Server Connections

Other than SQL Profiler, are there other tools, within SQL Server, that can be used to monitor database connections?

Take a look at Performance Monitor. It's not within SQL itself but is part of Windows (in Control Panel > Administrative Tools).
You can use it to monitor a whole variety of sql info such as CPU usage, cache hits, connections, trans/per sec etc...

In what way to you need to monitor them? In Enterprise Manager you can see the active processes for each db object id.
In Query analyzer you can execute the sp_who and sp_who2 stored procedures to monitor activity, etc....

Quote:

---

Originally Posted by RobDog888

In what way to you need to monitor them? In Enterprise Manager you can see the active processes for each db object id.
In Query analyzer you can execute the sp_who and sp_who2 stored procedures to monitor activity, etc....

---

Cool. I'll try them.

You can copy the sp_who and modify it to reduce the number of fields it returns or add a where clause so it will be only for a particular db or app.
Place the modified copy in the concerned db's sp folder and execute from there.

Quote:

---

Originally Posted by RobDog888

You can copy the sp_who and modify it to reduce the number of fields it returns or add a where clause so it will be only for a particular db or app.
Place the modified copy in the concerned db's sp folder and execute from there.

---

Another sterling idea! :thumb:

FYI to all database folks. These two SPROCS that RobDog888 mentioned are pretty neat. I made a couple of modifications to sp_who2, and it is returning the information that I/we need.

Thanks.

Thanks Hack. Actually I stumbled across them last year when I was writting a SQL DB app for a city police department. I modified
them to provide a "Who's On-Line" feeature in the app. :D