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 SQL Server

Can I install different editions of SQL Server 2000 on one server. Meaning
like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be
installed all together as different / multiple instances on a W2k Server...?
?
I know same types of database can be installed ( depending on the O.S. type
) like multiple instances of Entp Edn or multiple instances of Std Edn.
Thanks in advance.Hi,
Yes, you can do that in Windows 2000 Server. All are independant and will
use hardware resources seperately.
Thanks
Hari
SQL Server MVP
"Piku" <Piku@.discussions.microsoft.com> wrote in message
news:C78018CC-F972-49DC-9399-67E1AA52D11A@.microsoft.com...
> Can I install different editions of SQL Server 2000 on one server. Meaning
> like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be
> installed all together as different / multiple instances on a W2k
> Server...'
> I know same types of database can be installed ( depending on the O.S.
> type
> ) like multiple instances of Entp Edn or multiple instances of Std Edn.
> Thanks in advance.|||Thanks Hari appreciete it.
"Hari Prasad" wrote:

> Hi,
> Yes, you can do that in Windows 2000 Server. All are independant and will
> use hardware resources seperately.
> Thanks
> Hari
> SQL Server MVP
> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> news:C78018CC-F972-49DC-9399-67E1AA52D11A@.microsoft.com...
>
>

Multiple Instances of SQL Server

Can I install different editions of SQL Server 2000 on one server. Meaning
like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be
installed all together as different / multiple instances on a W2k Server...?
I know same types of database can be installed ( depending on the O.S. type
) like multiple instances of Entp Edn or multiple instances of Std Edn.
Thanks in advance.
Hi,
Yes, you can do that in WINDOWS 2000 Server. All are independant and will
use hardware resources seperately.
Thanks
Hari
SQL Server MVP
"Piku" <Piku@.discussions.microsoft.com> wrote in message
news:C78018CC-F972-49DC-9399-67E1AA52D11A@.microsoft.com...
> Can I install different editions of SQL Server 2000 on one server. Meaning
> like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be
> installed all together as different / multiple instances on a W2k
> Server...?
> I know same types of database can be installed ( depending on the O.S.
> type
> ) like multiple instances of Entp Edn or multiple instances of Std Edn.
> Thanks in advance.
|||Thanks Hari appreciete it.
"Hari Prasad" wrote:

> Hi,
> Yes, you can do that in WINDOWS 2000 Server. All are independant and will
> use hardware resources seperately.
> Thanks
> Hari
> SQL Server MVP
> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> news:C78018CC-F972-49DC-9399-67E1AA52D11A@.microsoft.com...
>
>
sql

Multiple Instances of SQL Server

Can I install different editions of SQL Server 2000 on one server. Meaning
like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be
installed all together as different / multiple instances on a W2k Server...'
I know same types of database can be installed ( depending on the O.S. type
) like multiple instances of Entp Edn or multiple instances of Std Edn.
Thanks in advance.Hi,
Yes, you can do that in WINDOWS 2000 Server. All are independant and will
use hardware resources seperately.
Thanks
Hari
SQL Server MVP
"Piku" <Piku@.discussions.microsoft.com> wrote in message
news:C78018CC-F972-49DC-9399-67E1AA52D11A@.microsoft.com...
> Can I install different editions of SQL Server 2000 on one server. Meaning
> like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be
> installed all together as different / multiple instances on a W2k
> Server...'
> I know same types of database can be installed ( depending on the O.S.
> type
> ) like multiple instances of Entp Edn or multiple instances of Std Edn.
> Thanks in advance.|||Thanks Hari appreciete it.
"Hari Prasad" wrote:
> Hi,
> Yes, you can do that in WINDOWS 2000 Server. All are independant and will
> use hardware resources seperately.
> Thanks
> Hari
> SQL Server MVP
> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> news:C78018CC-F972-49DC-9399-67E1AA52D11A@.microsoft.com...
> > Can I install different editions of SQL Server 2000 on one server. Meaning
> > like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be
> > installed all together as different / multiple instances on a W2k
> > Server...'
> >
> > I know same types of database can be installed ( depending on the O.S.
> > type
> > ) like multiple instances of Entp Edn or multiple instances of Std Edn.
> >
> > Thanks in advance.
>
>

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 instances

