February 26, 2009 at 4:23 pm
Hi,
Hope you guys can give me some guidance on my problem below:
OLD Architecture: The application is based on Kerberos and it access the database server (App DB server) using impersonation. The views in the App DB will access the Datawarehouse server (DW server ) using linked server with SQL account. This is very secure as all users can be audited.
We now have a requirement to replicate 50 tables from the DW server to the App DB server. I've setup snapshot replication to replcate these 50 tables into another DB (DataMart) in the APP DB server. The replication is only run once a day at 7 am. We are keeping the linked server to access the the the DataMart to keep the security structure intact even though it is on the same server.
Replcation works fine. The only problem is that the application is often timed out when accessing the subscriber tables (DataMart). I get ASYNC_IO_WAIT in the activity monitor and the process status from the app is often SUSPENED.
If I remove the subscription then the app runs fine!!!
Can anyone tell my why this is happening & how I can debug it? I'm trying to resolve this ASAP. Yout help is much appreciated.
Cheers,
Michael
February 26, 2009 at 6:21 pm
Normally ASYNC_IO_WAIT is an indication of client-side slowness.
* Noel
February 28, 2009 at 2:38 pm
Thanks for your reply Noel, the problem was resolved by rebuilding the replication from Scratch.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply