Re: netstat on my server

Thanx Andy.
Yeah i have a linux firewall. Thats why i need to know what to look for in
netstat, so i can block these on the firewall.
My server needs to be accessed externally, through asp pages and enterprise
manager, so i cant block port 1433.
What im trying to do is find a way in netstat to find out if there are too
many of a specific connection to my server.
Then block that on the firewall.


"Andy Davis" <activecrypt@xxxxxxxxx> wrote in message
news:745D1ABC-B882-49E4-A7E3-95D2142BC2D5@xxxxxxxxxxxxxxxx
> Hi,
> run this in QA :
>
> SELECT CONVERT(char(20), SERVERPROPERTY('servername'))
> SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses'))
> SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType'))
> SELECT CONVERT(char(20), SERVERPROPERTY('productversion'))
> SELECT CONVERT(char(20), SERVERPROPERTY('productlevel'))
> SELECT CONVERT(char(20), SERVERPROPERTY('Engine Edition'))
> SELECT CONVERT(char(20), SERVERPROPERTY('Edition'))
>
> as far as those application accessing yr server are authorised by you and
> not from anonymous don't worry but plz use firewall tooo.
>
> HTH
> --
> Andy Davis
> Activecrypt Team
> --------------------------------------------
> SQL Server Encryption Software
> http://www.activecrypt.com
>
>
>
> "rvegas@xxxxxxxxxx" wrote:
>
>> how do i check what editon of SQL i have?
>> I just noticed that i have more than 5 connections to the same IP on port
>> 1433 when i run netstat. Should i be worried about that?
>> Thanx
>> "Andy Davis" <activecrypt@xxxxxxxxx> wrote in message
>> news:2C7AEE30-350C-47A9-9269-94AD3AF3F880@xxxxxxxxxxxxxxxx
>> > Hi,
>> > nope it is not the solution , have you check EP for correct INDEX
>> > seeking
>> > !
>> > statistics are all updated , index is defreged ! on top of all is your
>> > application have complex calulation ?!
>> >
>> >> 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.
>> > --- IT SHOWS THAT YOUR SQL SERVER IS WITH IIS , RIGHT ?! I WOULD
>> > SUGGEST
>> > YOU
>> > THAT CHOOSE RAID1 FOR OS AND RAID 5 OR RAID 10 (DEPENDS UPON READ /
>> > WRITE
>> > IS
>> > MORE) BASED ON HOW YOUR APPLICATION WORKS (READ / WRITE MORE) .
>> > ONE MORE THING , MAY BE YOU KNOW BUT IF YOU ARE USING STANDARD EDITION
>> > YOU
>> > CAN NOT USE MORE THAN 2 GB OF RAM , YOU HAVE TO HAVE ENTERPRISE / DEV
>> > EDITION
>> > TO USE MORE THAN 2 GB OF RAM . READ MAXIMUM CAPICITY SPECIFICATION IN
>> > BOL
>> > FOR MORE.
>> >
>> > HTH
>> > :-)
>> > Regards
>> >
>> > --
>> > Andy Davis
>> > Activecrypt Team
>> > --------------------------------------------
>> > SQL Server Encryption Software
>> > http://www.activecrypt.com
>> >
>> >
>> >
>> > "David J. Cartwright" wrote:
>> >
>> >> 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