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

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

Hi

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

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

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?

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.

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

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.

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.

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
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

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