Multithreading in Sql Server

Hi,
Does sqlserver 2000 supports multi threading?
If so how can we implement it?
As per my knowledge it supports Symmetric multi
processing.
Can you please confirm this?
I posted this in english query section.Iam reposting it
here since this group is more relevant.
Thanks in adavance.
-SriramSQL automatically handles multiple processors... However when you go into
SQL Enterprise Manager, right click your server registration and select
properties, one of the tabs will allow you to choose how many of the
processors to use, 0 means use them all...
One of the diferences between SQL Standard and SQL Enterprise is how much
multi processing goes on during maintenance, like creating indexes... Of
course SQL Enterprise is more scalable.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sriram" <surapureddysriram@.yahoo.co.in> wrote in message
news:a08a01c4794f$2d51cf50$a601280a@.phx.gbl...
> Hi,
> Does sqlserver 2000 supports multi threading?
> If so how can we implement it?
> As per my knowledge it supports Symmetric multi
> processing.
> Can you please confirm this?
> I posted this in english query section.Iam reposting it
> here since this group is more relevant.
> Thanks in adavance.
> -Sriram
>|||You don't normally control threading within an application. AFAIK - SQL
Server is a multi-threaded application; there is nothing to "implement".
Perhaps you are confusing multiple threads with multiple processors. If so,
then see Wayne's response.
"Sriram" <surapureddysriram@.yahoo.co.in> wrote in message
news:a08a01c4794f$2d51cf50$a601280a@.phx.gbl...
> Hi,
> Does sqlserver 2000 supports multi threading?
> If so how can we implement it?
> As per my knowledge it supports Symmetric multi
> processing.
> Can you please confirm this?
> I posted this in english query section.Iam reposting it
> here since this group is more relevant.
> Thanks in adavance.
> -Sriram
>sql

Multiple servers running

We have our main core processing running Oracle but uses sqlpipe to reach the
data center. We are now installing new software that uses sql as it's
database server. The problem I have is each instance looks for the same
servername. can you add multiple servernames with the sql.ini file or how
would you go about this?
--
Scott"Spenbank" <Spenbank@.discussions.microsoft.com> wrote in message
news:D05AE45F-EBE7-43BA-96A3-EBEBCF73AC43@.microsoft.com...
> We have our main core processing running Oracle but uses sqlpipe to reach
the
> data center. We are now installing new software that uses sql as it's
> database server. The problem I have is each instance looks for the same
> servername. can you add multiple servernames with the sql.ini file or how
> would you go about this?
Look up INSTANCES in books online.
So you'd have something like:
SERVER\Instance1
SERVER\Instance2
etc.
Generally at least in non cluster situations I find having separate
instances not a big help for SQL Server.
> --
> Scott|||"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:qnFtd.39078$1u.35551@.twister.nyroc.rr.com...
> "Spenbank" <Spenbank@.discussions.microsoft.com> wrote in message
> news:D05AE45F-EBE7-43BA-96A3-EBEBCF73AC43@.microsoft.com...
>> We have our main core processing running Oracle but uses sqlpipe to reach
> the
>> data center. We are now installing new software that uses sql as it's
>> database server. The problem I have is each instance looks for the same
>> servername. can you add multiple servernames with the sql.ini file or how
>> would you go about this?
> Look up INSTANCES in books online.
> So you'd have something like:
> SERVER\Instance1
> SERVER\Instance2
> etc.
> Generally at least in non cluster situations I find having separate
> instances not a big help for SQL Server.
>
>> --
>> Scott
>
Ahh, but in our hosted environment, each company can have it's own
"instance" and have their own set of security credentials that give them
access to their instance, but no one elses. =)
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in message
news:OA4qrOU3EHA.4072@.TK2MSFTNGP10.phx.gbl...
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:qnFtd.39078$1u.35551@.twister.nyroc.rr.com...
> >
> > Generally at least in non cluster situations I find having separate
> > instances not a big help for SQL Server.
> >
> >
> >> --
> >> Scott
> >
> >
> Ahh, but in our hosted environment, each company can have it's own
> "instance" and have their own set of security credentials that give them
> access to their instance, but no one elses. =)
Hence my qualification. :-)
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

Multiple servers running

We have our main core processing running Oracle but uses sqlpipe to reach the
data center. We are now installing new software that uses sql as it's
database server. The problem I have is each instance looks for the same
servername. can you add multiple servernames with the sql.ini file or how
would you go about this?
Scott
"Spenbank" <Spenbank@.discussions.microsoft.com> wrote in message
news:D05AE45F-EBE7-43BA-96A3-EBEBCF73AC43@.microsoft.com...
> We have our main core processing running Oracle but uses sqlpipe to reach
the
> data center. We are now installing new software that uses sql as it's
> database server. The problem I have is each instance looks for the same
> servername. can you add multiple servernames with the sql.ini file or how
> would you go about this?
Look up INSTANCES in books online.
So you'd have something like:
SERVER\Instance1
SERVER\Instance2
etc.
Generally at least in non cluster situations I find having separate
instances not a big help for SQL Server.

> --
> Scott
|||"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:qnFtd.39078$1u.35551@.twister.nyroc.rr.com...
> "Spenbank" <Spenbank@.discussions.microsoft.com> wrote in message
> news:D05AE45F-EBE7-43BA-96A3-EBEBCF73AC43@.microsoft.com...
> the
> Look up INSTANCES in books online.
> So you'd have something like:
> SERVER\Instance1
> SERVER\Instance2
> etc.
> Generally at least in non cluster situations I find having separate
> instances not a big help for SQL Server.
>
>
Ahh, but in our hosted environment, each company can have it's own
"instance" and have their own set of security credentials that give them
access to their instance, but no one elses. =)
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" <quickening@.msn.com> wrote in message
news:OA4qrOU3EHA.4072@.TK2MSFTNGP10.phx.gbl...
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message[vbcol=seagreen]
> news:qnFtd.39078$1u.35551@.twister.nyroc.rr.com...

> Ahh, but in our hosted environment, each company can have it's own
> "instance" and have their own set of security credentials that give them
> access to their instance, but no one elses. =)
Hence my qualification. :-)

> Rick Sawtell
> MCT, MCSD, MCDBA
>
>