Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database Question

2 posts in General Discussion Last posting was on 2011-10-21 05:51:38.0Z
RajV Posted on 2011-10-20 20:40:01.0Z
Sender: 4dbe.4e9c50d5.1804289383@sybase.com
From: RajV
Newsgroups: sybase.public.ase.general
Subject: Database Question
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ea08721.18ca.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Oct 2011 13:40:01 -0700
X-Trace: forums-1-dub 1319143201 10.22.241.41 (20 Oct 2011 13:40:01 -0700)
X-Original-Trace: 20 Oct 2011 13:40:01 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30628
Article PK: 73519

Hi

How do you measure contention on a database like tempdb for
instance?

Thanks


Eisen Posted on 2011-10-21 05:51:38.0Z
Sender: 3f8c.4ea0ffcb.1804289383@sybase.com
From: Eisen
Newsgroups: sybase.public.ase.general
Subject: Re: Database Question
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ea1086a.4117.1681692777@sybase.com>
References: <4ea08721.18ca.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Oct 2011 22:51:38 -0700
X-Trace: forums-1-dub 1319176298 10.22.241.41 (20 Oct 2011 22:51:38 -0700)
X-Original-Trace: 20 Oct 2011 22:51:38 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30630
Article PK: 73521

Hi Raj
Do you mean "select count(distinct spid) from
master..syslocks where dbid=db_id('tempdb')" or "select
count(*) from master..sysprocesses where
dbid=db_id('tempdb')"?

Best Regards
Eisen

> Hi
>
> How do you measure contention on a database like tempdb
> for instance?
>
> Thanks