Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3023) IO Read and Writes Bytes/Sec Exploded out of proportion. Degrade System Performance

[Andrew D. <ad...@gf...>]

Andrew Dimech - Software Developer
GFI Software - www.gfi.com

-----Original Message-----
From: Vlad Khorsun (JIRA) [mailto:tr...@fi...] 
Sent: 02 June 2010 15:21
To: Andrew Dimech
Subject: [FB-Tracker] Commented: (CORE-3023) IO Read and Writes
Bytes/Sec Exploded out of proportion. Degrade System Performance


    [
http://tracker.firebirdsql.org/browse/CORE-3023?page=com.atlassian.jira.
plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21109#act
ion_21109 ] 

Vlad Khorsun commented on CORE-3023:
------------------------------------

What queries should i run to see the issue ?

> IO Read and Writes Bytes/Sec Exploded out of proportion. Degrade
System Performance
>
------------------------------------------------------------------------
-----------
>
>                 Key: CORE-3023
>                 URL: http://tracker.firebirdsql.org/browse/CORE-3023
>             Project: Firebird Core
>          Issue Type: Bug
>      Security Level: Developers(Visible only to project developers
(and administrators)) 
>          Components: Engine
>    Affects Versions: 2.5 RC2
>         Environment: Win XP 32bit, Core 2 DUO 2.4GHz, 2GB RAM
>            Reporter: Andrew Dimech
>         Attachments: FB Schema.sql
>
>
> We are considering moving to Engine 2.5 and carried out a test to
compare Engine 2.1.1 with Engine 2.5 RC2.
> The test consists of a executing 7 Stored Procedures from a .NET
application. These procedures consists of just select statements and
they return a total of  6700 records. The test called these stored
procedures a number of times (with different parameter values) for a
period of 4minutes.
> From Performance Counter we added the following counters for the (.NET
application) process we were monitoring:
> The results were shocking. These are the average Bytes/sec values over
4minutes.
> Engine 2.1.1
> IO Read Bytes/Sec	 164,250 
> IO Write Bytes/Sec	 201,172 
> Engine 2.5 RC2
> IO Read Bytes/Sec	 3,879,708 
> IO Write Bytes/Sec	 3,939,374 
> The IO in Engine 2.5 is around 23 times higher. This would result in
degrading system performance. Is this a known issue? are you planning to
handle it? 
> Attached is the database schema used. For simplicity I only kept the
stored procedures used during the test. The stored procedures are called
in this order:
> GETMESSAGEUPDATESHDRFA
> GETMESSAGEUPDATESADDRFA
> GETMESSAGEUPDATESATTACHFA
> GETMESSAGEUPDATESOWNERSFA
> GETMESSAGEUPDATESTAGSFA
> GETDELETEDMESSAGEUPDATESFA
> GETTAGUPDATESFA
> Thanks,
> Andrew

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

        



DISCLAIMER
The information contained in this electronic mail may be confidential or
legally privileged. It is for the intended recipient(s) only. Should you
receive this message in error, please notify the sender by replying to
this mail. Unless expressly stated, opinions in this message are those
of the individual sender and not of GFI. Unauthorized use of the
contents is strictly prohibited. While all care has been taken, GFI is
not responsible for the integrity of the contents of this electronic
mail and any attachments included within.  

This mail was checked for viruses by GFI MailSecurity. 
GFI also develops anti-spam software (GFI MailEssentials), a fax server (GFI FAXmaker), and network security and management software (GFI LANguard) - www.gfi.com