Break Deadlocks Quicker

Is there a parameter within SQL Server 2000 Enterprise
Edition that will break deadlocks quicker and use less
resources?
Thanks,
Mike
SQL Server usually detects deadlocks pretty quickly and when it does it
wastes no time killing one of the participants. You can however use a hint
called SET DEADLOCK_PRIORITY to potentially affect who gets killed.
Andrew J. Kelly SQL MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:f55e01c43dcf$fb009320$a301280a@.phx.gbl...
> Is there a parameter within SQL Server 2000 Enterprise
> Edition that will break deadlocks quicker and use less
> resources?
> Thanks,
> Mike
>
|||Mike,
you might want to check out
SET LOCK_TIMEOUT
SET DEADLOCK_PRIORITY
in BOL.
HTH,
Paul Ibison
|||Though don't let that stop you coming to the route causes of the deadlocking. SQL BOL gives a pretty good overview.
Alicia
www.sqlporn.co.uk

Break Deadlocks Quicker

Is there a parameter within SQL Server 2000 Enterprise
Edition that will break deadlocks quicker and use less
resources?
Thanks,
MikeSQL Server usually detects deadlocks pretty quickly and when it does it
wastes no time killing one of the participants. You can however use a hint
called SET DEADLOCK_PRIORITY to potentially affect who gets killed.
Andrew J. Kelly SQL MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:f55e01c43dcf$fb009320$a301280a@.phx.gbl...
> Is there a parameter within SQL Server 2000 Enterprise
> Edition that will break deadlocks quicker and use less
> resources?
> Thanks,
> Mike
>|||Mike,
you might want to check out
SET LOCK_TIMEOUT
SET DEADLOCK_PRIORITY
in BOL.
HTH,
Paul Ibison|||Though don't let that stop you coming to the route causes of the deadlocking
. SQL BOL gives a pretty good overview.
Alicia
www.sqlporn.co.uk

boot.ini /3GB problem

Hello,
I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB swich
with awe enabled on sql 2000 without any good result. I could said even
situation is wors because now sql allocate maximum 1,327 GB.
Does anyone hnow what can be wrong ?
I have read many of support pages from MS for allocate more than 2G and
nothing is working
regards
Pawel Mylka
Hi
Task manager is not the correct tool to evaluate if memory over 2 GB is
being used as it is not capable of it.
Use Windows Performance Monitor (%SystemRoot%\system32\perfmon.msc /s) to
see how much "Target Server Memory" is. It should be close to 2700 when SQL
Server is configured correctly.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
> edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB
> swich
> with awe enabled on sql 2000 without any good result. I could said even
> situation is wors because now sql allocate maximum 1,327 GB.
> Does anyone hnow what can be wrong ?
> I have read many of support pages from MS for allocate more than 2G and
> nothing is working
> regards
> Pawel Mylka
>
|||Hi,
As Mike pointed out use Performance monitor to view the memory usage. As
well as make the memory static (set min and max meory)
once you enable AWE to SQL Server.
Thanks
Hari
SQL Server MVP
"Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
> edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB
> swich
> with awe enabled on sql 2000 without any good result. I could said even
> situation is wors because now sql allocate maximum 1,327 GB.
> Does anyone hnow what can be wrong ?
> I have read many of support pages from MS for allocate more than 2G and
> nothing is working
> regards
> Pawel Mylka
>
|||Don't enable AWE unless you intend to go beyond 3GB.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OoI%23Nzt4FHA.3876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> As Mike pointed out use Performance monitor to view the memory usage. As
> well as make the memory static (set min and max meory)
> once you enable AWE to SQL Server.
> Thanks
> Hari
> SQL Server MVP
> "Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
> news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
>

boot.ini /3GB problem

Hello,
I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB swich
with awe enabled on sql 2000 without any good result. I could said even
situation is wors because now sql allocate maximum 1,327 GB.
Does anyone hnow what can be wrong '
I have read many of support pages from MS for allocate more than 2G and
nothing is working
regards
Pawel MylkaHi
Task manager is not the correct tool to evaluate if memory over 2 GB is
being used as it is not capable of it.
Use Windows Performance Monitor (%SystemRoot%\system32\perfmon.msc /s) to
see how much "Target Server Memory" is. It should be close to 2700 when SQL
Server is configured correctly.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
> edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB
> swich
> with awe enabled on sql 2000 without any good result. I could said even
> situation is wors because now sql allocate maximum 1,327 GB.
> Does anyone hnow what can be wrong '
> I have read many of support pages from MS for allocate more than 2G and
> nothing is working
> regards
> Pawel Mylka
>|||Hi,
As Mike pointed out use Performance monitor to view the memory usage. As
well as make the memory static (set min and max meory)
once you enable AWE to SQL Server.
Thanks
Hari
SQL Server MVP
"Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
> edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB
> swich
> with awe enabled on sql 2000 without any good result. I could said even
> situation is wors because now sql allocate maximum 1,327 GB.
> Does anyone hnow what can be wrong '
> I have read many of support pages from MS for allocate more than 2G and
> nothing is working
> regards
> Pawel Mylka
>|||Don't enable AWE unless you intend to go beyond 3GB.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OoI%23Nzt4FHA.3876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> As Mike pointed out use Performance monitor to view the memory usage. As
> well as make the memory static (set min and max meory)
> once you enable AWE to SQL Server.
> Thanks
> Hari
> SQL Server MVP
> "Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
> news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
>