Deadlock problem

Hello,
We have more deadlock after we insert a second database in our server of
database. The allocating of memory is dynamic. One DB was for the
production and the other for testing.
The two DB are sollicitated at each minute. How sql server manage is
memory? Can we give a priority of allocation of memory for the DB of
production. Do you think that the deadlock, occured because we insert this
second database? Each database make 6 GIGs. We have 1 GIG of memory.
We're gonna try to remove the second database for see if it's the problem.
Thank for your help
DanHi Dany.
Deadlocks & memory allocation are not directly related issues. Deadlocks
occur because of locking conflicts within the database - eg multiple
connections trying to update each other's rows at the same time..
Memory conflicts can occur between multiple instances of sql server on the
same computer, but a single instance of sql server manages memory allocation
between individual databases seemlessly.
Regards,
Greg Linwood
SQL Server MVP
"Dany Marois" <dany.marois@.videotron.ca> wrote in message
news:OrTYzoO6DHA.2568@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We have more deadlock after we insert a second database in our server of
> database. The allocating of memory is dynamic. One DB was for the
> production and the other for testing.
> The two DB are sollicitated at each minute. How sql server manage is
> memory? Can we give a priority of allocation of memory for the DB of
> production. Do you think that the deadlock, occured because we insert this
> second database? Each database make 6 GIGs. We have 1 GIG of memory.
> We're gonna try to remove the second database for see if it's the problem.
> Thank for your help
> Dan
>