One ms sql server 2000 instance blocks the other (thru a dts-job)

Hello,

we use two instances of the ms sql server 2000 (Version: 8.00.760) on a
4 processor windows 2000 (sp 4) machine.
A dts-packet on one instance completly blocks the work on the other
instance. Both instances have 2 dedicated processors. The two
processors of the blocked instance are in idle states.
How is this possible? Has someone had the same behavior of the sql
server and found a solution for this problem?

Thanks in advance for answers

Jrgen Simonsen(juergen.simonsen@.web.de) writes:
> we use two instances of the ms sql server 2000 (Version: 8.00.760) on a
> 4 processor windows 2000 (sp 4) machine.
> A dts-packet on one instance completly blocks the work on the other
> instance. Both instances have 2 dedicated processors. The two
> processors of the blocked instance are in idle states.
> How is this possible? Has someone had the same behavior of the sql
> server and found a solution for this problem?

Have you tried to access that blocked instance, to see if it is possible
to run queries on it? Have you checked the SQL Server error log for the
blocked instance?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

One instance or two instances

Hi,

If I have two applications which have several databases for each application, do you create one instance for two applications or you create one instance for each application? Which way is better on pricing, performance, maintanence etc?

Thanks for your input

It does not matter as far as pricing goes. You can install multiple instances on the same server once you have a single license.

If you have multiple instances on the same server, you need to think about how much memory you allocate to each instance (by setting the max memory option). In most cases you would be better off (especially from a performance and maint perspective) to only have one instance on the machine, rather than one instance per application.

Multiple instances can be more secure (from each other), and they can be at different SP levels.

|||

thanks for your help.

Where I can change the parameter for the instance on memory limitation etc?

Thanks

|||

In SQL Server 2005, you can use SQL Server Management Studio (SSMS). In Object Explorer, select the instance, right-click and select Properties. Then select Memory, and set the value for the Max server memory. You want to leave some memory for the OS.

Please mark this question as answered if this was helpful. Thanks!

OLE DB provider name

Hi,
I am trying to get a list of most possible provider names (OLE DB) for the
following database types: (for instance, Access - "Microsoft.Jet.OLEDB.4.0")
DB/2
Ingress
Informix
MySQL
Oracle
Postgres
SQL Server
Sybase
Virtuoso
Can anyone help?
Thanks in advance."Danila Vershinin" <cia@.pnz.ru> wrote in message
news:OYxD$re8FHA.3132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to get a list of most possible provider names (OLE DB)
for the
> following database types: (for instance, Access -
"Microsoft.Jet.OLEDB.4.0")
> DB/2
> Ingress
> Informix
> MySQL
> Oracle
> Postgres
> SQL Server
> Sybase
> Virtuoso
> Can anyone help?
> Thanks in advance.
>
Danila Vershinin,
http://www.connectionstrings.com/
http://www.carlprothman.net/Default.aspx?tabid=81
Sincerely,
Chris O.