Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Multi-task

Multi-task

Scheduled Pinned Locked Moved The Lounge
databaseperformance
27 Posts 10 Posters 7 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Corporal Agarn

    I love the way computers multi-task. As long as you do one thing at a time.:mad: Running a database restore that is tying up the computer. CPU 3%, system has 8G memory, maximum ever used 6.3G, maxed out. I even had trouble trying to write this.

    B Offline
    B Offline
    Brisingr Aerowing
    wrote on last edited by
    #2

    What database? SQL Server? MySQL? Oracle?

    Gryphons Are Awesome! ‮Gryphons Are Awesome!‬

    C 1 Reply Last reply
    0
    • B Brisingr Aerowing

      What database? SQL Server? MySQL? Oracle?

      Gryphons Are Awesome! ‮Gryphons Are Awesome!‬

      C Offline
      C Offline
      Corporal Agarn
      wrote on last edited by
      #3

      Being a DBA I have a copy of SQL Server on my desktop. Not the ideal place for a database server. I have SQL memory set to 4G max but something tells me it takes a bit more.

      R 1 Reply Last reply
      0
      • C Corporal Agarn

        Being a DBA I have a copy of SQL Server on my desktop. Not the ideal place for a database server. I have SQL memory set to 4G max but something tells me it takes a bit more.

        R Offline
        R Offline
        Rutvik Dave
        wrote on last edited by
        #4

        It's not the RAM utilization slowing down your computer, it's the IO operations causing the slowdown. Even your boot will be very slow if you have SQL Server or any other database engine installed.

        Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

        E C 2 Replies Last reply
        0
        • C Corporal Agarn

          I love the way computers multi-task. As long as you do one thing at a time.:mad: Running a database restore that is tying up the computer. CPU 3%, system has 8G memory, maximum ever used 6.3G, maxed out. I even had trouble trying to write this.

          A Offline
          A Offline
          Amar Chaudhary
          wrote on last edited by
          #5

          When this happens to me I try to remove suspected process's affinity from processor one and two, and set the affinity to the applications I am using to just 1 and 2... Regards Amar

          My Startup!!!!
          Profile@Elance - feedback available too

          1 Reply Last reply
          0
          • R Rutvik Dave

            It's not the RAM utilization slowing down your computer, it's the IO operations causing the slowdown. Even your boot will be very slow if you have SQL Server or any other database engine installed.

            Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

            E Offline
            E Offline
            Espen Harlinn
            wrote on last edited by
            #6

            Guess what happens when you run Oracle, SQL Server, Interbase & Blackfish on your laptop ...

            Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

            M R C 3 Replies Last reply
            0
            • C Corporal Agarn

              I love the way computers multi-task. As long as you do one thing at a time.:mad: Running a database restore that is tying up the computer. CPU 3%, system has 8G memory, maximum ever used 6.3G, maxed out. I even had trouble trying to write this.

              J Offline
              J Offline
              jim lahey
              wrote on last edited by
              #7

              It's the only way: http://cache.ohinternet.com/images/e/e9/Advice_dog_system_32.jpg[^]

              C 1 Reply Last reply
              0
              • R Rutvik Dave

                It's not the RAM utilization slowing down your computer, it's the IO operations causing the slowdown. Even your boot will be very slow if you have SQL Server or any other database engine installed.

                Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                C Offline
                C Offline
                Corporal Agarn
                wrote on last edited by
                #8

                I know, but I still complain.

                1 Reply Last reply
                0
                • J jim lahey

                  It's the only way: http://cache.ohinternet.com/images/e/e9/Advice_dog_system_32.jpg[^]

                  C Offline
                  C Offline
                  Corporal Agarn
                  wrote on last edited by
                  #9

                  System 32 is over rated. :)

                  1 Reply Last reply
                  0
                  • E Espen Harlinn

                    Guess what happens when you run Oracle, SQL Server, Interbase & Blackfish on your laptop ...

                    Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                    M Offline
                    M Offline
                    Matthew Faithfull
                    wrote on last edited by
                    #10

                    Very very little at all? :-D

                    "The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)

                    E 1 Reply Last reply
                    0
                    • M Matthew Faithfull

                      Very very little at all? :-D

                      "The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)

                      E Offline
                      E Offline
                      Espen Harlinn
                      wrote on last edited by
                      #11

                      Matthew Faithfull wrote:

                      Very very little at all?

                      Yes, you do get time a cup, or two, of your favourite beverage in the morning ...

                      Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                      1 Reply Last reply
                      0
                      • E Espen Harlinn

                        Guess what happens when you run Oracle, SQL Server, Interbase & Blackfish on your laptop ...

                        Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                        R Offline
                        R Offline
                        Rutvik Dave
                        wrote on last edited by
                        #12

                        then you can hear your HDD scream while your CPU sit back and relax at 15% :-D

                        Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                        E 1 Reply Last reply
                        0
                        • R Rutvik Dave

                          then you can hear your HDD scream while your CPU sit back and relax at 15% :-D

                          Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                          E Offline
                          E Offline
                          Espen Harlinn
                          wrote on last edited by
                          #13

                          Not sure - it takes 15-20 minutes before the logon completes ... hopefully this will work way better on my new machine - which I hope I will actually start using one of these days ;)

                          Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                          R 1 Reply Last reply
                          0
                          • E Espen Harlinn

                            Not sure - it takes 15-20 minutes before the logon completes ... hopefully this will work way better on my new machine - which I hope I will actually start using one of these days ;)

                            Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                            R Offline
                            R Offline
                            Rutvik Dave
                            wrote on last edited by
                            #14

                            What!!!? You actually have all of these installed on your laptop? I thought you are pointing out a possible scenario. :) Don't you have an older desktop/laptop laying around? You have way too much patience... you must be writing some quality code :)

                            Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                            E 1 Reply Last reply
                            0
                            • R Rutvik Dave

                              What!!!? You actually have all of these installed on your laptop? I thought you are pointing out a possible scenario. :) Don't you have an older desktop/laptop laying around? You have way too much patience... you must be writing some quality code :)

                              Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                              E Offline
                              E Offline
                              Espen Harlinn
                              wrote on last edited by
                              #15

                              Rutvik Dave wrote:

                              You actually have all of these installed on your laptop?

                              I do ... which is why I have some hope for my new laptop, a thorougly uppgraded HP 8570w The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                              Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                              R 1 Reply Last reply
                              0
                              • E Espen Harlinn

                                Rutvik Dave wrote:

                                You actually have all of these installed on your laptop?

                                I do ... which is why I have some hope for my new laptop, a thorougly uppgraded HP 8570w The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                                Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                R Offline
                                R Offline
                                Rutvik Dave
                                wrote on last edited by
                                #16

                                Espen Harlinn wrote:

                                The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                                Interesting... I don't know what is you requirement regarding mobility, but I would let everything installed on the older/existing laptop and install the client software on the new shiny HP 8570w and then connect to the older laptop The Database Server (which I would never turn off). :)

                                Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                                E 1 Reply Last reply
                                0
                                • E Espen Harlinn

                                  Guess what happens when you run Oracle, SQL Server, Interbase & Blackfish on your laptop ...

                                  Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                  C Offline
                                  C Offline
                                  Chris Maunder
                                  wrote on last edited by
                                  #17

                                  Remember: don't cross the streams!

                                  cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

                                  E 1 Reply Last reply
                                  0
                                  • R Rutvik Dave

                                    Espen Harlinn wrote:

                                    The odd thing is that, once everything is up and running, I can actually get pretty decent performance out of the database servers ...

                                    Interesting... I don't know what is you requirement regarding mobility, but I would let everything installed on the older/existing laptop and install the client software on the new shiny HP 8570w and then connect to the older laptop The Database Server (which I would never turn off). :)

                                    Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

                                    E Offline
                                    E Offline
                                    Espen Harlinn
                                    wrote on last edited by
                                    #18

                                    Rutvik Dave wrote:

                                    requirement regarding mobility

                                    I tend to do a wee bit of work outside regular hours - so I bring the development box with me when I leave the office. Work supplies me with the laptop, at home I'm somewhat better equipped ...

                                    Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                    N 1 Reply Last reply
                                    0
                                    • C Chris Maunder

                                      Remember: don't cross the streams!

                                      cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

                                      E Offline
                                      E Offline
                                      Espen Harlinn
                                      wrote on last edited by
                                      #19

                                      The caffeine also helps to boot up 'Ze Little Grey Cells' for the day ... I've never been a great fan of mornings ...

                                      Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                      1 Reply Last reply
                                      0
                                      • E Espen Harlinn

                                        Rutvik Dave wrote:

                                        requirement regarding mobility

                                        I tend to do a wee bit of work outside regular hours - so I bring the development box with me when I leave the office. Work supplies me with the laptop, at home I'm somewhat better equipped ...

                                        Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                        N Offline
                                        N Offline
                                        Nicholas Marty
                                        wrote on last edited by
                                        #20

                                        Do you need all those engines at startup or only on demand? Maybe just disabling the automatic start of all those greedy databases might improve your boot time? :)

                                        E 1 Reply Last reply
                                        0
                                        • N Nicholas Marty

                                          Do you need all those engines at startup or only on demand? Maybe just disabling the automatic start of all those greedy databases might improve your boot time? :)

                                          E Offline
                                          E Offline
                                          Espen Harlinn
                                          wrote on last edited by
                                          #21

                                          Did that for a while, but lately I need both when I start working - disabling Oracle helped a bit, cutting about 5 minutes of the time required to boot, disabling MS SQL Server didn't make much of a difference. Disabling FSecure made a lot of difference ... but then we're not supposed to do that, so I turned it back on. So FSecure is probably the real culprit, but it behaved well enough before I installed the servers.

                                          Espen Harlinn Principal Architect, Software - Goodtech Projects & Services AS Projects promoting programming in "natural language" are intrinsically doomed to fail. Edsger W.Dijkstra

                                          N A 2 Replies Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups