|
|
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
Navigation:
[Reply to this message]
|