Resolving deadlock

Hi All,
Currently I am experiencing a dead lock issue in one of enviornment. I have
identified the dead lock is of type "Deadlocks Involving Threads".
Does any one know how to resolve "Deadlocks Involving Threads".
Regards
Shri.DBAHi
You will need to determine what the threads are doing and resolve the
underlying problem.
Check out http://support.microsoft.com/kb/224453/
http://support.microsoft.com/kb/162361/
http://support.microsoft.com/kb/271509/
John
"Shri.DBA" wrote:
> Hi All,
> Currently I am experiencing a dead lock issue in one of enviornment. I have
> identified the dead lock is of type "Deadlocks Involving Threads".
> Does any one know how to resolve "Deadlocks Involving Threads".
> Regards
> Shri.DBA
>
>

Reserved Space

I have a 8GB database, witch only 2,5GB is used by the database itself, the
rest is identified as reserved space. How do i shrink the reserved space or
limit it's size?
The databese keeps growing and almoust all the growing is related to the
Reserved Space.
Humberto Goncalveshttp://msdn.microsoft.com/library/d...
pd1.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Humberto Goncalves" wrote:

> I have a 8GB database, witch only 2,5GB is used by the database itself, th
e
> rest is identified as reserved space. How do i shrink the reserved space o
r
> limit it's size?
> The databese keeps growing and almoust all the growing is related to the
> Reserved Space.
> Humberto Goncalves|||Didn't work, only 200MB less.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> http://msdn.microsoft.com/library/d...r />
_3pd1.asp
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Humberto Goncalves" wrote:
>|||Try reorging your tables (i.e. rebuilding clustered indexes) and then the
SHRINKDATABASE).
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...[vbcol=seagreen]
> Didn't work, only 200MB less.
> "Jens Smeyer" wrote:
>|||Already done that, no changes.
I've got more 600MB, but i can't go further than this.
Still 3,5GB missing...
"Dan Guzman" wrote:

> Try reorging your tables (i.e. rebuilding clustered indexes) and then the
> SHRINKDATABASE).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote i
n
> message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
>
>|||Do you have text/ntext/image columns? In that case, see
http://support.microsoft.com/defaul...b;en-us;324432. Also, check
to ensure you have clustered indexes on your tables, especially the large
ones.
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:EA8967E8-B826-4231-A556-69E51A86A73D@.microsoft.com...[vbcol=seagreen]
> Already done that, no changes.
> I've got more 600MB, but i can't go further than this.
> Still 3,5GB missing...
> "Dan Guzman" wrote:
>

Reserved Space

I have a 8GB database, witch only 2,5GB is used by the database itself, the
rest is identified as reserved space. How do i shrink the reserved space or
limit it's size?
The databese keeps growing and almoust all the growing is related to the
Reserved Space.
Humberto Goncalves
http://msdn.microsoft.com/library/de..._dbcc_3pd1.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Humberto Goncalves" wrote:

> I have a 8GB database, witch only 2,5GB is used by the database itself, the
> rest is identified as reserved space. How do i shrink the reserved space or
> limit it's size?
> The databese keeps growing and almoust all the growing is related to the
> Reserved Space.
> Humberto Goncalves
|||Didn't work, only 200MB less.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> http://msdn.microsoft.com/library/de..._dbcc_3pd1.asp
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Humberto Goncalves" wrote:
|||Try reorging your tables (i.e. rebuilding clustered indexes) and then the
SHRINKDATABASE).
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...[vbcol=seagreen]
> Didn't work, only 200MB less.
> "Jens Smeyer" wrote:
|||Already done that, no changes.
I've got more 600MB, but i can't go further than this.
Still 3,5GB missing...
"Dan Guzman" wrote:

> Try reorging your tables (i.e. rebuilding clustered indexes) and then the
> SHRINKDATABASE).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
> message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
>
>
|||Do you have text/ntext/image columns? In that case, see
http://support.microsoft.com/default...;en-us;324432. Also, check
to ensure you have clustered indexes on your tables, especially the large
ones.
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:EA8967E8-B826-4231-A556-69E51A86A73D@.microsoft.com...[vbcol=seagreen]
> Already done that, no changes.
> I've got more 600MB, but i can't go further than this.
> Still 3,5GB missing...
> "Dan Guzman" wrote:

