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.
  • 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
                                        • E Espen Harlinn

                                          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 Offline
                                          N Offline
                                          Nicholas Marty
                                          wrote on last edited by
                                          #22

                                          Or then just delay the automatic start of the services until you're logged in (e.g. write a short batch script and move it in the autorun folder ;P) so you can in the meantime start more (or less) important things like codeproject (most important ;)) or checking the mailbox Otherwise: Set up WOL an boot the computer from your mobile phone :laugh: (tried this with my pc at home ;))

                                          E 1 Reply 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