Re: netstat on my server

Hi,
the best thing is to check with SQL Profiler .

:-)
Regards
--
Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com



"David J. Cartwright" wrote:

> you can use taskman to view what procs are using what memory.
>
> also the current activity tab in EM will give you connection info.
>
> PerfMon can aslo be used.
>
> <rvegas@xxxxxxxxxx> wrote in message
> news:OmOmw6mAGHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
> > Actually yes my server has a vb script that sends out emails.
> >
> > Basically i want to know who is connecting to my server, and what they are
> > using.
> > My server is consuming a lot of ram and i want to find out why? maybe its
> > sites not releasing connections. How can i find this out?
> >
> > Thanx
> >
> > "David J. Cartwright" <davidcartwright@xxxxxxxxxxx> wrote in message
> > news:euohWjlAGHA.436@xxxxxxxxxxxxxxxxxxxxxxx
> >> since your email is @rogers.net i would get that one connection is you,
> >> as for the other is your sql server sending notifications ?
> >>
> >> <rvegas@xxxxxxxxxx> wrote in message
> >> news:e6QXqFcAGHA.216@xxxxxxxxxxxxxxxxxxxxxxx
> >>>A netstat on my MSSQL server shows
> >>> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2060 ESTABLISHED
> >>> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2114 ESTABLISHED
> >>> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com.com:2195 ESTABLISHED
> >>> TCP MSSQL12:ms-sql-s c2-asp9.mydomain.com:2215 ESTABLISHED
> >>> TCP MSSQL12:ms-sql-s
> >>> wsp05956800wss.cr.net.cable.rogers.com:3063 ESTABLISHED
> >>> TCP MSSQL12:ms-sql-s mailserver.uslive.net:1972 ESTABLISHED
> >>>
> >>> I know the first four connections are servers on my domain, with asp
> >>> pages connecting to the DB. The other too I dont know what those are.
> >>> Does that mean that some other sites are connecting to my server as
> >>> well? If so how can I tell what they are accessing? And how can I stop
> >>> them? Thses are just some of the connections in netstat, what else
> >>> should I be looking for and what ports should I block for security?
> >>> Im new to MSSQL so any help or links would be appreciated.
> >>>
> >>> Thank you
> >>>
> >>
> >>
> >
> >
>
>
>
.

Relevant Pages

  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to Direct connect with ActiveSync
    ... That won't work because you have a connection string that can't be correct. ... You're saying that the database is, but it's not; ... Server 2000, Visual Studio 2008. ... Again sorry if this should be in another form but you say that SQL Server ...
    (microsoft.public.sqlserver.ce)
  • .Net Scalability problem
    ... I finished a Great project using .Net and SQL Server and .Net Mobile ... Million concurrent users ... So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.sqlserver.connect)
  • Re: Communication Link Failure Error
    ... On disconnection from the network, in my code I changed the connection ... string to use SQLOLEDB and sent a SQL query to SQL server which failed as ... unplug the network cable from the client machine and put the cable ...
    (microsoft.public.data.ado)