Showing posts with label creeping. Show all posts
Showing posts with label creeping. Show all posts

Monday, March 19, 2012

Memory usage SQL Server 2000

Hi,
We have a scenario wherein RAM usage is creeping up until the DB has to be restarted (SQL server 2000 no service packs). There are 15 concurrent users connecting via ODBC (TCP/IP).
Please can anyone give any tips as to how we can track down the problem?
Thanks.We are also having the same problem on a couple of our MSSQL Server 2000 machines. All help in this would be greatly appreciated.
Sam|||You need to have a server with the following configuration:
It must include Backup Drive PV110T DLT1 40/80GB INTERNAL
and also the server preferrably must contain the following:
PowerEdge 6400 PIII Xeon 700MHz/2MB
2 x Terminator Card PE64x0
Add. CPU PIII Xeon 700MHz/2MB
2GB (4*512) 133MHz SDRAM
48x IDE CD-ROM
PERC3/DC 128MB RAID, U160 SCSI
4 x 36GB SCSI HDD, 15K RPM, 80-pin
Embedded Intel Pro 100+ PCI Ethernet NIC
and other ordinary devices.

You must have a very excellent RAM Capacity as mentioned above to avoid the slow performance of your service and to allow all users maintain their own work without any complaints.

Wish you good luck.

memory usage issues

the memory usage on our SQL 2000 server keeps creeping up to near 1.5 gig
out of 2.5 gigs. is this normal? is there a way to prevent this? should it
be controlled somehow?From BOL:
--snip
To acquire as much memory as possible without generating excess paging I/O,
each instance of SQL Server sets a target of acquiring memory until free
physical memory on the computer is in the range of 4 MB to 10 MB. This range
was chosen because testing has shown that Windows NT and Windows 2000 have
minimal memory swapping until the memory allocations equal the available
physical memory minus 4 MB. An instance of SQL Server that is processing a
heavy workload keeps the free physical memory at the lower end (4 MB) of the
range; an instance that is processing a light workload keeps the free memory
at the higher end of the range (10 MB).
--snip
This behavior is expected and is designed for maximum performance on a
dedicated SQL server.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"harun kazi" <kazi[RemoveThis]@.wideopenwest.com> wrote in message
news:OqgYjHOYDHA.1736@.TK2MSFTNGP10.phx.gbl...
> the memory usage on our SQL 2000 server keeps creeping up to near 1.5 gig
> out of 2.5 gigs. is this normal? is there a way to prevent this? should it
> be controlled somehow?
>|||thank you both.
"harvinder" <hs@.metratech.com> wrote in message
news:001b01c360e4$282db540$a301280a@.phx.gbl...
> sql server will like to take most of the memory if
> required and no other process need memory... generally it
> is good idea to leave it this way(dynamic)...but if u
> want to have control over memory usage u can change the
> parameter max memory from EM or QA.
> Thanks
> --Harvinder
> >--Original Message--
> >the memory usage on our SQL 2000 server keeps creeping up
> to near 1.5 gig
> >out of 2.5 gigs. is this normal? is there a way to
> prevent this? should it
> >be controlled somehow?
> >
> >
> >.
> >|||Additionally SQL will not release memory ( even if no one is logged in)
unless there is < 5 ( between 5 and 10 ) MB of free memory... Why work to
reduce memory utilization if there is no need?
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and its
community of SQL Server professionals.
www.sqlpass.org
"harun kazi" <kazi[RemoveThis]@.wideopenwest.com> wrote in message
news:OqgYjHOYDHA.1736@.TK2MSFTNGP10.phx.gbl...
> the memory usage on our SQL 2000 server keeps creeping up to near 1.5 gig
> out of 2.5 gigs. is this normal? is there a way to prevent this? should it
> be controlled somehow?
>|||And just to hammer it home :-)
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"harun kazi" <kazi[RemoveThis]@.wideopenwest.com> wrote in message
news:OqgYjHOYDHA.1736@.TK2MSFTNGP10.phx.gbl...
the memory usage on our SQL 2000 server keeps creeping up to near 1.5 gig
out of 2.5 gigs. is this normal? is there a way to prevent this? should it
be controlled somehow?