Re: Win Server 2003 and SQL Server 2000

From: DataMan (randyelliott_at_mindspring.com.(donotspamx))
Date: 03/18/05 

Date: Fri, 18 Mar 2005 11:15:04 -0800

There are over 100 free GB on each drive. The database is less than 30mb in
size. The processor is aPent 4, 2.8 GH Dell. There is 1 GB of memory.
I am the only user. This is a development machine. I am testing our
product for upward compatability.

"Jéjé" wrote:

> post this in the SQL Server newsgroup.
>
> Does your server has enough resources? (memory)
> what are the table size and server processors?
>
>
> "DataMan" <randyelliott@mindspring.com.(donotspamx)> wrote in message
> news:7F62122C-9EB4-4320-B6BF-E67CB29B05F7@microsoft.com...
> >I have a Win server 2003 enterprise os and also on the computer I have sql
> > server 2000. When I run a program which opens appx 30 tables on the
> > server
> > (2003) it takes about 3-5 minutes to perform the operation. When run the
> > program from my development computer (XP Pro) pointing to the tables on
> > the
> > server 2003 computer across the network the tables open in 1-5 seconds.
> > Runniing on the host is slow. Running across a network is fast. Any
> > ideas
> > on why this is happening.
> >
> > Thanks
> > --
> > Randy
>
>
>

Relevant Pages

  • Re: PowerEdge SC600 memory upgrade
    ... example everytime I work on a Dell I either remove or relocate the I386 ... Speaking of network printing, they are connected to HP print servers that I ... This program *has* to be on the C: drive of the server otherwise it won't ... that is what I feel that adding more memory should at ...
    (alt.sys.pc-clone.dell)
  • Re: Windows 2003 RAM detection
    ... Dell is investigating. ... RAM is known (on an other server model) to take 1GB away for the raid ... memory and that should do fine without taking away memory from the system). ...
    (microsoft.public.windows.server.setup)
  • Re: Server reboots
    ... The server is using all Dell Memory - it has 6Gb, ... regarding the /3GB switch for use with Exchange 2000 ... Advanced server, however I cannot believe that the server ...
    (microsoft.public.exchange2000.general)
  • Server Freezing Up
    ... For a couple months now our Windows Server 2003 R2 SP2 has been ... freezing up and we couldn't figure out why. ... We have a Dell PowerEdge ... new memory. ...
    (microsoft.public.windows.server.general)
  • RE: server problems
    ... This newsgroup only focuses on SBS technical issues. ... >Thread-Topic: server problems ... >> web proxy service or SQL Server will normally use large memory. ...
    (microsoft.public.windows.server.sbs)