If I installl 2 standard edition SQL 2K instances on a Server with 4 G RAM.
Does it mean each instance can can use its own 2G RAM without interfering
with other instance?
Yes, each instance can use up to 2GB. In practice, you'll need to consider
memory requirements for the OS and other apps as well. Monitor and adjust
SQL Server 'max server memory' as needed to avoid excessive paging. Also,
consider your licensing mode.
Hope this helps.
Dan Guzman
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
|||"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
Yes.
David
|||Hi,
Yes, it does by itself if both are standard edition. But still I will say to
make the memory static if you have multiple instances of sql server running
in a single machine. Measure the memory requirement per instance using
perfmon during the peak usage and fix the memory required.
Thanks
Hari
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
sql

Multiple instances

If I installl 2 standard edition SQL 2K instances on a Server with 4 G RAM.
Does it mean each instance can can use its own 2G RAM without interfering
with other instance?Yes, each instance can use up to 2GB. In practice, you'll need to consider
memory requirements for the OS and other apps as well. Monitor and adjust
SQL Server 'max server memory' as needed to avoid excessive paging. Also,
consider your licensing mode.
Hope this helps.
Dan Guzman
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?|||"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
Yes.
David|||Hi,
Yes, it does by itself if both are standard edition. But still I will say to
make the memory static if you have multiple instances of sql server running
in a single machine. Measure the memory requirement per instance using
perfmon during the peak usage and fix the memory required.
Thanks
Hari
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?

Multiple instances

If I installl 2 standard edition SQL 2K instances on a Server with 4 G RAM.
Does it mean each instance can can use its own 2G RAM without interfering
with other instance?Yes, each instance can use up to 2GB. In practice, you'll need to consider
memory requirements for the OS and other apps as well. Monitor and adjust
SQL Server 'max server memory' as needed to avoid excessive paging. Also,
consider your licensing mode.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?|||"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
Yes.
David|||Hi,
Yes, it does by itself if both are standard edition. But still I will say to
make the memory static if you have multiple instances of sql server running
in a single machine. Measure the memory requirement per instance using
perfmon during the peak usage and fix the memory required.
Thanks
Hari
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?

Multiple Instance Memory Utilization

I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting
one major application database. SQL Server 2000 Standard Edition was
installed on the server, OS is Windows 2000 Server. Currently with single
instance installed, I checked the memory usage using task manager, the wholes
system can only use up to less then 2 GB of memory. The peak is less than 2
GB. The system neven utilizing more than 2 GM of memory. I am in the process
of doing server consolidation and planning to move another major application
database to this dell server. I want to utilize 4 G of memory after I
consolidate the other SQL server to the Dell Server. If I just move the
database to this dell server without creating a new instance, the most memory
we can utilize is 3GB with 3 GB switch set in boot.ini. If we create a new
instance, does that mean we can utilize the other 2 GB of Memory on the
server? Security is not a major concern when using single instance. What are
the Pros and Cons?
Thank you very much for your help.
You need Enterprise edition to use more than 2GB. Windows 2000 server does
not use the /3GB switch other than in a test scenario. Yes you can use two
instances and each can use 2GB but you have to be careful as now you can
lead to a situation where there is little left for the OS. If you are
consolidating then you should look at using Enterprise edition and Win2000
ADV Server (or Win2003) so you can use all 3GB for Sql Server and have a GB
for the OS and any other apps.
Andrew J. Kelly SQL MVP
"royHe" <royHe@.discussions.microsoft.com> wrote in message
news:8B395A5C-26F6-4E71-95B2-D9CE53E62100@.microsoft.com...
>I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting
> one major application database. SQL Server 2000 Standard Edition was
> installed on the server, OS is Windows 2000 Server. Currently with single
> instance installed, I checked the memory usage using task manager, the
> wholes
> system can only use up to less then 2 GB of memory. The peak is less than
> 2
> GB. The system neven utilizing more than 2 GM of memory. I am in the
> process
> of doing server consolidation and planning to move another major
> application
> database to this dell server. I want to utilize 4 G of memory after I
> consolidate the other SQL server to the Dell Server. If I just move the
> database to this dell server without creating a new instance, the most
> memory
> we can utilize is 3GB with 3 GB switch set in boot.ini. If we create a new
> instance, does that mean we can utilize the other 2 GB of Memory on the
> server? Security is not a major concern when using single instance. What
> are
> the Pros and Cons?
> Thank you very much for your help.
>
|||Thank you very much.
This is a dedicated SQL server. I find out in my situation the OS use very
little memory. Probably If I reserve 256M to 300M for the OS is enough.
Currently the peak for the OS Memory usage is around 250M.
"Andrew J. Kelly" wrote:

