Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2007
    Location
    Greenville, SC
    Posts
    2

    Unanswered: Will SQL Server bog down my system?

    I am new at dbforums and this is my first post.

    I have 512M RAM, run at about 1.8Ghz and have plenty of disk space, but am concerned that, if I install SQL Server, it will run as a service all the time and bog down my system. Are there any thoughts on that? I want to use it for learning.

    Are any of the other common free versions of databases better than SQL Server as far as consuming resources than SQL Server, for example the free versions of Oracle, DB2, Postgres, MySQL, or any others?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    SQL Server will eat up as many resources as it needs, so yes it will bog down your "system"

    SQL server usually runs on a box dedicated to it, then you connect to it

    I think Express may not be as bad
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I doubt it will seriously bog down his system. I doubt it will grab more resources than it needs. So when you are actively using the database it will grab resources, but when you stop using it they will be released.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    I doubt it will seriously bog down his system. I doubt it will grab more resources than it needs. So when you are actively using the database it will grab resources, but when you stop using it they will be released.

    Since when?

    Are you refering to memroy, disk space, or just cpu?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Oct 2007
    Location
    Greenville, SC
    Posts
    2

    SQL Server bogging down system

    I probably would use the Express version. But, outside of SQL Server, are there any that do not take up as much? And if they do, can they be turned off at the service level? Would any of that help?

    It's hard to believe a program not being used could not be completely turned off. That seems like a serious design flaw to me.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Unless you plan to learn with tables that are over say 10,000 rows each, I severely doubt you would notice much difference. I say install it, and if upi suspect it is bogging your server down, just switch the service to manual, and shut it down, when you don't need it.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Brett Kaiser
    Since when?

    Are you refering to memroy, disk space, or just cpu?
    Yes. .
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    That's not a yes or no question

    what's with the Pirate Ad's
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Pirate Ad's?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •