microsoft.public.sqlserver.server - Server Locking issue

Author

Server Locking issue

Ravi

2002-12-20, 11:23 am

Hi,

I have created linked-server. When I tried to access
tables from remote database, it locked the server
with 'PAGEIOLATCH_SH' and 'WRITELOG' wait types.

I couldn't kill the processes. Can you please recommend an
easy way to kill the processes instead of shuting-down the
database/server.

Thanks for your response.
Ravi

Sponsored Links