> You need Enterprise edition to use more than 2GB. Windows 2000 server does
> not use the /3GB switch other than in a test scenario. Yes you can use two
> instances and each can use 2GB but you have to be careful as now you can
> lead to a situation where there is little left for the OS. If you are
> consolidating then you should look at using Enterprise edition and Win2000
> ADV Server (or Win2003) so you can use all 3GB for Sql Server and have a GB
> for the OS and any other apps.
> --
> Andrew J. Kelly SQL MVP
>
> "royHe" <royHe@.discussions.microsoft.com> wrote in message
> news:8B395A5C-26F6-4E71-95B2-D9CE53E62100@.microsoft.com...
>
>

Multiple Instance Memory Utilization

I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting
one major application database. SQL Server 2000 Standard Edition was
installed on the server, OS is Windows 2000 Server. Currently with single
instance installed, I checked the memory usage using task manager, the wholes
system can only use up to less then 2 GB of memory. The peak is less than 2
GB. The system neven utilizing more than 2 GM of memory. I am in the process
of doing server consolidation and planning to move another major application
database to this dell server. I want to utilize 4 G of memory after I
consolidate the other SQL server to the Dell Server. If I just move the
database to this dell server without creating a new instance, the most memory
we can utilize is 3GB with 3 GB switch set in boot.ini. If we create a new
instance, does that mean we can utilize the other 2 GB of Memory on the
server? Security is not a major concern when using single instance. What are
the Pros and Cons?
Thank you very much for your help.You need Enterprise edition to use more than 2GB. Windows 2000 server does
not use the /3GB switch other than in a test scenario. Yes you can use two
instances and each can use 2GB but you have to be careful as now you can
lead to a situation where there is little left for the OS. If you are
consolidating then you should look at using Enterprise edition and Win2000
ADV Server (or Win2003) so you can use all 3GB for Sql Server and have a GB
for the OS and any other apps.
--
Andrew J. Kelly SQL MVP
"royHe" <royHe@.discussions.microsoft.com> wrote in message
news:8B395A5C-26F6-4E71-95B2-D9CE53E62100@.microsoft.com...
>I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting
> one major application database. SQL Server 2000 Standard Edition was
> installed on the server, OS is Windows 2000 Server. Currently with single
> instance installed, I checked the memory usage using task manager, the
> wholes
> system can only use up to less then 2 GB of memory. The peak is less than
> 2
> GB. The system neven utilizing more than 2 GM of memory. I am in the
> process
> of doing server consolidation and planning to move another major
> application
> database to this dell server. I want to utilize 4 G of memory after I
> consolidate the other SQL server to the Dell Server. If I just move the
> database to this dell server without creating a new instance, the most
> memory
> we can utilize is 3GB with 3 GB switch set in boot.ini. If we create a new
> instance, does that mean we can utilize the other 2 GB of Memory on the
> server? Security is not a major concern when using single instance. What
> are
> the Pros and Cons?
> Thank you very much for your help.
>|||Thank you very much.
This is a dedicated SQL server. I find out in my situation the OS use very
little memory. Probably If I reserve 256M to 300M for the OS is enough.
Currently the peak for the OS Memory usage is around 250M.
"Andrew J. Kelly" wrote:
> You need Enterprise edition to use more than 2GB. Windows 2000 server does
> not use the /3GB switch other than in a test scenario. Yes you can use two
> instances and each can use 2GB but you have to be careful as now you can
> lead to a situation where there is little left for the OS. If you are
> consolidating then you should look at using Enterprise edition and Win2000
> ADV Server (or Win2003) so you can use all 3GB for Sql Server and have a GB
> for the OS and any other apps.
> --
> Andrew J. Kelly SQL MVP
>
> "royHe" <royHe@.discussions.microsoft.com> wrote in message
> news:8B395A5C-26F6-4E71-95B2-D9CE53E62100@.microsoft.com...
> >I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting
> > one major application database. SQL Server 2000 Standard Edition was
> > installed on the server, OS is Windows 2000 Server. Currently with single
> > instance installed, I checked the memory usage using task manager, the
> > wholes
> > system can only use up to less then 2 GB of memory. The peak is less than
> > 2
> > GB. The system neven utilizing more than 2 GM of memory. I am in the
> > process
> > of doing server consolidation and planning to move another major
> > application
> > database to this dell server. I want to utilize 4 G of memory after I
> > consolidate the other SQL server to the Dell Server. If I just move the
> > database to this dell server without creating a new instance, the most
> > memory
> > we can utilize is 3GB with 3 GB switch set in boot.ini. If we create a new
> > instance, does that mean we can utilize the other 2 GB of Memory on the
> > server? Security is not a major concern when using single instance. What
> > are
> > the Pros and Cons?
> >
> > Thank you very much for your help.
> >
> >
>
>

