Re: netstat on my server

you can restrict how much memery sql uses

<rvegas@xxxxxxxxxx> wrote in message
news:OyHnrPaBGHA.1312@xxxxxxxxxxxxxxxxxxxxxxx
>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: SQL-SERVER 2005 SP2 und Microsoft Dynamics 5.0 (ehem. Navision
    ... Wert ist immer zwischen 84,7 -99,8 akt. ... es geht darum wieviel % der Daten, die der SQL Server wollte bereits in seinem Workspace waren. ... 16 GB 2 GB RAM ...
    (microsoft.public.de.sqlserver)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • Re: Seems like only 1GB RAM being used even when higher MAX RAM is
    ... It is Sql 200 enterprise, ... Both machines are equipped with 8gb of RAM. ... you said your SQL Server 2000 instance is ... If your SQL Server 2000 is Enterprise Edition and your Windows Server 2003 ...
    (microsoft.public.sqlserver.setup)
  • Re: Hardware Recommendations
    ... Well you are right in SQL being CPU/RAM intensive, but also is very IO intensive, as is Exchange. ... IIS, load up on RAM and get some good CPUS, for disk, the faster the reading the better. ... Your Domain Controllers should have good cpus, and a good amount of RAM, disks...just make sure you mirror them. ... I am asking in general what the most important components are for say an IIS server. ...
    (microsoft.public.windows.server.general)
  • 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)