Monitoring SQL Server Connections

[Hack]

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

[Blade]

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...

[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....

[Hack]

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.

[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.

[Hack]

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!

[Hack]

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.

[RobDog888]

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.