Re: SQL server express

Lou O <lgoosterhoff@xxxxxxxxx> wrote:

Lou O <lgeastw...@xxxxxxxxx> wrote:
I want to try to use the SQL upsizing wizard in Access2007 so I
downloaded and installed SQL server express (with .NET framework etc).
SQL took a very long time to install and my computer now is very slow.
I'm sure I've got sufficient resources because Office 2007 ran fine
before installing SQL server. Has anyone had any experience with this
and could give me a tip on how to get my computer's performance back?

Chances are you need more RAM in your computer.  SQL Server can suck up to 200 Mb of
RAM at rest.   Run Task Manager (taskmgr or Ctrl+Alt+Del) and take a look.
Fortunately RAM is fairly cheap these days.

Thanks Tony,
I had 5 megs of ram and just upgraded to 1 gig to see if it helped.

Presumably you meant 512 Mb of RAM. I'm finding that even 1 Gb of RAM these days is
on the low side. And that's just for friends who are regular PC users and not dev
types.

What are the numbers when you review Task Mgr? What is your OS BTW so I can tell you
what numbers to look at?

I think it's all gone but something is still slowing my machine down.
The mouse movement is jerky and programs such as firefox take forever
to load.
Obviously some settings were changed and are now causing problems.
Any suggestions would be welcome.
Along with installing SQL, IIS (internet information services) was
installed (or enabled)
Is this an essential windows component?

IIS is not an essential windows component and can also suck up RAM. I don't even
know why SQL Server would install it.

Also check your event log. Maybe your hard drive is dying.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
.

Relevant Pages

  • Re: SQL server express
    ... downloaded and installed SQL server express. ... Chances are you need more RAM in your computer. ... Tony Toews, Microsoft Access MVP ... Along with installing SQL, ...
    (comp.databases.ms-access)
  • 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: SQL Server Express Edition
    ... You are correct that Expresss will only use 1GB of RAM; ... Scaling Up on SQL Server especially from an Access DB will also warrant more ... Best Practices for both safety and performance. ... Perhaps I'd be better off with the Workgroup Edition. ...
    (microsoft.public.sqlserver.setup)