| Author |
mirror db blocking issue
|
|
|
| Hello All
I've set up a job to backup our financial db and restore it to the same
machine (different files & db name) for reporting. This was to avoid a
blocking issue caused by the front end financial system.
The thing is, the blocking is still there, even when you are reporting
on the mirror database and the blocking process is on the other db!
Is this something to do with the objects having the same names/indexes
in sysobjects? Any ideas on how to resolve it?
Thanks!
Paul
| |
| Andrew J. Kelly 2006-12-04, 7:12 pm |
| That isn't possible. I suspect you have more to this than you are reporting.
Locks in one db do not affect queries in another unless the query or
transaction is across both dbs. You might want to have a look at these:
http://support.microsoft.com/kb/271509
http://www.sql-server-performance.c..._prevention.asp
--
Andrew J. Kelly SQL MVP
"pdm" <paulusm@gmail.com> wrote in message
news:1165263399.585739.293410@16g2000cwy.googlegroups.com...
> Hello All
>
> I've set up a job to backup our financial db and restore it to the same
> machine (different files & db name) for reporting. This was to avoid a
> blocking issue caused by the front end financial system.
>
> The thing is, the blocking is still there, even when you are reporting
> on the mirror database and the blocking process is on the other db!
>
> Is this something to do with the objects having the same names/indexes
> in sysobjects? Any ideas on how to resolve it?
>
> Thanks!
>
> Paul
>
| |
|
| You are absolutely right, I was being a dumb-XXX
I had the dbname hardcoded in the stored procedures
Thsnks for your time though!
P
| |
| Andrew J. Kelly 2006-12-05, 7:12 pm |
| That is the biggest argument to never using the db name in the object
qualifier unless you are actually intending to go cross db in the first
place. You are not the first one to get bit by that and you won't be the
last.
--
Andrew J. Kelly SQL MVP
"pdm" <paulusm@gmail.com> wrote in message
news:1165316471.090188.94890@16g2000cwy.googlegroups.com...
> You are absolutely right, I was being a dumb-XXX
>
> I had the dbname hardcoded in the stored procedures
>
> Thsnks for your time though!
>
> P
>
|
|
|
|