Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Speed up SQL server

Author  Topic 

Starting Member

4 Posts

Posted - 2012-08-03 : 05:56:16
I am a systems analyst and SQL is not "my daily bread".

A client asked me to "speed up" his PC.
Especially a small management software written in VB6, which relies on a MSDN database.
Windows XP SP3 ITA 32bit.

I increased the RAM from 1 to 4GB.
I replaced the disks with most performing.
I put a Quad Core i5 CPU 3400MHz.
The computer become fast, but the management software and remained slow.

Some time ago I read that more RAM can be assigned to the SQL server. How it works?
Is possible to load and use the entire database in RAM?
Can I shrink/optimize the database?


Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-08-03 : 06:00:52
MSDN (and SQL Express) version of SQL Server can only utilize one processor and 1 GIG RAM anyway.

N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Starting Member

4 Posts

Posted - 2012-08-03 : 09:58:50
Sorry, I trusted the information given me by customer.
It is not MSDE, but SQL Express 2005.

I move to the right place:
Go to Top of Page

- Advertisement -