Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
acik
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?Thanks |
|
|
SwePeso
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" |
 |
|
|
acik
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:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=177477 |
|
|
|
|
|
|
Speed up SQL server