Re: netstat on my server

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

  • Re: netstat on my server
    ... >>> Andy Davis ... >>> Activecrypt Team ... >>> SQL Server Encryption Software ...
    (microsoft.public.sqlserver.security)
  • RE: No data in Sql server 2005
    ... >> Andy Davis ... >> Activecrypt Team ... >> SQL Server Encryption Software ...
    (microsoft.public.sqlserver.security)
  • NetLib Encryptionizer still available?
    ... I've been trying to get details of the SQL Server encryption software ... from them with no response. ... Failing that, is there another comparable product available? ...
    (microsoft.public.sqlserver.security)