Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mark Greenbaum » Find the Port a Connection is Using
Add to briefcase
15 posts, Page 1 of 2
12»»

Find the Port a Connection is Using Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
MG-148046
Posted Tuesday, July 06, 2010 11:35 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:17 AM
Points: 1,625, Visits: 1,926
Comments posted to this topic are about the item Find the Port a Connection is Using

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Post #948303
fluppe_be
Posted Wednesday, July 07, 2010 1:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 12, 2010 9:45 AM
Points: 2, Visits: 7
Works great in SQL 2005!
However, i have several sites still running on SQL 2000, the script is not working in there (i think the table does not exist yet). Do you have a similar script for SQL 2000? Would be great!
Post #948364
Chris Houghton
Posted Wednesday, July 07, 2010 1:47 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:03 AM
Points: 557, Visits: 1,357
It won't work in SQL 2000. The query uses Dynamic Management Views which were only introduced in SQL Server 2005.

Excellent article that I'm sure will come in handy at some point. Thanks for sharing.
Post #948368
fluppe_be
Posted Wednesday, July 07, 2010 1:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 12, 2010 9:45 AM
Points: 2, Visits: 7
Thanks for you reply
I was used to use the SP_WHO function, but this does not show the ports
Any way around possible?
Post #948370
shyamalshukla
Posted Wednesday, July 07, 2010 4:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 10:37 PM
Points: 62, Visits: 50
Thanks for sharing this info.
Post #948430
MG-148046
Posted Wednesday, July 07, 2010 6:57 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:17 AM
Points: 1,625, Visits: 1,926
fluppe_be,

sp_who in SQL 2008 uses a system view in the resource database so I think you will need to write your own version of sp_who or search for one that meets your needs. There are quite a few available that use the DMVs and you would be able to easily add the port to any of them.

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Post #948502
Rick.Cornell.SME
Posted Wednesday, July 07, 2010 7:55 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Saturday, March 24, 2012 3:31 PM
Points: 4,238, Visits: 207
I think it would if useful to also add the client_tcp_port from the connections DMV, because your SQL Server should only be using 1 open port?
Post #948548
SQLRNNR
Posted Wednesday, July 07, 2010 2:49 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337
Nice article. Thanks for sharing.


Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #948849
pparsons
Posted Wednesday, July 07, 2010 9:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:42 PM
Points: 15, Visits: 78
Too bad these views don't exist on SQL2K
Post #948970
Atif-ullah Sheikh
Posted Thursday, July 08, 2010 12:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:15 AM
Points: 3,240, Visits: 4,960
Nice script. Very useful information.
Thanks.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here
Post #949026
« Prev Topic | Next Topic »

Add to briefcase
15 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.