Matt RaibleMatt Raible is a Web Developer and Java Champion. Connect with him on LinkedIn.

The Angular Mini-Book The Angular Mini-Book is a guide to getting started with Angular. You'll learn how to develop a bare-bones application, test it, and deploy it. Then you'll move on to adding Bootstrap, Angular Material, continuous integration, and authentication.

Spring Boot is a popular framework for building REST APIs. You'll learn how to integrate Angular with Spring Boot and use security best practices like HTTPS and a content security policy.

For book updates, follow @angular_book on Twitter.

The JHipster Mini-Book The JHipster Mini-Book is a guide to getting started with hip technologies today: Angular, Bootstrap, and Spring Boot. All of these frameworks are wrapped up in an easy-to-use project called JHipster.

This book shows you how to build an app with JHipster, and guides you through the plethora of tools, techniques and options you can use. Furthermore, it explains the UI and API building blocks so you understand the underpinnings of your great application.

For book updates, follow @jhipster-book on Twitter.

10+ YEARS


Over 10 years ago, I wrote my first blog post. Since then, I've authored books, had kids, traveled the world, found Trish and blogged about it all.

RECENT ENTRIES


Tag Cloud


abbie appfuse birthday denver family grails gwt jack java javascript jhipster jsf linkedin maven roller skiing softwaresummit spring springmvc struts2 travel trish vacation webframeworks wicket
« Java Infested Week | Main | What's the best way... »
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 11:05 PM MDT #

Look at MyTop.

Posted by Erik C. Thauvin on October 07, 2003 at 12:44 AM 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 07, 2003 at 01:40 AM MDT #

Try SQLSPY freeware from SQL SPY

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

Post a Comment:
  • HTML Syntax: Allowed