April 17, 2011 at 6:39 pm
I was curious, would many databases on the same machine use lots of memory? I am using a Laptop with XP.
I have about 30 databases on my workstation that I use periodically for development. I notice that my system runs really slow after I start up my Sql Server Service.
The system seems to run slow as well.
Would detaching a bunch of the database speed up the machine and would it use a lot less memory?
Thanks,
Tom
April 17, 2011 at 8:04 pm
Probably not - what you really need to do on your laptop, if it is causing you issues is to set a reasonable max memory for that instance. That way, SQL Server will not take any more than what you give it.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 18, 2011 at 5:30 am
You might see a speed up in the start up process if you have fewer databases, but overall performance wouldn't be affected at all.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply