Posted by Greg D. Moore \(Strider\) on 12/21/06 12:49

<nitin.goel@daffodildb.com> wrote in message
news:1166681115.492154.131080@79g2000cws.googlegroups.com...
> Thank you for replies. Some more information from my side:
>
> 1. Sorry I have made a mistake, our DB size is 50 GB not 20 GB (typing
> mistake).
> 2. There are around 100 concurrent users accessing this db from 30
> locations.

Again, the TYPE of query really matters. If each query takes a 100
milliseconds vs. 10 seconds.

> 3. There is only one CPU in the box and only SQL Server runs on it.

Well you may or may not be CPU bound, again, depends a lot on what you're
doing her.e

> 4. Regarding I/O performance, what more can be done in I/O area (
> that's a very novice Q but I have never worked in this field ).

Add disks. Lots of disks. Fast disks.

You're better off with 10 40 gig disk tha 1 400 gig disk for example.

(of course that's ignoring RAID and doing stuff like putting your logs on
their own physical disk group.)

Just as a point of reference we had a system handling 14 million selects and
inserts a day running on a 6 yo 4-way Xeon machine up until recently. Just
recently moved this to a 2-way modern box AND added a bunch of other
queries.... and if anything it's faster than before.


> 5. We will post some queries by Monday morning.
>
> BTW I know price of both SE and EE but we will spend only if we see any
> gain EE. And we are also ready to spend on I/O if it is good for us.
>
>
> Thanks again
> Nitin Goyal
>

[Back to original message]