« Java Infested Week | Main | What's the best way... »
20031006 Monday October 06, 2003

Monitor Connections in SQL Server Does anyone know how to monitor the number of Connections in SQL Server? In MySQL, I use "mysqladmin processlist", but there doesn't seem to be such a utility for SQL Server. I need to make sure that my connections are getting closed properly. Posted in Java at Oct 06 2003, 04:54:46 PM MDT 4 Comments

Comments:

Hey Matt, SQL Server has someting called SQL Profiler (i believe thats the correct name). Look under your installed SQL Server applications and you should see it. Start it up, and connect to the server that you want. Then run a trace, and it will show you exactly in real time what is going on in the server.

Posted by John on October 06, 2003 at 05:05 PM MDT #

Look at MyTop.

Posted by Erik C. Thauvin on October 06, 2003 at 06:44 PM MDT #

I don't have SQL Server book @ home, but looking at the system tables; I would think that either sysprocesses or sysusers my be what you want to look. I'm thinking sysprocesses I've always used the Enterprise manager for this stuff. If you are using Entprise manager, you can point and click to get all the details of the database. You'll need to have adminstrator access. If you these don't help you out, drop me a line tommorrow I'll look the exact instructions. You might also want to check out www.sqlmag.com, which is magazine and website just for SQL Server. Just don't expect any Java tips ;)

Posted by Jeff Duska on October 06, 2003 at 07:40 PM MDT #

Try SQLSPY freeware from SQL SPY

Posted by Abrar Kazi on October 14, 2003 at 12:50 AM MDT #

Post a Comment:
  • HTML Syntax: Allowed