Multiple Instance Memory Utilization

I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting
one major application database. SQL Server 2000 Standard Edition was
installed on the server, OS is Windows 2000 Server. Currently with single
instance installed, I checked the memory usage using task manager, the whole
s
system can only use up to less then 2 GB of memory. The peak is less than 2
GB. The system neven utilizing more than 2 GM of memory. I am in the proces
s
of doing server consolidation and planning to move another major application
database to this dell server. I want to utilize 4 G of memory after I
consolidate the other SQL server to the Dell Server. If I just move the
database to this dell server without creating a new instance, the most memor
y
we can utilize is 3GB with 3 GB switch set in boot.ini. If we create a new
instance, does that mean we can utilize the other 2 GB of Memory on the
server? Security is not a major concern when using single instance. What ar
e
the Pros and Cons?
Thank you very much for your help.You need Enterprise edition to use more than 2GB. Windows 2000 server does
not use the /3GB switch other than in a test scenario. Yes you can use two
instances and each can use 2GB but you have to be careful as now you can
lead to a situation where there is little left for the OS. If you are
consolidating then you should look at using Enterprise edition and Win2000
ADV Server (or Win2003) so you can use all 3GB for Sql Server and have a GB
for the OS and any other apps.
Andrew J. Kelly SQL MVP
"royHe" <royHe@.discussions.microsoft.com> wrote in message
news:8B395A5C-26F6-4E71-95B2-D9CE53E62100@.microsoft.com...
>I have a Dell server with 4GB of memory and 4 CPUs with 1.6G each, hosting
> one major application database. SQL Server 2000 Standard Edition was
> installed on the server, OS is Windows 2000 Server. Currently with single
> instance installed, I checked the memory usage using task manager, the
> wholes
> system can only use up to less then 2 GB of memory. The peak is less than
> 2
> GB. The system neven utilizing more than 2 GM of memory. I am in the
> process
> of doing server consolidation and planning to move another major
> application
> database to this dell server. I want to utilize 4 G of memory after I
> consolidate the other SQL server to the Dell Server. If I just move the
> database to this dell server without creating a new instance, the most
> memory
> we can utilize is 3GB with 3 GB switch set in boot.ini. If we create a new
> instance, does that mean we can utilize the other 2 GB of Memory on the
> server? Security is not a major concern when using single instance. What
> are
> the Pros and Cons?
> Thank you very much for your help.
>|||Thank you very much.
This is a dedicated SQL server. I find out in my situation the OS use very
little memory. Probably If I reserve 256M to 300M for the OS is enough.
Currently the peak for the OS Memory usage is around 250M.
"Andrew J. Kelly" wrote:

> You need Enterprise edition to use more than 2GB. Windows 2000 server do
es
> not use the /3GB switch other than in a test scenario. Yes you can use tw
o
> instances and each can use 2GB but you have to be careful as now you can
> lead to a situation where there is little left for the OS. If you are
> consolidating then you should look at using Enterprise edition and Win2000
> ADV Server (or Win2003) so you can use all 3GB for Sql Server and have a G
B
> for the OS and any other apps.
> --
> Andrew J. Kelly SQL MVP
>
> "royHe" <royHe@.discussions.microsoft.com> wrote in message
> news:8B395A5C-26F6-4E71-95B2-D9CE53E62100@.microsoft.com...
>
>sql

