I know you said no hardware upgrades but adding more RAM than 128Mb would help a lot,
and with RAM so cheap these
days it should be easy. We run SQL server on a box with 1000 Mb - in my experience RAM
gives you better SQL bang
for the buck than CPU.
- Michael Smith, TeraTech, Inc http://www.teratech.com/
MDCFUG http://www.cfug-md.org/
Expert ColdFusion, SQL and Access Programming.
Andy Ewings wrote:
> If you've onlyu got 500,000 recs between the three the machine you have
> should suffice unless you are running all sorts of other stuff on it. we
> have a machine here that is a P500 but we are running it as a file server,
> mail server, web server, and SQL server.
>
> The main cause of the speed could well be down to the code you use to
> interogate it. Use SP's where possible. Stay away from Cursors, and
> generally ensure code is efficient as poss
>
> -----Original Message-----
> From: Alex [mailto:[EMAIL PROTECTED]]
> Sent: 08 June 2001 15:38
> To: CF-Talk
> Subject: Re: [Speeding Up SQL Server]
>
> Are you sure its the machine? Or is it the network, or the code, or the DB
> design
>
> "Ben Densmore" <[EMAIL PROTECTED]> wrote:
> I was wondering if someone can give me some ideas of the best way to speed
> up
> SQL Server? Right now our server that runs SQL Server is not the fastest of
> machines, actually it's quite slow. it's a P 200 with 128 megs of ram. I've
> been bugging the company to buy a new server which they did but now they
> want
> to use that server for something else. Anyway, now they want to try and find
> ways to speed it up without upgrading the hardware. We have 3 DB's running
> with a total of probably 500,000 records between the 3.
>
> Thanks for any help.
>
> Ben
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
