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.

EXECUTION TIME 0 with set statistics io and set statistics time on

6 posts in General Discussion Last posting was on 2010-11-01 18:28:54.0Z
Liezl Posted on 2010-10-29 13:19:11.0Z
Sender: 3bfd.4ccac825.1804289383@sybase.com
From: Liezl
Newsgroups: sybase.public.ase.general
Subject: EXECUTION TIME 0 with set statistics io and set statistics time on
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ccac9cf.3c36.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Oct 2010 06:19:11 -0700
X-Trace: forums-1-dub 1288358351 10.22.241.41 (29 Oct 2010 06:19:11 -0700)
X-Original-Trace: 29 Oct 2010 06:19:11 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29675
Article PK: 78905

OK I know ASE 15.5 is VERY fast, but EXECUTION TIME keeps on
showing as zero - please see below

Even with queries running long - is there something that I
need to set? This affects WORKSPACE as well.


Table: sysobjects scan count 1, logical reads: (regular=7
apf=0 total=7),
physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Total writes for this command: 0

Execution Time 0.
Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
time: 0 ms.


J Posted on 2010-10-29 15:25:22.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: EXECUTION TIME 0 with set statistics io and set statistics time on
Reply-To: J@bogusemailAddress.com
Message-ID: <4ccae748.722750@forums.sybase.com>
References: <4ccac9cf.3c36.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 29 Oct 2010 08:25:22 -0700
X-Trace: forums-1-dub 1288365922 10.22.241.152 (29 Oct 2010 08:25:22 -0700)
X-Original-Trace: 29 Oct 2010 08:25:22 -0700, vip152.sybase.com
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29676
Article PK: 78904

On 29 Oct 2010 06:19:11 -0700, Liezl wrote:

Could you give the output from 'select @@version' ?

jay

>OK I know ASE 15.5 is VERY fast, but EXECUTION TIME keeps on
>showing as zero - please see below
>
>Even with queries running long - is there something that I
>need to set? This affects WORKSPACE as well.
>
>
>Table: sysobjects scan count 1, logical reads: (regular=7
>apf=0 total=7),
>physical reads: (regular=0 apf=0 total=0), apf IOs used=0
>Total writes for this command: 0
>
>Execution Time 0.
>Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
>time: 0 ms.


Liezl Posted on 2010-10-31 19:35:51.0Z
Sender: 3384.4ccdbb4c.1804289383@sybase.com
From: Liezl
Newsgroups: sybase.public.ase.general
Subject: Re: EXECUTION TIME 0 with set statistics io and set statistics time on
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ccdd327.352f.1681692777@sybase.com>
References: <4ccae748.722750@forums.sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Oct 2010 12:35:51 -0700
X-Trace: forums-1-dub 1288557351 10.22.241.41 (31 Oct 2010 12:35:51 -0700)
X-Original-Trace: 31 Oct 2010 12:35:51 -0700, 10.22.241.41
Lines: 88
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29680
Article PK: 78909

In my case, when I run any select, even an sp_helpdevice or
sp_helpdb, I get EXECUTION TIME 0.
Surely these procs take a few miliseconds?

I played around and tried to hold things up on purpose, to
see if I could get ANY execution time greater than zero.

In Session ONE, I left an INSERT tran unCommitted for a few
seconds, while doing a select in Session TWO, from the same
table. This would cause session 2, to be locked.
Hoping that the "EXECUTION TIME" would increase?

PART 1

1> begin transaction
2> insert table1 values (4, 'D')
3> go
(1 row affected)
...
.... - left it running for a few seconds whilst I ran my
select in session 2

PART 2 - (executed while the transaction is open in
session1)
1> set statistics time on
2> go

Execution Time 0.
Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
time: 0 ms.
1> select * from table1
2> go

Parse and Compile Time 0.
Adaptive Server cpu time: 0 ms.
Parse and Compile Time 0.
Adaptive Server cpu time: 0 ms.

col1 col2
----------- ----
2 B
3 C

Execution Time 0.
Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
time: 20140 ms.

This came back after I executed this in session 1
1> rollback transaction
2> go

EXECUTION TIME was still zero, even with elapsed time =
20140

@@version
---------------
Adaptive Server Enterprise/15.5/EBF 17219 SMP/P/X64/Windows
Server/ase155/2391/64-bit/OPT/Mon Nov 09 14:24:22 2009

AND it also happens on

Adaptive Server Enterprise/15.0.3/EBF 17157
ESD#3/P/x86_64/Enterprise
Linux/ase1503/2726/64-bit/FBO/Fri Feb 5 01:42:20 2010

> On 29 Oct 2010 06:19:11 -0700, Liezl wrote:
>
> Could you give the output from 'select @@version' ?
>
> jay
> >OK I know ASE 15.5 is VERY fast, but EXECUTION TIME keeps
> on >showing as zero - please see below
> >
> >Even with queries running long - is there something that
> I >need to set? This affects WORKSPACE as well.
> >
> >
> >Table: sysobjects scan count 1, logical reads: (regular=7
> >apf=0 total=7),
> >physical reads: (regular=0 apf=0 total=0), apf IOs used=0
> >Total writes for this command: 0
> >
> >Execution Time 0.
> >Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
> >time: 0 ms.
>


Michael Peppler [Team Sybase] Posted on 2010-11-01 04:55:18.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: EXECUTION TIME 0 with set statistics io and set statistics time on
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2010.11.01.05.55.15.431287@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4ccae748.722750@forums.sybase.com> <4ccdd327.352f.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 31 Oct 2010 21:55:18 -0700
X-Trace: forums-1-dub 1288590918 10.22.241.152 (31 Oct 2010 21:55:18 -0700)
X-Original-Trace: 31 Oct 2010 21:55:18 -0700, vip152.sybase.com
Lines: 99
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29681
Article PK: 78910

