multiple instances of sqlservr.exe process

I have a Windows Server 2003 with SQL server 2000
installed. Whenever I view the Task Manager/Processes I
see three entires for the sqlservr.exe process. I am
thinking this is not normal and must be causing certain
performance issues I am facing. Whenever the server has
been up for a few hours the server starts getting slower.
If I reboot the server everything stays fine for a few
hours but then it starts slowing down. I have 2GB of RAM
on the server, about 20 Gigs free space on the C: drive
and about 120 Gigs free space on the data drive. All the
database files are stored on the data drive. Any help or
pointers in the right direction would be greatly
appreciated.
LakshmanHow many services whose name starts "MSSQL" do you see when you look in
Services ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lakshman" <hlokku@.hotmail.com> wrote in message
news:2a3801c3fc98$efbaef60$a301280a@.phx.gbl...
> I have a Windows Server 2003 with SQL server 2000
> installed. Whenever I view the Task Manager/Processes I
> see three entires for the sqlservr.exe process. I am
> thinking this is not normal and must be causing certain
> performance issues I am facing. Whenever the server has
> been up for a few hours the server starts getting slower.
> If I reboot the server everything stays fine for a few
> hours but then it starts slowing down. I have 2GB of RAM
> on the server, about 20 Gigs free space on the C: drive
> and about 120 Gigs free space on the data drive. All the
> database files are stored on the data drive. Any help or
> pointers in the right direction would be greatly
> appreciated.
> Lakshman|||Hello Lakshman,
Please monitor the following.
Memory\Available Bytes (Threshold<4MB)
Memory\Pages/sec (Threshold>20)
PageFile\ % Usage (Threshold>70%)
Physical Disk\Avg. Disk Queue Length ( Threshold: > 1.5 x # of spindles )
Physical Disk\% Disk Time (Threshold: >90% )
SQLServer:Memory Manager/Total Server Memory (per instance)
Also make sure your patch level is up to date on the SQL server and the OS.
Did you install any extended stored procs?
"Lakshman" <hlokku@.hotmail.com> wrote in message
news:2a3801c3fc98$efbaef60$a301280a@.phx.gbl...
> I have a Windows Server 2003 with SQL server 2000
> installed. Whenever I view the Task Manager/Processes I
> see three entires for the sqlservr.exe process. I am
> thinking this is not normal and must be causing certain
> performance issues I am facing. Whenever the server has
> been up for a few hours the server starts getting slower.
> If I reboot the server everything stays fine for a few
> hours but then it starts slowing down. I have 2GB of RAM
> on the server, about 20 Gigs free space on the C: drive
> and about 120 Gigs free space on the data drive. All the
> database files are stored on the data drive. Any help or
> pointers in the right direction would be greatly
> appreciated.
> Lakshman|||I do not see any processes with "MSSQL" but there are 2
processes that say "sqlmangr.exe"
Lakshman.
>--Original Message--
>How many services whose name starts "MSSQL" do you see
when you look in
>Services ?
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Lakshman" <hlokku@.hotmail.com> wrote in message
>news:2a3801c3fc98$efbaef60$a301280a@.phx.gbl...
>> I have a Windows Server 2003 with SQL server 2000
>> installed. Whenever I view the Task Manager/Processes I
>> see three entires for the sqlservr.exe process. I am
>> thinking this is not normal and must be causing certain
>> performance issues I am facing. Whenever the server has
>> been up for a few hours the server starts getting
slower.
>> If I reboot the server everything stays fine for a few
>> hours but then it starts slowing down. I have 2GB of RAM
>> on the server, about 20 Gigs free space on the C: drive
>> and about 120 Gigs free space on the data drive. All the
>> database files are stored on the data drive. Any help or
>> pointers in the right direction would be greatly
>> appreciated.
>> Lakshman
>
>.
>|||He was referring to Services:
Start -> Settings -> Control Panel -> Administrative Tools -> Services
<anonymous@.discussions.microsoft.com> wrote in message
news:294a01c3fca6$83b713d0$a501280a@.phx.gbl...
> I do not see any processes with "MSSQL" but there are 2
> processes that say "sqlmangr.exe"
> Lakshman.
> >--Original Message--
> >How many services whose name starts "MSSQL" do you see
> when you look in
> >Services ?
> >
> >--
> >HTH
> >
> >Jasper Smith (SQL Server MVP)
> >
> >I support PASS - the definitive, global
> >community for SQL Server professionals -
> >http://www.sqlpass.org
> >
> >
> >"Lakshman" <hlokku@.hotmail.com> wrote in message
> >news:2a3801c3fc98$efbaef60$a301280a@.phx.gbl...
> >> I have a Windows Server 2003 with SQL server 2000
> >> installed. Whenever I view the Task Manager/Processes I
> >> see three entires for the sqlservr.exe process. I am
> >> thinking this is not normal and must be causing certain
> >> performance issues I am facing. Whenever the server has
> >> been up for a few hours the server starts getting
> slower.
> >> If I reboot the server everything stays fine for a few
> >> hours but then it starts slowing down. I have 2GB of RAM
> >> on the server, about 20 Gigs free space on the C: drive
> >> and about 120 Gigs free space on the data drive. All the
> >> database files are stored on the data drive. Any help or
> >> pointers in the right direction would be greatly
> >> appreciated.
> >> Lakshman
> >
> >
> >.
> >|||If you have multiple sqlservr.exe process showing up then you have multiple
instances of SQL Server running on this server. There are a multitude of
applications that install a copy of MSDE 2000 and use it as a data store.
If you did not purposely install the instances of SQL Server then more than
like other applications did. BackUp Exec uses MSDE, so if you have it
installed on this server that would explain one of the instances.
As Adam said, check:
Start -> Settings -> Control Panel -> Administrative Tools -> Services
You should see multiple services that start with MSSQL.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Multiple Instances of SQL Server Service Manager

- I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
2003 (Standard, v5.2) server operating in terminal services mode. The SQL
Server Service Manager is in the startup folder for all users, so multiple
instances are running when more than one user is logged in.
- I am having some problems with this server, so I'm trying to stop anything
that doesn't need to run.
- Can I delete the SQL Server Service Manager from the all users startup
folder? (I would start Service Manager when the Administrator logs in.)
- Thanks.
Hi
SQL Server Service Manager is not required for SQL Server operation. You can
remove it from the startup folder.
You can still manage SQL Server though Enterprise Manager and Control Panel
> Services.
Any reason you have a server that SQL Server needs to share with Terminal
Server users? It is not an optimal configuration.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" wrote:

> - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> Server Service Manager is in the startup folder for all users, so multiple
> instances are running when more than one user is logged in.
> - I am having some problems with this server, so I'm trying to stop anything
> that doesn't need to run.
> - Can I delete the SQL Server Service Manager from the all users startup
> folder? (I would start Service Manager when the Administrator logs in.)
> - Thanks.
|||Mike,
- Thanks for the info.
- Re your question, I am running Act2005 (which uses SQL2000) for a company
that offices virtually. We setup this server in a hosted datacenter, and
loaded all of our apps (Act, MSOffice, a cpl others) and access everything
using terminal services on the server and remote desktop connection on the
client PCs.
- This configuration generally works, although there are some bugs which I
attribute to the poor job done by my IT provider, and the fact that Act2005
is not designed for terminal services. My only big problem is that Act
occasionally starts using a lot of memory (over 1GB of VM in some cases) and
the whole server slows down.
- Thanks again for your help, and please let me know if you have any
suggestions for my configuration.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> SQL Server Service Manager is not required for SQL Server operation. You can
> remove it from the startup folder.
> You can still manage SQL Server though Enterprise Manager and Control Panel
> Any reason you have a server that SQL Server needs to share with Terminal
> Server users? It is not an optimal configuration.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Dave" wrote:
sql

Multiple Instances of SQL Server Service Manager

- I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
2003 (Standard, v5.2) server operating in terminal services mode. The SQL
Server Service Manager is in the startup folder for all users, so multiple
instances are running when more than one user is logged in.
- I am having some problems with this server, so I'm trying to stop anything
that doesn't need to run.
- Can I delete the SQL Server Service Manager from the all users startup
folder? (I would start Service Manager when the Administrator logs in.)
- Thanks.Hi
SQL Server Service Manager is not required for SQL Server operation. You can
remove it from the startup folder.
You can still manage SQL Server though Enterprise Manager and Control Panel
> Services.
Any reason you have a server that SQL Server needs to share with Terminal
Server users? It is not an optimal configuration.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" wrote:
> - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> Server Service Manager is in the startup folder for all users, so multiple
> instances are running when more than one user is logged in.
> - I am having some problems with this server, so I'm trying to stop anything
> that doesn't need to run.
> - Can I delete the SQL Server Service Manager from the all users startup
> folder? (I would start Service Manager when the Administrator logs in.)
> - Thanks.|||Mike,
- Thanks for the info.
- Re your question, I am running Act2005 (which uses SQL2000) for a company
that offices virtually. We setup this server in a hosted datacenter, and
loaded all of our apps (Act, MSOffice, a cpl others) and access everything
using terminal services on the server and remote desktop connection on the
client PCs.
- This configuration generally works, although there are some bugs which I
attribute to the poor job done by my IT provider, and the fact that Act2005
is not designed for terminal services. My only big problem is that Act
occasionally starts using a lot of memory (over 1GB of VM in some cases) and
the whole server slows down.
- Thanks again for your help, and please let me know if you have any
suggestions for my configuration.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server Service Manager is not required for SQL Server operation. You can
> remove it from the startup folder.
> You can still manage SQL Server though Enterprise Manager and Control Panel
> > Services.
> Any reason you have a server that SQL Server needs to share with Terminal
> Server users? It is not an optimal configuration.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Dave" wrote:
> > - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> > 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> > Server Service Manager is in the startup folder for all users, so multiple
> > instances are running when more than one user is logged in.
> > - I am having some problems with this server, so I'm trying to stop anything
> > that doesn't need to run.
> > - Can I delete the SQL Server Service Manager from the all users startup
> > folder? (I would start Service Manager when the Administrator logs in.)
> > - Thanks.

Multiple Instances of SQL Server Service Manager

- I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
2003 (Standard, v5.2) server operating in terminal services mode. The SQL
Server Service Manager is in the startup folder for all users, so multiple
instances are running when more than one user is logged in.
- I am having some problems with this server, so I'm trying to stop anything
that doesn't need to run.
- Can I delete the SQL Server Service Manager from the all users startup
folder? (I would start Service Manager when the Administrator logs in.)
- Thanks.Hi
SQL Server Service Manager is not required for SQL Server operation. You can
remove it from the startup folder.
You can still manage SQL Server though Enterprise Manager and Control Panel
> Services.
Any reason you have a server that SQL Server needs to share with Terminal
Server users? It is not an optimal configuration.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" wrote:

> - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> Server Service Manager is in the startup folder for all users, so multiple
> instances are running when more than one user is logged in.
> - I am having some problems with this server, so I'm trying to stop anythi
ng
> that doesn't need to run.
> - Can I delete the SQL Server Service Manager from the all users startup
> folder? (I would start Service Manager when the Administrator logs in.)
> - Thanks.|||Mike,
- Thanks for the info.
- Re your question, I am running Act2005 (which uses SQL2000) for a company
that offices virtually. We setup this server in a hosted datacenter, and
loaded all of our apps (Act, MSOffice, a cpl others) and access everything
using terminal services on the server and remote desktop connection on the
client PCs.
- This configuration generally works, although there are some bugs which I
attribute to the poor job done by my IT provider, and the fact that Act2005
is not designed for terminal services. My only big problem is that Act
occasionally starts using a lot of memory (over 1GB of VM in some cases) and
the whole server slows down.
- Thanks again for your help, and please let me know if you have any
suggestions for my configuration.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> SQL Server Service Manager is not required for SQL Server operation. You c
an
> remove it from the startup folder.
> You can still manage SQL Server though Enterprise Manager and Control Pane
l
> Any reason you have a server that SQL Server needs to share with Terminal
> Server users? It is not an optimal configuration.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Dave" wrote:
>

Multiple instances of menu items

When using SQL Server Management Studio Express I get multiples of all the standard Windows menu items as well as in the dropdowns. I have also experienced this in the Visual Basic 2005 Exprerss edition IDE. What is causing this?

Hi,

as already mentioned in the other post, make sure you are running the most recent version. If not it would be nice to procude a screenshot to share it with us, because (for me) it is hard to imagine what the actual problem looks like.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Again, thanks for the response. I just finished downloading the install files for SSMS and will reinstall this PM. I have a screenshot of the multiple menus but I am not sure how to attach the image file to this posting. If there is a way please let me know and I will send it.

Thanks again.

|||Send them over via Mail.|||Don't mean to appear stupid, but to what mail address?|||Go thorugh my profile , the fat name on the left of this post. You will see my profile, you will have to remove the REMOVE_THINGS to avoid spam.

Multiple group default database

SQL Server 2000. Windows Auth. If a Windows login is a member of multiple
local groups on the SQL Server box, and each local group maps to a SQL Serve
r
login, and the logins have different default databases, how do you determine
what default database is used for a given Windows login?
Thanks
VernVern,
There is an order. When I tested it seemed like alphabetical order, but I
did not absolutely verify it. Try assigning the first alphabetical group
for a user to default to a database where he has no rights and see if this
causes a login failure.
RLF
"Vern Rabe" <VernRabe@.discussions.microsoft.com> wrote in message
news:7C825239-6888-4DEC-BE0B-59CFB3D2764A@.microsoft.com...
> SQL Server 2000. Windows Auth. If a Windows login is a member of multiple
> local groups on the SQL Server box, and each local group maps to a SQL
> Server
> login, and the logins have different default databases, how do you
> determine
> what default database is used for a given Windows login?
> Thanks
> Vernsql

Multiple Databases?

I have a server running windows 2000 which I am using as my WSUS server
running a MSDE 2000 DB. I would also like to use this server as my Antivirus
server (Mcafee Protection Pilot). To so this I need to create another MSDE
2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
server? We are primarily a small organization with around 250 users.
Thanks
We got a similiar solution here. We have WSUS and Trendmicro on one Server.
Both share one MSDE. Overall size is below 500MBytes. Sometimes the WSUS-gui
is quite slow and the eventlog complains that the maximum number of
connections was exceeded. Besides that, it works quite well.
"aredneck" wrote:

> I have a server running windows 2000 which I am using as my WSUS server
> running a MSDE 2000 DB. I would also like to use this server as my Antivirus
> server (Mcafee Protection Pilot). To so this I need to create another MSDE
> 2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
> server? We are primarily a small organization with around 250 users.
> Thanks
|||If you run the MSDE install, you can create another instance of MSDE on the
same server. This might be a better solution than what you resorted to.
Andre Weidner wrote:[vbcol=seagreen]
>We got a similiar solution here. We have WSUS and Trendmicro on one Server.
>Both share one MSDE. Overall size is below 500MBytes. Sometimes the WSUS-gui
>is quite slow and the eventlog complains that the maximum number of
>connections was exceeded. Besides that, it works quite well.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200511/1
|||I've got a similar situation where WSUS is already installed and I'm looking
at moving my anti-virus system on to the same server.
However WSUS is running on Server 2003 and therefore in WMSDE.
I take it I can't use WMSDE for my AV solution so I'd like to know, is it
viable to simply install MSDE 2000 along side WMSDE, or will I have to move
WSUS out of WMSDE and into MSDE 2000?
I assume I'll have some conflicts at minimum with the ports clashing if the
two live together, and there are likely to be other major problems.
Any suggestions?
"aredneck" wrote:

> I have a server running windows 2000 which I am using as my WSUS server
> running a MSDE 2000 DB. I would also like to use this server as my Antivirus
> server (Mcafee Protection Pilot). To so this I need to create another MSDE
> 2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
> server? We are primarily a small organization with around 250 users.
> Thanks