Posted by Dylan Parry on 02/19/07 15:49

Uri Dimant wrote:

> Take a look at execution plans of the quries to make sure that optimizer is
> available to use indexes.

Thanks. I usually do this once I am happy with the general set-up of the
database. It's just that I've noticed that the machine can sometimes be
a bit sluggish when I'm accessing SQL Server.

> How big is your DB?

Hmm, now I think this might be where I discover some problems! I've just
checked the database and it purports to be 4.5GB in size. Now if I view
each of the tables and add up their respective sizes, it comes to less
than 400MB (not including indexing). So something doesn't seem right here...

> How much memory does the server have?

It's got 1GB RAM.

--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk

Programming, n: A pastime similar to banging one's head
against a wall, but with fewer opportunities for reward.

[Back to original message]