Re: SQL Server Express Edition

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You are correct that Expresss will only use 1GB of RAM; the machine may have
much more. I do not know the costs of Workgroup, but it is reasonable from
what I hear. I always recommend a server for databases instead of a
workstation - less flaky.

Scaling Up on SQL Server especially from an Access DB will also warrant more
care / maintenance. As a DB grows, the data itself tends to become more
valuable and you need to start thinking about Backup/Recovery and some basic
Best Practices for both safety and performance. Something like placing your
data files on different physical hard disks than the log files is one item
that I see is often overlooked when scaling up. MSFT has a Best Practices
Analyzer tool (Free Download) that may be overkill for your situation, but
it can also be very educational once you have your test system setup to find
out what you may need to do. Often, best practices involves lots of $$$,
but knowing the Worst Practices for SQL may be what is warranted here.
Check out www.sqlservercentral.com and search for articles on worst
practices as I seem to remember a series of articles that you may enjoy.

Hope this helps!

Rick Heiges
SQL Server MVP

"DJPogoff" <djpogoff_at_complexNOSPAMnet_dot_com> wrote in message
news:C16D45EC-CBDE-4B32-9979-DDBFEFC609CE@xxxxxxxxxxxxxxxx
Rick,

Thanks for your help and the link to the comparison.

When I see "1 GB of RAM only", I assume that imposes no restriction on the
amount of RAM installed in the machine, and for example, Win2003 can have
4
GB installed. Rather, you're saying that SQL Server Express Edition
itself
will use no more than 1 GB of the RAM installed. Am I understanding?

Perhaps I'd be better off with the Workgroup Edition. Is this still
software that is installed on a server? Offhand, do you know the cost?

Thanks and regards,

David
----

"Rick Heiges" wrote:

There are many differences between Express and Standard. Here is a link
to
a comparison chart.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Some basic limitations of Express include
- 1 CPU only
- 1 GB of RAM only
- 4GB Database Size Limit

For your application that is being upsized from Access, Express may very
well suit your needs and the price is right. I personally think that
Express is great for a FREE product as are the other "Express" editions
of
Visual Studio.

Rick Heiges
SQL Server MVP


"DJPogoff" <djpogoff_at_complexNOSPAMnet_dot_com> wrote in message
news:10F6BE01-7035-4AC0-902A-E2E657303314@xxxxxxxxxxxxxxxx
My understanding is that SQL Srvr 2005 Express Edition is (nearly)
identical
to the Standard Edition with the exception that the number of users is
limited. Are there other differences?

What I'm planning is to use the Express Edition for a client's
application
after using the Access Upscaling tool.

Any advice is greatly appreciated.
--
Thanks and regards,

David





.

Relevant Pages

  • Re: SQL Server 2000 and Memory
    ... There is a long and involved debate over what should be 'install' and what ... there should be an external configuration ... I support the Professional Association for SQL Server ... RAM usage just slowly grows until everything starts swapping out ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 and Memory
    ... they need the full SQL Server due to the database size but the daily volume ... website is meant for embedded database type applications. ... RAM usage just slowly grows until everything starts swapping out to ... > constant so giving back memory is not a big issue. ...
    (microsoft.public.sqlserver.server)
  • Re: INSUFFICIENT MEMORY
    ... That's totally dependant on how the data is structured, how the app is ... a certain amount of ram to operate properly. ... Andrew J. Kelly SQL MVP ... >> the standard editions of the OS and SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: 300MB DB uses 1.4GB RAM!?
    ... DBCC MEMORYSTATUS will tell you how SQL Server memory manager has ... So, if every page was in memory, there's 300mb. ... the more ram SQL takes the better!! ... allocation for SQL Server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: memory usage/allocation/paging question
    ... paging to disk more often if one reduces the amount of available RAM ... the more data and execution plans SQL Server can hold in cache, ... If other applications on the same box calls for more memory, ... If you are running IIS on the same box, ...
    (comp.databases.ms-sqlserver)