SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Speed up SQL server
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

acik
Starting Member

Italy
4 Posts

Posted - 08/03/2012 :  05:56:16  Show Profile
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?

Thanks

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 08/03/2012 :  06:00:52  Show Profile  Visit SwePeso's Homepage
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

acik
Starting Member

Italy
4 Posts

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

I move to the right place:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=177477
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000