SQL Server: Connect using a different port

Connect using a different port using a comma between the server name/IP and the port:

servername,port 

or 

serverIP,port

netstat - network statistics

netstat is a command displays statistics on all network activities.

main options:

-a Displays all active ports

-n Numerical display of addresses and port numbers

-o Displays the process identifiers (PID)

| grep 11753 - displays information only for IP 11753 (or other filter)

netstat -a -n | grep 11753

SAP (sybase) RS - some basic and useful scripts and queries

Select RS version

1. Login RS and run:

admin version

2. Without login:

cd $SYBASE/REP-16_0/bin/

repserver -v

A list of running / not running components

admin who

admin who_is_down

(Executed from RS)

Get the name and path of the RS log

admin log_name

(Executed from RS)

Information about databases and replication definitions

select * from rs_databases

select * from rs_subscriptions

select * from rs_publications

select * from rs_dbreps

exec rs_helpdb

exec rs_helprep

exec rs_helpsub

(Executed from RSSD databse)

sp_monitor - statistics about SAP ASE Server

sp_monitor displays statistics about SAP ASE Server.

It can run with few options:

1. General information about how busy the Server has been:

sp_monitor

go

2. Information about connections:

sp_monitor "connection"

go

sp_monitor "connection","diskio"

go

3. Information about statements:

sp_monitor "statement"

go

4. Information about the most recently run procedures:

sp_monitor "procedure"

go

* and more.....

More details in SAP site.