The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    sqlservr.exe?

    Discussion in 'Windows OS and Software' started by CalebSchmerge, Mar 22, 2007.

  1. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    I have tried googling this before, and I can't really figure out what it is. But, I am really curious what it is, why its always running, and why it is using almost 100 MB of RAM. I have plenty of ram, but I am annoyed with my really long hibernate times, and if this can go, that would shave a lot of time off. Any information for me?
     
  2. Budding

    Budding Notebook Virtuoso

    Reputations:
    1,686
    Messages:
    3,982
    Likes Received:
    0
    Trophy Points:
    105
    It's a SQL server execution file. If you don't want it, disable MySQL, IIS or something web server related from services.
     
  3. Pitabred

    Pitabred Linux geek con rat flail!

    Reputations:
    3,300
    Messages:
    7,115
    Likes Received:
    3
    Trophy Points:
    206
    It's probably MSSQL, as that's not the process name of MySQL (which is mysqld.exe if you cared)

    Do you have any programs installed that use an SQL server? Anything custom or non-standard? Games, services, anything?
     
  4. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    Funny story, I looked and I apparently have Microsoft SQL Server 2005 installed. No idea where I got that or why. But, I figure out disabling it. It went from almost 100 MB of RAM to a few K of RAM used. Between that and one other change I made, my hibernate time is down drastically.
     
  5. sylonien

    sylonien Notebook Evangelist

    Reputations:
    32
    Messages:
    446
    Likes Received:
    0
    Trophy Points:
    30
    I've got Microsoft SQL Server 2005 preinstalled with computer? Do I need?? I wanna get rid of it but scared it might mess up the OS or something like that cause it came with it.
     
  6. Budding

    Budding Notebook Virtuoso

    Reputations:
    1,686
    Messages:
    3,982
    Likes Received:
    0
    Trophy Points:
    105
    You won't need the server unless you plan on doing some dynamic web development or database management on your computer.
     
  7. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    Thanks for the info.
     
  8. RedSensiStar

    RedSensiStar Notebook Deity

    Reputations:
    178
    Messages:
    897
    Likes Received:
    0
    Trophy Points:
    0
    Yeah good to know you figured out why it was 100mb.

    I just checked mine and it's running at 6700K
     
  9. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    Hmm...mine jumped back to 90 MB. Time to permanently kill that sucker.
     
  10. RedSensiStar

    RedSensiStar Notebook Deity

    Reputations:
    178
    Messages:
    897
    Likes Received:
    0
    Trophy Points:
    0
    One time I deleted it entirely from my XPS.

    Nothing happened.

    The next day XP would not even function.

    It was the only change I could think of that could have caused it...

    I dunno...I'm scared to mess with SQL.exe now.
     
  11. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    I'm just annoyed by the damn thing. It is eating up a lot of memory that I don't want it to, because I want to hibernate faster.
     
  12. RedSensiStar

    RedSensiStar Notebook Deity

    Reputations:
    178
    Messages:
    897
    Likes Received:
    0
    Trophy Points:
    0
    Hibernation sucks up HD space sir!

    Which is more important?! RAM OR HD?!

    I say HD!

    =P But I have a lot of RAM on my machine's so I dunno.

    Tomorrow I have to bring my startup processes on my Thinkpad (68) to as low as possible...Doesn't that sound like fun?
     
  13. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    I can afford to leave 2 GBs free for hibernation, I have tons of hard drive space. I prefer to have the speed of hibernation.
     
  14. Gator

    Gator Go Gators!

    Reputations:
    890
    Messages:
    1,889
    Likes Received:
    0
    Trophy Points:
    55
    I asked a question earlier on these forums about the addresses of the contents of RAM, basically how the OS keeps track of which address gets what byte when you copy it back from the HDD. The reason is, I've heard of programs that become non-responsive or crash all together coming back from Hibernation, and I think it's because of the way the copying works. I believe not only is copying the exactly 2GB (or whatever amount of mem) back necessary, it is also necessary to copy them to the exact physical addresses.

    Any thoughts?

    P.S. Oh sorry didn't address sqlserv; yeah I've heard of them getting slipstreamed into Vista and the occasional XP install, sometimes from universities. Feel free to get rid of it, though it's handy for programming projects like games or the like. MySQL works just as well.
     
  15. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    I set it to manual mode, so I will monitor it, and if it comes back on, its getting the disabled treatment. We will see what happens with that..
     
  16. Pitabred

    Pitabred Linux geek con rat flail!

    Reputations:
    3,300
    Messages:
    7,115
    Likes Received:
    3
    Trophy Points:
    206
    Jeez... you Windows people sure are superstitious, aren't you?

    SQL.exe isn't needed for ANY essential Windows services or anything. It MAY be needed for some other program that you've installed on your machine. Feel free to uninstall it completely, rather than just disabling the service, but first test out ALL your programs while the service is disabled, especially the ones you absolutely cannot live without.
     
  17. CalebSchmerge

    CalebSchmerge Woof NBR Reviewer

    Reputations:
    1,126
    Messages:
    2,395
    Likes Received:
    2
    Trophy Points:
    55
    I just wanted to make sure I wasn't destroying a service I need. This is part of why I like linux, and keep trying to use it permanently.
     
  18. starling

    starling Notebook Consultant

    Reputations:
    12
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    30
    Don't set it to manual mode, set it as disabled. Unless you are using an MS SQL server database on your computer for web development (or for any Windows software you develop yourself), you don't need it for anything. There is no common open source or commercial software that requires an SQL server database on your computer that I know of. If so, you should use some other software. When it's installed, it gets installed as a "service" which starts up automatically after booting. No point having it run if you don't need it. You can even uninstall it completely and it won't affect a thing. Did you happen to install a Visual Studio Express edition? MS SQL Server gets installed as an option with those.
     
  19. Gator

    Gator Go Gators!

    Reputations:
    890
    Messages:
    1,889
    Likes Received:
    0
    Trophy Points:
    55
    Ah Rat Flail, the Japanese comic that keeps on giving...

    I hope it's properly translated, I don't know any Japanese and they tell me a lot of the language gets censored or altered in the translation.
     
  20. sylonien

    sylonien Notebook Evangelist

    Reputations:
    32
    Messages:
    446
    Likes Received:
    0
    Trophy Points:
    30
    Are you sure I can uninstall it? What does this mean?
     

    Attached Files:

    • sql.jpg
      sql.jpg
      File size:
      131.6 KB
      Views:
      144
  21. starling

    starling Notebook Consultant

    Reputations:
    12
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    30
    I am absolutely sure that you can uninstall MS SQL server any time you want to if you don't use it for anything. It's not an integral part of the operating system. Personally, I would just disable it. On the very odd chance that you have some software that queries an SQL database, you will know when you need to enable it.
     
  22. Pitabred

    Pitabred Linux geek con rat flail!

    Reputations:
    3,300
    Messages:
    7,115
    Likes Received:
    3
    Trophy Points:
    206
    ...what Japanese comic? The guy's an anime fan, but given that his name is "Scott", I really doubt that he's Japanese.

    www.vgcats.com is where I got it from... no translation needed ;)
     
  23. Gator

    Gator Go Gators!

    Reputations:
    890
    Messages:
    1,889
    Likes Received:
    0
    Trophy Points:
    55
    Ah well...must be the drawing style then.

    My new favorite, Halo2:

    [​IMG]