Eeik! Actually, as cheap as RAM is right now, throw in another 768MBs. You
can probably pick it up for <$200. It'll definitely help exponentially. (You
should never run a SQL Server w/less than 768MB/1GB of RAM. Memory is just
so cheap now, there's no excuse not to.)
Of course, make sure you've got all your indexes applied, run trace routes
on your queries to look for points of optimization, etc...
-Dan
> -----Original Message-----
> From: Ben Densmore [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 9:59 AM
> To: CF-Talk
> Subject: Speeding Up SQL Server
>
>
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
