Runnable master awaiting command

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

Quote:

Originally Posted by

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.

As long as these entries only stay for a couple of seconds it means
that whatever is opening these connections is closing it again. I would
start to worry if these connections don't close and are increasing in
numbers.

Also as long as the BlkBy column doesn't have an entry then it means
that the these processes aren't being blocked, which is a good thing.

Quote:

Originally Posted by

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?

When you mean slow running database server are you referring to
Windows, or SQL Server when you pull a query? If you are referring to
Windows, use Windows Task Manager to ensure that there are no processes
using large amounts of CPU or Memory resources. If you are referring to
SQL Server, use SQL Profiler to determine what queries are running and
see if some performance tuning can be done on those tables.

Regards,
Louis

Run out of alphabets

When you set up say 3 active and 1 passive multi instance cluster and
especially if any one instance uses say 10 alphabets, how do you configure
the cluster then ? Can you use something other than alphabets for your
resources ? This would be tied to a SAN too...
First investigate mount-points on cluster service :
http://support.microsoft.com/kb/280297
Then investigate mount-points for SQL :
http://support.microsoft.com/kb/819546/
HTH,
_Edwin.
"Hassan" <hassan@.hotmail.com> wrote in message
news:uM0CygnRHHA.3812@.TK2MSFTNGP06.phx.gbl...
> When you set up say 3 active and 1 passive multi instance cluster and
> especially if any one instance uses say 10 alphabets, how do you configure
> the cluster then ? Can you use something other than alphabets for your
> resources ? This would be tied to a SAN too...
>
|||"Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> First investigate mount-points on cluster service :
> http://support.microsoft.com/kb/280297
> Then investigate mount-points for SQL :
> http://support.microsoft.com/kb/819546/
and then redesign you cluster to make sure you have enough drive letters...
I have seen and heard bad things about using mount points both in Exchange
and in SQL.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Denver starting Feb 12th
NYC starting Feb 19th
London starting March 6th
|||Mount points seem a lot more stable in SQL 2005, at least from what I have
seen and heard.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Russ Kaufmann [MVP]" <russ@.clusterhelp.com> wrote in message
news:ue$7SNuRHHA.2256@.TK2MSFTNGP02.phx.gbl...
> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> and then redesign you cluster to make sure you have enough drive
> letters...
> I have seen and heard bad things about using mount points both in Exchange
> and in SQL.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Denver starting Feb 12th
> NYC starting Feb 19th
> London starting March 6th
>
|||I have tested using mounted volumes in SQL2005 quite extensively. Apart from
the fact that they forgot to require the dependency of SQL Server on a
mounted volume, I don't see any serious issue with supporting mounted volumes
with SQL2005 in a cluster.
Linchi
"Russ Kaufmann [MVP]" wrote:

> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> and then redesign you cluster to make sure you have enough drive letters...
> I have seen and heard bad things about using mount points both in Exchange
> and in SQL.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Denver starting Feb 12th
> NYC starting Feb 19th
> London starting March 6th
>
>
|||I must admit I have seen bad things with mountpoints as well, however I have
yet to find a case where it is not related to bad configuration, and
predominantly the setup of dependencies.
rgds,
Edwin.
"Russ Kaufmann [MVP]" <russ@.clusterhelp.com> wrote in message
news:ue$7SNuRHHA.2256@.TK2MSFTNGP02.phx.gbl...
> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> and then redesign you cluster to make sure you have enough drive
letters...
> I have seen and heard bad things about using mount points both in Exchange
> and in SQL.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Denver starting Feb 12th
> NYC starting Feb 19th
> London starting March 6th
>
|||If you are running SS2K or a mix of SS2K and SS2K5, then you have found the
limitation with multi-instancing and clusters: SQL Server 2000 does not
support drive mount points, at all, not even for SS2K5 on the same cluster.
http://support.microsoft.com/kb/819546/en-us
If you are only running SS2K5, then mount points are supported. You would
use 1 drive letter for the base drive, but then use mount points for the
remainder. You would need to create one lettered drive for each resource
group/SQL Server instance.
http://support.microsoft.com/kb/280297/
Sincerely,
Anthony Thomas

"Hassan" <hassan@.hotmail.com> wrote in message
news:uM0CygnRHHA.3812@.TK2MSFTNGP06.phx.gbl...
> When you set up say 3 active and 1 passive multi instance cluster and
> especially if any one instance uses say 10 alphabets, how do you configure
> the cluster then ? Can you use something other than alphabets for your
> resources ? This would be tied to a SAN too...
>