Is there such a thing as a Deadlocks that can occur on Memory Resources?
Regards
JTC ^..^
JTC,
Deadlocks are caused by mutual blocked resources. These resources
(data/index) tables, pages, rows are accessed in and used in memory once
physically read from disk.
HTH
Jerry
"JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
news:Xns96E7E292FF2DdaveJTC@.213.123.26.234...
> Is there such a thing as a Deadlocks that can occur on Memory Resources?
> --
> Regards
> JTC ^..^
|||Hi,
The Dead locks occurs when u process two process or more at one time on
a single table.
Sql Server locks the table to complete the first process and process
for second one.
If u execute any DML command it is writen to disk on checkup point.
Once read from disk the data is stored in memory
HTH
Doller
No comments:
Post a Comment