Execution time is based on the number of server "ticks", and is rounded.
QUite often for quick procs this doesn't show any value. In addition, ASE
has a granularity of 3 ms (for datetime) - and if you do StartTime-
EndTime in monSysStatement you quite often get statements that take 0 ms
to execute.

Michael

On Sun, 31 Oct 2010 12:35:51 -0700, Liezl wrote:

> In my case, when I run any select, even an sp_helpdevice or
> sp_helpdb, I get EXECUTION TIME 0.
> Surely these procs take a few miliseconds?
>
> I played around and tried to hold things up on purpose, to
> see if I could get ANY execution time greater than zero.
>
> In Session ONE, I left an INSERT tran unCommitted for a few
> seconds, while doing a select in Session TWO, from the same
> table. This would cause session 2, to be locked.
> Hoping that the "EXECUTION TIME" would increase?
>
> PART 1
>
> 1> begin transaction
> 2> insert table1 values (4, 'D')
> 3> go
> (1 row affected)
> ...
> .... - left it running for a few seconds whilst I ran my
> select in session 2
>
> PART 2 - (executed while the transaction is open in
> session1)
> 1> set statistics time on
> 2> go
>
> Execution Time 0.
> Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
> time: 0 ms.
> 1> select * from table1
> 2> go
>
> Parse and Compile Time 0.
> Adaptive Server cpu time: 0 ms.
> Parse and Compile Time 0.
> Adaptive Server cpu time: 0 ms.
>
> col1 col2
> ----------- ----
> 2 B
> 3 C
>
> Execution Time 0.
> Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
> time: 20140 ms.
>
> This came back after I executed this in session 1
> 1> rollback transaction
> 2> go
>
> EXECUTION TIME was still zero, even with elapsed time =
> 20140
>
> @@version
> ---------------
> Adaptive Server Enterprise/15.5/EBF 17219 SMP/P/X64/Windows
> Server/ase155/2391/64-bit/OPT/Mon Nov 09 14:24:22 2009
>
> AND it also happens on
>
> Adaptive Server Enterprise/15.0.3/EBF 17157
> ESD#3/P/x86_64/Enterprise
> Linux/ase1503/2726/64-bit/FBO/Fri Feb 5 01:42:20 2010
>
>
>
>> On 29 Oct 2010 06:19:11 -0700, Liezl wrote:
>>
>> Could you give the output from 'select @@version' ?
>>
>> jay
>> >OK I know ASE 15.5 is VERY fast, but EXECUTION TIME keeps
>> on >showing as zero - please see below
>> >
>> >Even with queries running long - is there something that
>> I >need to set? This affects WORKSPACE as well.
>> >
>> >
>> >Table: sysobjects scan count 1, logical reads: (regular=7
>> >apf=0 total=7),
>> >physical reads: (regular=0 apf=0 total=0), apf IOs used=0
>> >Total writes for this command: 0
>> >
>> >Execution Time 0.
>> >Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
>> >time: 0 ms.
>>


Sherlock, Kevin [TeamSybase] Posted on 2010-10-29 15:52:36.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4ccac9cf.3c36.1681692777@sybase.com>
Subject: Re: EXECUTION TIME 0 with set statistics io and set statistics time on
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ccaedc4$1@forums-1-dub>
Date: 29 Oct 2010 08:52:36 -0700
X-Trace: forums-1-dub 1288367556 10.22.241.152 (29 Oct 2010 08:52:36 -0700)
X-Original-Trace: 29 Oct 2010 08:52:36 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29677
Article PK: 78907

Do you have an example with a little more IO, and post the exact script?

<Liezl> wrote in message news:4ccac9cf.3c36.1681692777@sybase.com...
> OK I know ASE 15.5 is VERY fast, but EXECUTION TIME keeps on
> showing as zero - please see below
>
> Even with queries running long - is there something that I
> need to set? This affects WORKSPACE as well.
>
>
> Table: sysobjects scan count 1, logical reads: (regular=7
> apf=0 total=7),
> physical reads: (regular=0 apf=0 total=0), apf IOs used=0
> Total writes for this command: 0
>
> Execution Time 0.
> Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
> time: 0 ms.


J Posted on 2010-11-01 18:28:54.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: EXECUTION TIME 0 with set statistics io and set statistics time on
Reply-To: J@bogusemailAddress.com
Message-ID: <4ccf06c7.270932437@forums.sybase.com>
References: <4ccac9cf.3c36.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Nov 2010 10:28:54 -0800
X-Trace: forums-1-dub 1288636134 10.22.241.152 (1 Nov 2010 10:28:54 -0800)
X-Original-Trace: 1 Nov 2010 10:28:54 -0800, vip152.sybase.com
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29682
Article PK: 78911

On 29 Oct 2010 06:19:11 -0700, Liezl wrote:

Try something like 'select count(*) from master..sysmessages'

Jay

>OK I know ASE 15.5 is VERY fast, but EXECUTION TIME keeps on
>showing as zero - please see below
>
>Even with queries running long - is there something that I
>need to set? This affects WORKSPACE as well.
>
>
>Table: sysobjects scan count 1, logical reads: (regular=7
>apf=0 total=7),
>physical reads: (regular=0 apf=0 total=0), apf IOs used=0
>Total writes for this command: 0
>
>Execution Time 0.
>Adaptive Server cpu time: 0 ms. Adaptive Server elapsed
>time: 0 ms.