Multiple distribution agents running on subscriber

I have 1 production db and 1 subscriber db using transaction replication on
SQL Server 2000 standard edition. They are over 100 gb in size. Essentially
the subscriber is a hot backup for the the production server. The db was
restored manually at the subscriber because it is to large for snapshot.
After reading Hilary's book, scanning the internet and posting to this
group, I made an exucutive decision to split up the articles into smaller
subscriptions: 6 to be exact, using pull subscriptions to minimize problems
on the production server. This allowed me to better control/assess problems,
latency, etc.
Everything is going alot better (if you've read any of my previous posts)
and I have most of the problems under control and latency is way down.
(Thank Hilary and Paul!) I do have one BIG question though, since there
doesn't seem to be a lot of documentation on this type of set up (multiple
subscriptions and publications with a 1to1 database.)
Okay here is the question. My distribution agents that are running on the
subscriber will "stop" running once they have "succeeded" or no replicated
transactions are available for that subscription. What is the best way to
get notified once these have stopped and setup a schedule for restart when
new transactions are available? If there is no way of knowing when new
ones are available, can I set a job to automatically start the agents when
for peak times that transactions will be available for the particular
subscription? Right now I am doing it manually which isn't very condusive to
sleep.
For example I know my subscription called "Main Bulk" will need to be
running most often during working hours while my subscription called "Price
History" will need to be running mostly overnight. Hope I've explained this
clear enough.
Thanks!!!!
Kristy
I think your best bet would be to query
distribution.dbo.msdistribution_status and then start up the distribution
agent after a certain number of undelivered commands are pooled for a single
agent in the distribution database.
ie
select * from distribution.dbo.msdistribution_status where agent_id=7 and
UndelivCmdsInDistDB > 2000
if @.@.rowcount > 1000
exec sp_start_job @.job_id=0x8458390850805824052
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasereplyby@.posting.com> wrote in message
news:egY1BEoUFHA.3840@.tk2msftngp13.phx.gbl...
> I have 1 production db and 1 subscriber db using transaction replication
on
> SQL Server 2000 standard edition. They are over 100 gb in size.
Essentially
> the subscriber is a hot backup for the the production server. The db was
> restored manually at the subscriber because it is to large for snapshot.
> After reading Hilary's book, scanning the internet and posting to this
> group, I made an exucutive decision to split up the articles into smaller
> subscriptions: 6 to be exact, using pull subscriptions to minimize
problems
> on the production server. This allowed me to better control/assess
problems,
> latency, etc.
> Everything is going alot better (if you've read any of my previous posts)
> and I have most of the problems under control and latency is way down.
> (Thank Hilary and Paul!) I do have one BIG question though, since there
> doesn't seem to be a lot of documentation on this type of set up (multiple
> subscriptions and publications with a 1to1 database.)
> Okay here is the question. My distribution agents that are running on the
> subscriber will "stop" running once they have "succeeded" or no replicated
> transactions are available for that subscription. What is the best way to
> get notified once these have stopped and setup a schedule for restart when
> new transactions are available? If there is no way of knowing when new
> ones are available, can I set a job to automatically start the agents when
> for peak times that transactions will be available for the particular
> subscription? Right now I am doing it manually which isn't very condusive
to
> sleep.
> For example I know my subscription called "Main Bulk" will need to be
> running most often during working hours while my subscription called
"Price
> History" will need to be running mostly overnight. Hope I've explained
this
> clear enough.
> Thanks!!!!
> Kristy
>
>
sql

multiple distribution agents running

hi !

I am using sql server 2005 sp1 standard edition.

I have a transactional replication set up from one server to another.
From last couple of days i am noticing two distribution agents running for the same subscription in the replication monitor. Before this only one distribution agent was running. Is there any problem having two distribution agents running in parallel for the same subscription on a server?

Any help would be appreciated.

Thanks

