SQL memory requirements

[NorthEast]

Looking at the system requirements for Analyzer, it says you can use a 1GHz Pentium 3 with 512MB memory.

I find that Analyzer runs very slowly. I'm using a dual core 2GHz PC with 2GB memory, working with projects of around 100-150 topics, and the system is still pretty sluggish.

Checking the memory usage, I found that the 'SQL Server Windows NT' process was using up a whopping 1GB of memory.

I closed down Analyzer and checked it again. It was still around the 940MB mark, gradually ticking down by about 1MB a second.

Is this normal?

[RamonS]

Yes, SQL Server is a pig. IMHO way to huge of a db engine for what Analyzer does. And I think the system requirements apply to the Analyzer application, not the SQL Server.

[NorthEast]

I'm just wondering what is a realistic specification for system that isn't going to get bogged down.

SQL server seems to eat up anything from 400MB-1GB, and Analyzer from 100-200MB.

[RamonS]

What you should be able to do is run SQL Server on a different PC if you have a second one available.