SQL Server Performance

MULTIPLE sqlservr.exe in Taskmanager

Discussion in 'Performance Tuning for Hardware Configurations' started by HHAAPPYY, Jan 5, 2005.

  1. HHAAPPYY New Member

    Hi
    I am new to databases, can any body tell how many insatance of sqlservr.exe in the taskmanger are possible? And what can cause the multiple insatance ? on the sql2000.

    I am finding this on the machine WITH CONFG. intel(r) Xenon (TM) cpu 2.8 Ghz 2.0 Ghz and 2.00 Gb RAM with OS Windows Server 2003.

    thanks in advance


    ALWAYS HAPPYNESS

    HHAAPPYY
  2. Luis Martin Moderator

    The only way to find more than one instance in SQL server is because someone install it.
    To be sure, you can run from command prompt: osql -L. This command show you all instances in the net.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  3. HHAAPPYY New Member

    Thanks Luis


    there is only one that is local.


  4. HHAAPPYY New Member

    Also ,in the Task Manager I have noticed the following:

    Process Mem Size VM Size User Name
    Sqlservr.exe 1,184,236 K1,226,244 K SYSTEM
    Sqlservr.exe 1464 K 269 K SYSTEM

  5. Luis Martin Moderator

    Ok, so you only have one instance.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  6. HHAAPPYY New Member

    Hi

    Is there any relation of sqlservr.exe with dllhost.exe or with IIS ? if any then please let me know.......

  7. Luis Martin Moderator

    dllhost.exe is a part of the Microsoft Windows Operating System. The dllhost.exe file manages DLL based applications. This program is important for the stable and secure running of your computer and should not be terminated.

    About IIS check:http://www.microsoft.com/iis



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  8. HHAAPPYY New Member

    Thanks for this information.in my application too the com+ components are in the form of dll and intraction of application request is through dlls only,thats why i intrested to know whether if there is any relation of dll with sqlservr.exe?

    Because in other application I saw multiple dllhost.exe corrosponds to the same application. but here it is different.
    So just want to know if any body know about it.
    Also IIS hold the com+ components .........
    that might be playing soem role into it........
    very courious to know about it?


    ALways Happyness
    HHAAPPYY
  9. satya Moderator

    KBAhttp://support.microsoft.com/kb/q198891/ for information on COM object execution.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  10. HHAAPPYY New Member

    Thanks Satya
    But mine main problem is the ever growing size of sqlservr.exe,and then an other instance of the sqlservr.exe. What can be the cause which prompt a new sqlservr.exe?
    Ant idea about it?



  11. satya Moderator

    THen capture the PERFMON counters for pROCESS and also Processor, physical disk, memory and SQL server memory counters for better assessment.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  12. mmarovic Active Member

    quote:But mine main problem is the ever growing size of sqlservr.exe,and then an other instance of the sqlservr.exe.
    You mean growing memory usage, right? This is normal behavior, sql server is taking more and more memory, the most of it is used for data cache.
    quote:What can be the cause which prompt a new sqlservr.exe?
    Ant idea about it?
    I have no idea.
  13. HHAAPPYY New Member

    Thanks Satya and Mmarovic for your intrest in this problem.

    I am new to database can you please specify the counter for which I should go?
    and
    To analyze these need your tips also.

  14. Luis Martin Moderator

    Using Performance Monitor:

    Physical disk: Avg. Queue Lengh (should be <= 2 )
    Memory : Pages/Sec (should be <= 20)
    SQL Memory Manager: Target SQL Memory and SQL Memory.
    SQL Buffer Manager: Cache hit ratio.

    Also take a look Brad's article about it.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  15. HHAAPPYY New Member

    Hi Luis

    I find the following data fort he diffrent counters
    Physical disk: Avg. Queue Lengh (should be <= 2 )=max value for this is 0.03
    Memory : Pages/Sec (should be <= 20) =max value for this is 4
    SQL Memory Manager: Target SQL Memory and =max value for this is 1093520 and last use
    1087504 min 1085856
    : Total SQL Memory. =max value for this is 1011488 and last use
    1011488 min 1011488
    SQL Buffer Manager: Cache hit ratio. =max value for this is 99880 and last use
    99880 min 99679
    Can you please let me know what exactly this signifies......
    sorry for asking basic question
  16. Luis Martin Moderator

    Basically you have not hardware issue at all.

    So if you fill lack of performance, run Profiler to capture Queries and SP with long duration to try to find new indexs in order increase performance.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  17. HHAAPPYY New Member

    Thanks Luis
    For your information ,
    Basically i awas trying to control the probem of multiple dllhost.exe in the task manager due to the application , that is controled but at the cost od new multiple sqlservr.exe.

    Otherwise i am working on the Process Info in the Enterprise Manager.There I found a few process of the application are under the status of sleeping.

    Do this going to make any impact on it ?

    I am also going to use profiler as adviced by you.




  18. Luis Martin Moderator

    I think no, same times when a user is thinking when the application is open, you can see that message.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  19. derrickleggett New Member

    You said there is only one that is (local). [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] Did anything else show up at all? Go to Control Panel/Administrative Tools/Services and see how many services start with MSSQL. Tell us how many and what the full name of each is.<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
  20. satya Moderator

    ... and with this behaviour are you having any performance issues with the SQL Server?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  21. HHAAPPYY New Member

    Hi Derrickleqqett & Satya


    I NOTICED THE FOLLOWING INFORMATION FORM THE SERVICES

    MSSQLSERVER ...............STARTED
    MSSQL$SBSMONITORING.........----
    MSSQL$ SHAREPOINT .........STARTED
    MSSQLSERVERADHELPER ........----

    SATYA
    NOT PARTICULARLY WITH THIS BEFORE THAT THE APPLICATION SLOW DOWN WHILE LOT OF REPORTS ARE GENERATED. I AM TRYING TO ANALYSE WHAT CAN BE THE CAUSE.. AS OTHER WISE ALL COM+1.5 COMPONENTS ARE RESPONDING FINE ,THERE IS NO ISUE WITH THOSE.

    BUT DATABASE DESIGN IS NOT GOOD. AS IT WAS MIGRATED FROM UNIX SYSTEM TO MICROSOFT.......

    ALWAYS HAPPYNESS
    HHAAPPYY

  22. derrickleggett New Member

    The top 3 are all SQL Server installations. The two that are started are causing sqlsrvr.exe to show up twice in your Processes window. SHAREPOINT by default installs an MSDE instance of SQL Server. If you aren't using sharepoint, you should disable this Service. There could be memory and processor conflicts with this setup if you haven't set them up correctly.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  23. HHAAPPYY New Member

    sharepoint is used , i think there is no probs with set up .it is ok.
  24. satya Moderator

    If you're getting slow performance during reporting then use PROFILER to findout the slow running queries and deploy proper index strategy which will help reducing stress on CPU and disk.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page