Re: netstat on my server

I have no RAM left on the server. Every time i logon and try anything the
server hanngs and needs to be rebooted.
The server has 2GB RAM and all is used up, so i need a way to figure which
domain is taking up all the ram.
Taskmanager shows sqlservr.exe taking up the ram.
I know i need to add ram, but first i want to make sure no users are abusing
the server.

"Andy Davis" <activecrypt@xxxxxxxxx> wrote in message
news:D6BAD1B0-3550-4423-BB49-4EA2383EA093@xxxxxxxxxxxxxxxx
> 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: Remote site is soooooo sslllloooooowwwww
    ... Sounds like a Virtual memory issue when the server is taking snap shots. ... Did you increase the virtual memory after you added the RAM as Dirk ... high internet traffic is slowing my connection down so much as to make ... >>> our remote access is running exceedingly slow... ...
    (microsoft.public.windows.server.sbs)
  • Re: Alocated Memory Error (SQLSERVR)
    ... but my understanding is that the MSDE instances are designed to ... and you don't want it grabbing all that RAM. ... running but non ever going about 200mb of memory usage. ... Server 2000 SP4, ...
    (microsoft.public.windows.server.sbs)
  • Re: High memory usage (*HELP*)
    ... you can use Computer Management MMC to view the server logs. ... a server with 4 GB RAM, I doubt you need the second page file on D. So ... The virtual memory on D: drive is set to: 1550/3075 ... throttled ISA and Monitoring. ...
    (microsoft.public.windows.server.sbs)
  • Re: High memory usage (*HELP*)
    ... report that resides on that server I will get error pertaining to low vm. ... the RAM question because I suspect the SBS is taking care of that as it ... The virtual memory on D: drive is set to: 1550/3075 ... represent, so you can tell if it's ISA, Monitoring, or SharePoint. ...
    (microsoft.public.windows.server.sbs)
  • Re: High memory usage (*HELP*)
    ... I rebooted the server, I should have just restarted the service for report ... a server with 4 GB RAM, I doubt you need the second page file on D. ... The virtual memory on D: drive is set to: 1550/3075 ...
    (microsoft.public.windows.server.sbs)