Posted by NiponW on 11/01/06 09:39

Hi,
Database Server running slow. I used SP_WHO2 ACTIVE and the result
has many of

XXXX SA RUNNABLE MASTER AWAITING
COMMAND..........
(XXXX is spid)

and they stay for couples seconds.

Last week , the server was running fine and during weekend ,none
of errors record in Windows
event log or SQL Server log.

Server is Windows 2003 server with 4 CPUs of xeon , 4 GB of memory
and
MSSQL SERVER 200 SP4.

I found out that every runnable master db tasks has shared lock on
key of
'master.dbo.sysxlogins.sysxlogins' object

Is this the problem of slow running database server?

Please advice.

Peeud

[Back to original message]