No, this is by design. Its the old independent agent option from SQL 2000. By default SQL Server 2005 has this option enabled by default. Any time you have two or more publications in the same publication database pushing to the same subscription database on the same server SQL Server will use multiple distribution agents.

The problems you might face are overloading resources on the subscriber if the subscriber is a single proc machine or if the load is high, or if there are DRI dependencies between the articles in different publications. Also check to see if the SubscriptionStreams parameter has a value for your distribution agents.

Multiple dimensions from single dimension table

Hi,
SQL 2000 AS.
I have a dimension table 'Periods' example :
1 = Jan 2005
2 = Feb 2005
3 = Mar 2005
etc. NB This is not a standard time dimension.
The table has a key on 'PeiodID' = 1, 2, 3 etc.
My Fact table has say 2 period entries per row (say Billing, Collection) -
these can be different per row - eg Billing = 2, Collection = 4 etc.).
How do I add my Period dimension twice but linked to different columns, so
that each one shows up with a different name (say BillingPeriod,
CollectionPeriod).
I tried to create separate dimensions 'BillingPeriod' and 'CollectionPeriod'
but these both display on the table view as 'Period'. I CAN link both key
fields to Period but then can't see how each one is differentiated '.
Many Thanks
Regards
GrahamCreate and use a View for one of the dimensions.
HTH,
Mike
"GrahamS" wrote:

> Hi,
> SQL 2000 AS.
> I have a dimension table 'Periods' example :
> 1 = Jan 2005
> 2 = Feb 2005
> 3 = Mar 2005
> etc. NB This is not a standard time dimension.
> The table has a key on 'PeiodID' = 1, 2, 3 etc.
> My Fact table has say 2 period entries per row (say Billing, Collection) -
> these can be different per row - eg Billing = 2, Collection = 4 etc.).
> How do I add my Period dimension twice but linked to different columns, so
> that each one shows up with a different name (say BillingPeriod,
> CollectionPeriod).
> I tried to create separate dimensions 'BillingPeriod' and 'CollectionPerio
d'
> but these both display on the table view as 'Period'. I CAN link both key
> fields to Period but then can't see how each one is differentiated '.
> Many Thanks
> Regards
> Graham
>|||Mike,
Yup - thanks for the reply - I tried this today and it works pretty well.
I was hoping for something maybe not so 'dimension intensive', as I actually
have a number of similar dimensions to 'double up on'.
Thanks again.
regards
Graham
"Mike Austin" wrote:
[vbcol=seagreen]
> Create and use a View for one of the dimensions.
> HTH,
> Mike
> "GrahamS" wrote:
>|||May be you could use the table alias.
for eg. select a.factID billingperiond.periodID,
collectionperiod.PeriodIDfrom Billingfact a, periods as
billingperiond,periods as collectionperiod where
a.billingperiodID=billingperiod.PeriodID and
a.collectionperiodID=collectionperiod.periodID
Thx
Harsh
"GrahamS" wrote:

> Hi,
> SQL 2000 AS.
> I have a dimension table 'Periods' example :
> 1 = Jan 2005
> 2 = Feb 2005
> 3 = Mar 2005
> etc. NB This is not a standard time dimension.
> The table has a key on 'PeiodID' = 1, 2, 3 etc.
> My Fact table has say 2 period entries per row (say Billing, Collection) -
> these can be different per row - eg Billing = 2, Collection = 4 etc.).
> How do I add my Period dimension twice but linked to different columns, so
> that each one shows up with a different name (say BillingPeriod,
> CollectionPeriod).
> I tried to create separate dimensions 'BillingPeriod' and 'CollectionPerio
d'
> but these both display on the table view as 'Period'. I CAN link both key
> fields to Period but then can't see how each one is differentiated '.
> Many Thanks
> Regards
> Graham
>|||You will need to create a view over the dimension table and use that as
the source for one of your dimensions otherwise when the cube gets
populated you will only get facts where the 2 dates are equal.
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <B42197EA-E216-4310-A284-4416BB23A034@.microsoft.com>,
Harsh@.discussions.microsoft.com says...
> May be you could use the table alias.
> for eg. select a.factID billingperiond.periodID,
> collectionperiod.PeriodIDfrom Billingfact a, periods as
> billingperiond,periods as collectionperiod where
> a.billingperiodID=billingperiod.PeriodID and
> a.collectionperiodID=collectionperiod.periodID
> Thx
> Harsh
> "GrahamS" wrote:
>
>

