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.

Pb with sp_sysmon on NT

2 posts in ,  Windows NT Performance and Tuning Last posting was on 1997-10-31 07:37:28.0Z
Francois Clement Posted on 1997-10-29 17:18:45.0Z
Message-ID: <34576FF4.2723@castsoftware.com>
Date: Wed, 29 Oct 1997 18:18:45 +0100
From: Francois clement <f.clement@castsoftware.com>
Reply-To: f.clement@castsoftware.com
Organization: Cast S.A.
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Subject: Pb with sp_sysmon on NT
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt,sybase.public.sqlserver.performance+tuning
Lines: 102
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:3248 sybase.public.sqlserver.performance+tuning:338
Article PK: 1090682

hi everybody.

Has anyone succeeded in using sp_sysmon on NT box ?
here is my version:

SQL Server/11.0.3/P/PC Intel/Windows NT 3.5/SWR 7305 Rollup/OPT/Fri Jul
18 1997 15:19:35.58

I have a problem regarding the kernel utilization report and Network I/O
management report.
All the numbers are zero except the Total Network I/O Requests
sub-report...High activity occurs
on the sql server and 200 clients are connected using oltp queries.
Is someone has found a workaround in order to get the information ?
Thank you in advance for you help.

best regards,



===============================================================================
Sybase SQL Server System Performance Report
===============================================================================

Run Date Oct 23, 1997
Statistics Cleared at 12:35:39
Statistics Sampled at 12:46:34
Sample Interval 10 min.

===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization:
Engine 0 63.4 %
CPU Yields by Engine per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 0.6 0.1 403
100.0 %
Network Checks
0.0 0.0
0 n/a
Disk I/O Checks
Total Disk I/O Checks 762.4 133.8
499668 n/a
Checks Returning I/O 726.9 127.6 476398
95.3 %
Avg Disk I/Os Returned n/a n/a
0.91590 n/a

===============================================================================
.../...
===============================================================================

Network I/O Management
----------------------

Total Network I/O Requests 60.8 10.7
39821 n/a
Network I/Os Delayed 0.0 0.0
0 0.0 %


Total TDS Packets Received per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
0.0 0.0
0 n/a
------------------------- ------------ ------------ ----------
----------
Total TDS Packets Rec'd 0.0 0.0
0


Total Bytes Received per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
0.0 0.0
0 n/a
------------------------- ------------ ------------ ----------
----------
Total Bytes Rec'd 0.0 0.0
0



-----------------------------------------------------------------------------

Total TDS Packets Sent per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
0.0 0.0
0 n/a
------------------------- ------------ ------------ ----------
----------
Total TDS Packets Sent 0.0 0.0
0


Total Bytes Sent per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
0.0 0.0
0 n/a
------------------------- ------------ ------------ ----------
----------
Total Bytes Sent 0.0 0.0
0


=============================== End of Report
=================================
(return status = 0)


Xavier Haffreingue Posted on 1997-10-31 07:37:28.0Z
Message-ID: <34598AB8.43F8CE02@sybase.com>
Date: Fri, 31 Oct 1997 08:37:28 +0100
From: Xavier Haffreingue <xavierh@sybase.com>
Organization: Sybase France
X-Mailer: Mozilla 4.03 [en] (X11; I; SunOS 5.5.1 sun4u)
MIME-Version: 1.0
CC: bricew@sybase.com
Subject: Re: Pb with sp_sysmon on NT
References: <34576FF4.2723@castsoftware.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt,sybase.public.sqlserver.performance+tuning
Lines: 108
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:3247 sybase.public.sqlserver.performance+tuning:337
Article PK: 1090677

As far as i know, engineering is working on it, fyi - this problem does
not appears in ASE 11.5.

Feel free to come back to me for further explanations.

Regards,
Xavier Haffreingue, Sybase France

Francois clement wrote:
>
> hi everybody.
>
> Has anyone succeeded in using sp_sysmon on NT box ?
> here is my version:
>
> SQL Server/11.0.3/P/PC Intel/Windows NT 3.5/SWR 7305 Rollup/OPT/Fri Jul
> 18 1997 15:19:35.58
>
> I have a problem regarding the kernel utilization report and Network I/O
> management report.
> All the numbers are zero except the Total Network I/O Requests
> sub-report...High activity occurs
> on the sql server and 200 clients are connected using oltp queries.
> Is someone has found a workaround in order to get the information ?
> Thank you in advance for you help.
>
> best regards,
>
> ===============================================================================
> Sybase SQL Server System Performance Report
> ===============================================================================
>
> Run Date Oct 23, 1997
> Statistics Cleared at 12:35:39
> Statistics Sampled at 12:46:34
> Sample Interval 10 min.
>
> ===============================================================================
> Kernel Utilization
> ------------------
> Engine Busy Utilization:
> Engine 0 63.4 %
> CPU Yields by Engine per sec per xact count %
> of total
> ------------------------- ------------ ------------ ----------
> ----------
> Engine 0 0.6 0.1 403
> 100.0 %
> Network Checks
> 0.0 0.0
> 0 n/a
> Disk I/O Checks
> Total Disk I/O Checks 762.4 133.8
> 499668 n/a
> Checks Returning I/O 726.9 127.6 476398
> 95.3 %
> Avg Disk I/Os Returned n/a n/a
> 0.91590 n/a
>
> ===============================================================================
> .../...
> ===============================================================================
>
> Network I/O Management
> ----------------------
>
> Total Network I/O Requests 60.8 10.7
> 39821 n/a
> Network I/Os Delayed 0.0 0.0
> 0 0.0 %
>
>
> Total TDS Packets Received per sec per xact count %
> of total
> ------------------------- ------------ ------------ ----------
> ----------
> 0.0 0.0
> 0 n/a
> ------------------------- ------------ ------------ ----------
> ----------
> Total TDS Packets Rec'd 0.0 0.0
> 0
>
>
> Total Bytes Received per sec per xact count %
> of total
> ------------------------- ------------ ------------ ----------
> ----------
> 0.0 0.0
> 0 n/a
> ------------------------- ------------ ------------ ----------
> ----------
> Total Bytes Rec'd 0.0 0.0
> 0
>
>
>
> -----------------------------------------------------------------------------
>
> Total TDS Packets Sent per sec per xact count %
> of total
> ------------------------- ------------ ------------ ----------
> ----------
> 0.0 0.0
> 0 n/a
> ------------------------- ------------ ------------ ----------
> ----------
> Total TDS Packets Sent 0.0 0.0
> 0
>
>
> Total Bytes Sent per sec per xact count %
> of total
> ------------------------- ------------ ------------ ----------
> ----------
> 0.0 0.0
> 0 n/a
> ------------------------- ------------ ------------ ----------
> ----------
> Total Bytes Sent 0.0 0.0
> 0
>
>
> =============================== End of Report
> =================================
> (return status = 0)