MULTIPLE sqlservr.exe in Taskmanager | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MULTIPLE sqlservr.exe in Taskmanager

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

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.
Thanks Luis
there is only one that is local.

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
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.
Hi Is there any relation of sqlservr.exe with dllhost.exe or with IIS ? if any then please let me know…….
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.
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
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.
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?
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.
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.

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.
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.
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

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.
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.

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.
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 />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
… 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.
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
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
[email protected] When life gives you a lemon, fire the DBA.
sharepoint is used , i think there is no probs with set up .it is ok.
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.
]]>