Multiple dimensions from single dimension table

Hi,
SQL 2000 AS.
I have a dimension table 'Periods' example :
1 = Jan 2005
2 = Feb 2005
3 = Mar 2005
etc. NB This is not a standard time dimension.
The table has a key on 'PeiodID' = 1, 2, 3 etc.
My Fact table has say 2 period entries per row (say Billing, Collection) -
these can be different per row - eg Billing = 2, Collection = 4 etc.).
How do I add my Period dimension twice but linked to different columns, so
that each one shows up with a different name (say BillingPeriod,
CollectionPeriod).
I tried to create separate dimensions 'BillingPeriod' and 'CollectionPeriod'
but these both display on the table view as 'Period'. I CAN link both key
fields to Period but then can't see how each one is differentiated ?.
Many Thanks
Regards
Graham
Create and use a View for one of the dimensions.
HTH,
Mike
"GrahamS" wrote:

> Hi,
> SQL 2000 AS.
> I have a dimension table 'Periods' example :
> 1 = Jan 2005
> 2 = Feb 2005
> 3 = Mar 2005
> etc. NB This is not a standard time dimension.
> The table has a key on 'PeiodID' = 1, 2, 3 etc.
> My Fact table has say 2 period entries per row (say Billing, Collection) -
> these can be different per row - eg Billing = 2, Collection = 4 etc.).
> How do I add my Period dimension twice but linked to different columns, so
> that each one shows up with a different name (say BillingPeriod,
> CollectionPeriod).
> I tried to create separate dimensions 'BillingPeriod' and 'CollectionPeriod'
> but these both display on the table view as 'Period'. I CAN link both key
> fields to Period but then can't see how each one is differentiated ?.
> Many Thanks
> Regards
> Graham
>
|||Mike,
Yup - thanks for the reply - I tried this today and it works pretty well.
I was hoping for something maybe not so 'dimension intensive', as I actually
have a number of similar dimensions to 'double up on'.
Thanks again.
regards
Graham
"Mike Austin" wrote:
[vbcol=seagreen]
> Create and use a View for one of the dimensions.
> HTH,
> Mike
> "GrahamS" wrote:
|||May be you could use the table alias.
for eg. select a.factID billingperiond.periodID,
collectionperiod.PeriodIDfrom Billingfact a, periods as
billingperiond,periods as collectionperiod where
a.billingperiodID=billingperiod.PeriodID and
a.collectionperiodID=collectionperiod.periodID
Thx
Harsh
"GrahamS" wrote:

> Hi,
> SQL 2000 AS.
> I have a dimension table 'Periods' example :
> 1 = Jan 2005
> 2 = Feb 2005
> 3 = Mar 2005
> etc. NB This is not a standard time dimension.
> The table has a key on 'PeiodID' = 1, 2, 3 etc.
> My Fact table has say 2 period entries per row (say Billing, Collection) -
> these can be different per row - eg Billing = 2, Collection = 4 etc.).
> How do I add my Period dimension twice but linked to different columns, so
> that each one shows up with a different name (say BillingPeriod,
> CollectionPeriod).
> I tried to create separate dimensions 'BillingPeriod' and 'CollectionPeriod'
> but these both display on the table view as 'Period'. I CAN link both key
> fields to Period but then can't see how each one is differentiated ?.
> Many Thanks
> Regards
> Graham
>
|||You will need to create a view over the dimension table and use that as
the source for one of your dimensions otherwise when the cube gets
populated you will only get facts where the 2 dates are equal.
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <B42197EA-E216-4310-A284-4416BB23A034@.microsoft.com>,
Harsh@.discussions.microsoft.com says...
> May be you could use the table alias.
> for eg. select a.factID billingperiond.periodID,
> collectionperiod.PeriodIDfrom Billingfact a, periods as
> billingperiond,periods as collectionperiod where
> a.billingperiodID=billingperiod.PeriodID and
> a.collectionperiodID=collectionperiod.periodID
> Thx
> Harsh
> "GrahamS" wrote:
>