How can I tell how many SQL Connections I have open in a windows service?
If you're using .net, there's the .net data provider for SQL server in PerfMon. You can look at NumberOfPooledConnections there
sp_who2 stored procedure in the master table is nice for this from a database side. It will show you connections to the database. If you're looking for more data try profiling as well.