Reserved Space

I have a 8GB database, witch only 2,5GB is used by the database itself, the
rest is identified as reserved space. How do i shrink the reserved space or
limit it's size?
The databese keeps growing and almoust all the growing is related to the
Reserved Space.
Humberto Goncalveshttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.asp
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Humberto Goncalves" wrote:
> I have a 8GB database, witch only 2,5GB is used by the database itself, the
> rest is identified as reserved space. How do i shrink the reserved space or
> limit it's size?
> The databese keeps growing and almoust all the growing is related to the
> Reserved Space.
> Humberto Goncalves|||Didn't work, only 200MB less.
"Jens Sü�meyer" wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.asp
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Humberto Goncalves" wrote:
> > I have a 8GB database, witch only 2,5GB is used by the database itself, the
> > rest is identified as reserved space. How do i shrink the reserved space or
> > limit it's size?
> > The databese keeps growing and almoust all the growing is related to the
> > Reserved Space.
> >
> > Humberto Goncalves|||Try reorging your tables (i.e. rebuilding clustered indexes) and then the
SHRINKDATABASE).
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
> Didn't work, only 200MB less.
> "Jens Süßmeyer" wrote:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.asp
>> --
>> HTH, Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "Humberto Goncalves" wrote:
>> > I have a 8GB database, witch only 2,5GB is used by the database itself,
>> > the
>> > rest is identified as reserved space. How do i shrink the reserved
>> > space or
>> > limit it's size?
>> > The databese keeps growing and almoust all the growing is related to
>> > the
>> > Reserved Space.
>> >
>> > Humberto Goncalves|||Already done that, no changes.
I've got more 600MB, but i can't go further than this.
Still 3,5GB missing...
"Dan Guzman" wrote:
> Try reorging your tables (i.e. rebuilding clustered indexes) and then the
> SHRINKDATABASE).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
> message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
> > Didn't work, only 200MB less.
> >
> > "Jens Sü�meyer" wrote:
> >
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.asp
> >>
> >> --
> >> HTH, Jens Suessmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
> >> "Humberto Goncalves" wrote:
> >>
> >> > I have a 8GB database, witch only 2,5GB is used by the database itself,
> >> > the
> >> > rest is identified as reserved space. How do i shrink the reserved
> >> > space or
> >> > limit it's size?
> >> > The databese keeps growing and almoust all the growing is related to
> >> > the
> >> > Reserved Space.
> >> >
> >> > Humberto Goncalves
>
>|||Do you have text/ntext/image columns? In that case, see
http://support.microsoft.com/default.aspx?scid=kb;en-us;324432. Also, check
to ensure you have clustered indexes on your tables, especially the large
ones.
Hope this helps.
Dan Guzman
SQL Server MVP
"Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote in
message news:EA8967E8-B826-4231-A556-69E51A86A73D@.microsoft.com...
> Already done that, no changes.
> I've got more 600MB, but i can't go further than this.
> Still 3,5GB missing...
> "Dan Guzman" wrote:
>> Try reorging your tables (i.e. rebuilding clustered indexes) and then the
>> SHRINKDATABASE).
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Humberto Goncalves" <HumbertoGoncalves@.discussions.microsoft.com> wrote
>> in
>> message news:7D0ABB8E-761A-4BEE-9DBB-664A78AD0677@.microsoft.com...
>> > Didn't work, only 200MB less.
>> >
>> > "Jens Süßmeyer" wrote:
>> >
>> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_3pd1.asp
>> >>
>> >> --
>> >> HTH, Jens Suessmeyer.
>> >>
>> >> --
>> >> http://www.sqlserver2005.de
>> >> --
>> >>
>> >>
>> >> "Humberto Goncalves" wrote:
>> >>
>> >> > I have a 8GB database, witch only 2,5GB is used by the database
>> >> > itself,
>> >> > the
>> >> > rest is identified as reserved space. How do i shrink the reserved
>> >> > space or
>> >> > limit it's size?
>> >> > The databese keeps growing and almoust all the growing is related to
>> >> > the
>> >> > Reserved Space.
>> >> >
>> >> > Humberto Goncalves
>>