SQL Server Performance

Access to a Database freeze for 10s to 2 minutes

Discussion in 'Performance Tuning for DBAs' started by Ctricaud, May 17, 2005.

  1. Ctricaud New Member

    Hi,<br /><br />I am using sql server 2000 standard edition with several databases on it.<br /><br />Since few weeks, it appears that one of the database stop delivering response for 10s to 2 minutes from time to time during the day. Meanwhile, the other databases work fine, and there is no alert on the server of anykind.<br /><br />I am a trace to find out what's happening, and found that during the time the database is unavalaible, a lot of audit login and audit logout event are recorded. In the same time, it appears on the log of our firewall (blakice) that there is some attack on sql probe access.<br /><br />Has anyone had the same problem and have fixed it? I am not sure that the problem comes from the attacks since only one database is involved, and since the firewall makes its job blocking the inbound packets.<br /><br />I am becoming crazy with this issue, and my users too... Any help will be very help full...<br /><br />Here is a sample of the trace, not very readable...<br /><br /><b>Audit Logout</b>Internet Information Servicessa52840X235x235782005-05-17 19:29:52.233<br /><b>RPC<img src='/community/emoticons/emotion-7.gif' alt=':S' />tarting</b>exec sp_cursor 180150000, 40, 22Internet Information Servicessa52840X235x235722005-05-17 19:29:52.250<br /><b>Audit Login</b>-- network protocol: LPC<br />set quoted_identifier on<br />set implicit_transactions off<br />set cursor_close_on_commit off<br />set ansi_warnings on<br />set ansi_padding on<br />set ansi_nulls on<br />set concat_null_yields_null on<br />set language Français<br />set dateformat dmy<br />set datefirst 1<br />Internet Information Servicessa52840X235x2350X20002838F410782005-05-17 19:29:52.250<br /><b>SQL:BatchStarting</b>SELECT thread_id,id,thread_parent,pseudo,subject,mesdate2,forumID,mesbody,lu FROM ForumMesTbl WHERE (thread_parent&lt;&gt;0) AND (forumID=4) AND (thread_id = 30315) AND Valide&lt;&gt;0Internet Information Servicessa52840X235x235782005-05-17 19:29:52.250<br /><b>Audit Logout</b>Internet Information Servicessa52840X235x235782005-05-17 19:29:52.250<br />RPC<img src='/community/emoticons/emotion-7.gif' alt=':S' />tartingexec sp_cursor 180150000, 40, 23Internet Information Servicessa52840X235x235722005-05-17 19:29:52.250<br />Audit Login-- network protocol: LPC<br />set quoted_identifier on<br />set implicit_transactions off<br />set cursor_close_on_commit off<br />set ansi_warnings on<br />set ansi_padding on<br />set ansi_nulls on<br />set concat_null_yields_null on<br />set language Français<br />set dateformat dmy<br />set datefirst 1<br />Internet Information Servicessa52840X235x2350X20002838F410782005-05-17 19:29:52.267<br /><b>SQL:BatchStarting</b>SELECT thread_id,id,thread_parent,pseudo,subject,mesdate2,forumID,mesbody,lu FROM ForumMesTbl WHERE (thread_parent&lt;&gt;0) AND (forumID=4) AND (thread_id = 27043) AND Valide&lt;&gt;0Internet Information Servicessa52840X235x235782005-05-17 19:29:52.267<br /><b>Audit Logout</b>Internet Information Servicessa52840X235x235782005-05-17 19:29:52.267<br />
  2. satya Moderator

    Try to recompile the involved stored procedures, reindex the indexes for intermittent performance gain. Also check for any blocking during this code execution, if you feel there is kind of intrusion then run traces on the operating system also using the firewall software.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Ctricaud New Member

    Thanks for your answer. I will try to do that. But however, can you explain me why I have hundred of audit login and audit logout the one after the others? Could not this make an infinite loop that may cause the database to stop for a while?
  4. satya Moderator

    That seems to occurring from the application side as how you manage the open/close of connection calls to the database. If you are using standard SQLServerProfilerStandard.tdf template of profiler, then you will see these events. For more asessment try capturing profiler using SQLServerProfilerTSQL_Duration template.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. Ctricaud New Member

    Thanks for your reply, but it did not help: I have recompile the stored procedures, defrag the index, have look at the tarce and eve generate an index analysis, but nothing change: the sql engine stop for 1 or 2 minuts to compiles statement for a specific database, and continue to work for the others database.

    What is very surprising is that this involve only one database (we have the more or less same application running on different database) and that it appears two weeks ago for no reason, no changed were made to the code or to the database...

    If anyone can help, this could be very appreciate...
  6. derrickleggett New Member

    sa

    You have something from IIS logging in as "sa"????? If so, you need to change it immediately. Either way, you need to change the sa password.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  7. Ctricaud New Member

    The password has been changed and is modified every week.

    Thanks for your post, but I don't think this is part of the problem, is it?

    Christophe
  8. satya Moderator

    Though it helps on the security aspects, anyway capture the PERFMON counters alongwith PROFILER templates for further assessment. Check the referred query execution plan for further information.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  9. Ctricaud New Member

    I did that, and chack a lot of the perfom datas, and notice nothing special, only that a lot of query are waiting for execution though none of transact on the sql database are executed. All others parameters seems no to change...
  10. Argyle New Member

    Have you checked for blocking issues?
    http://support.microsoft.com/default.aspx?scid=kb;en-us;271509
    http://www.sqlteam.com/item.asp?ItemID=21737

    You can also run this waitstate script to check what else could be causing issues:


    -- simple waitstate script
    -- GertD@SQLDev.Net
    --
    -- List of Wait Types: Seehttp://sqldev.net/misc/WaitTypes.htm
    --
    if ((object_id('waitstats') is not null) and
    (objectproperty(object_id('waitstats'), 'IsUserTable') = 1))
    drop table waitstats

    create table waitstats (
    wait_type varchar(80),
    requests numeric(18, 1),
    wait_time numeric (18 ,1),
    signal_wait_time numeric(18, 1),
    time_stamp datetime default getdate()
    )

    declare @start int,
    @finish int
    select @start = 1,
    @finish = 10

    dbcc sqlperf(waitstats,clear) -- clear out wait statistics

    while (@start < @finish)
    begin
    begin transaction
    insert into waitstats(wait_type, requests, wait_time,signal_wait_time)
    exec ('dbcc sqlperf(waitstats)')
    commit

    select @start = @start + 1
    waitfor delay '00:00:10' -- every 10 seconds
    end

    declare @begin_time datetime,
    @end_time datetime,
    @total_wait numeric(18, 1)

    select @begin_time = min(time_stamp),
    @end_time = max(time_stamp)
    from waitstats where wait_type = 'Total'

    --- subtract waitfor, sleep, and resource_queue from Total
    select @total_wait = sum(wait_time) + 1
    from waitstats
    where wait_type not in ('WAITFOR', 'SLEEP', 'RESOURCE_QUEUE', 'Total',
    '***total***')
    and time_stamp = @end_time

    -- insert adjusted totals, rank by percentage descending
    insert into waitstats values('***total***', 0, @total_wait, @total_wait,
    @end_time)

    -- reporting
    select @begin_time as [begin time],
    @end_time as [end time],
    datediff(mi, @begin_time, @end_time) as [duration in min]

    select wait_type,
    wait_time,
    percentage = cast(100 * wait_time / @total_wait as numeric(18,1))
    from waitstats
    where wait_type not in ('WAITFOR', 'SLEEP', 'RESOURCE_QUEUE', 'Total')
    and time_stamp = @end_time
    order by percentage desc

    Btw if you have a lot of connections coming in against the sql account named "probe" and others this is a virus/trojan that should be dealt with. It can cause major havoc.
  11. Ctricaud New Member

    Thanks for this routine. What is shows is:

    OLEDB2399907840.0100.0
    ***total***2399908514.0100.0
    MISCELLANEOUS.0.0
    LCK_M_SCH_S.0.0
    LCK_M_SCH_M.0.0
    LCK_M_S.0.0
    LCK_M_U.0.0


    I don't understand precisely this OLEDB process since I use only ado...

    Christophe
    Paris, France
  12. Argyle New Member

    Did you really run the script with the default settings (1 min 40 sec)? Seems like an awful loot of time waiting fro OLEDB, way out of scale. Checkhttp://www.sqldev.net/articles/WaitTypes.htm for details about OLEDB wait type.

    ADO uses OLEDB under the covers. I would look for any connections holding open transactions and blocking others in the database or if any distributed queries are going on to other machines.

    I run the default script on a heavy loaded web system and got:


    ***total***3193.0100.0
    WRITELOG2129.066.7
    NETWORKIO342.010.7
    PAGEIOLATCH_SH282.08.8
    PAGELATCH_EX157.04.9
    PAGELATCH_UP109.03.4
    LCK_M_IX63.02.0
    OLEDB 47.01.5
    IO_COMPLETION32.01.0
    PAGELATCH_SH16.0.5
    PAGEIOLATCH_EX15.0.5
    PAGEIOLATCH_DT.0.0
    TRAN_MARK_NL.0.0


    Thats about 3 seconds wait time where OLEDB stands for 0.05 seconds.
  13. Ctricaud New Member

    Yes I run then entire process. Several time and more or less the same answer...

    I am very surprise and this amount of time seems to be a mistake since the system is runnig for 1/10th of this time.

    However, could this be part of the replication process? Since I have no open transaction (as far as i know and that SQL is not opening one behind my back) neither distributed queries: the database is rather simple yet very loaded.

    The explanation on signification of the wait time does not help me, and I have no I/O bottleneck (i checked this). I am becoming crazy with this thing...

    Christophe
    Paris, France
  14. Ctricaud New Member

    Correction, Once I had quite the same table than yours...
  15. Ctricaud New Member

    This is the result I have while the database was unavailable during all the procedure:

    ***total***1190.0100.0
    NETWORKIO937.078.7
    WRITELOG204.017.1
    PAGEIOLATCH_SH32.02.7
    PAGEIOLATCH_EX16.01.3
    PAGEIOLATCH_DT.0.0
    TRAN_MARK_NL.0.0


    So it seems that this is not a wait problem?
  16. derrickleggett New Member

    It still could be. Setup a trace in performance monitor to capture:<br />--Network Interface<img src='/community/emoticons/emotion-3.gif' alt=':O' />utbound Queue Length<br />--Physical Disk:Write Queue Length<br />--Physical Disk:Read Queue Length<br />--SQLInstance:Cache Manager:Cache Hit Ratio<br />--SQLInstance:Buffer Manager:Buffer cache Hit Ratio<br />--SQLInstance:Memory Manager:Memory Grants Outstanding<br /><br />Save the profile as a .csv file and run every 5 seconds. See what those numbers are like while this is happening. I'm really interested in the network and physical disk counters with the wait types you were having during the procedure. Are the wait times fairly consistent when this runs?<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
  17. Ctricaud New Member

    Ok i will do that and send it by email to you. Maybe later in the day as the specific database blocks later in the day usualy.

    For the wait list it is fairly consistent in the afternoon, this morning (i am in France), I had

    OLEDB809196288.0100.0
    ***total***809197243.0100.0
    MISCELLANEOUS.0.0
    LCK_M_SCH_S.0.0

    with no idea of this OLEDB and what the numbers are and then, I ran the procedure again:

    OLEDB1328965632.0100.0
    ***total***1328982590.0100.0
    MISCELLANEOUS.0.0
    LCK_M_SCH_S.0.0
    LCK_M_SCH_M.0.0
    LCK_M_S.0.0

    well, I do not know where thios Oledb comes from and what is the meaning of the numbers...

    Thanks for your help...
  18. derrickleggett New Member

    Please post the results. I prefer responding in a forum format. That way you also get multiple people with input.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  19. Ctricaud New Member

    Ok, here you are, this is a trace with a problem when the asp request queue grow for a while:<br /><br />I don't know if you can read this, I put a copy of the excel here, because the titles are in french, and a copy of the original CSV file...<br /><br />I did not notics anything strange, beyond the fact that de monitor does not want to monitor the physical disk read queue length. Is it due to Raid 5? I don't know...<br /><br />Copy of the CSV File<br /><br />"(PDH-CSV 4.0) (Paris, Madrid (heure d'été))(-120)","\X235Active Server Pages (ASP)Nb de requêtes en attente","\X235Active Server Pages (ASP)Nb de requêtes/s","\X235Disque physique(0 C: D<img src='/community/emoticons/emotion-1.gif' alt=':)' />Long. moy. de file d'attente écriture disque","\X235Interface réseau(Carte réseau 3Com EtherLink XL 10_100 PCI pour gestion intégrale de PC [3C905C-TX] - Miniport d'ordonnancement de paquets)Longueur de la file d'attente de sortie","\X235Interface réseau(Broadcom NetXtreme Gigabit Ethernet - Miniport d'ordonnancement de paquets)Longueur de la file d'attente de sortie","\X235Interface réseau(MS TCP Loopback interface)Longueur de la file d'attente de sortie","\X235Processeur(_Total)% Temps processeur","\X235SQLServer : Bases de données(dbchatphiletnatte)Transactions/seconde","\X235SQLServer : Gestionnaire de Cache(_Total)Taux de présence dans le cache","\X235SQLServer : Gestionnaire de tamponsTaux de présence dans le cache des tampons","\X235SQLServer : Gestionnaire mémoireDemandes de mémoire en attente"<br />"05/20/2005 08:31:21.402","0"," "," ","0","0","0"," "," ","81.118616766830328","99.839021249195099","0"<br />"05/20/2005 08:31:26.402","0","8.6099673380491559","1.7009799999999999","0","0","0","11.171876000000003","0.20023179855928269","81.118843958109039","99.680170575692955","0"<br />"05/20/2005 08:31:31.402","0","4.1936832571733635","2.1958799999999998","0","0","0","14.140624000000003","0.1996992027225411","81.118826027903751","99.710249909453097","0"<br />"05/20/2005 08:31:36.402","0","7.4003750418268366","1.04826","0","0","0","19.374999999999996","1.200060817593541","81.118924320684144","99.712276214833764","0"<br />"05/20/2005 08:31:41.402","0","9.2184621082044895","1.5049600000000001","0","0","0","11.015626000000001","0.20040135017835847","81.119068280115343","99.835201054713252","0"<br />"05/20/2005 08:31:46.402","0","1.9997160962774208","2.3228200000000001","0","0","0","7.8125","0.19997160962774208","81.11912440827318","99.809451219512198","0"<br />"05/20/2005 08:31:51.402","0","6.9989182689173202","3.5061800000000001","0","0","0","8.7500000000000018","1.7997218405787394","81.119136488359118","99.738903394255871","0"<br />"05/20/2005 08:31:56.402","0","11.189751531221717","1.4431","0","0","0","11.093750000000002","1.3987189414027146","81.119389445895735","99.804113614103812","0"<br />"05/20/2005 08:32:01.402","2","6.8003474398515102","2.4722200000000001","0","0","0","11.953124000000004","1.0000510940958103","81.119081128676868","99.811912225705328","0"<br />"05/20/2005 08:32:06.417","0","4.1944788782179359","2.2174903426791279","0","1","0","9.1900311526479701","0.79894835775579731","81.119178306021595","99.759284731774414","0"<br />"05/20/2005 08:32:11.417","0","10.176609428616711","1.9923200000000001","0","0","0","16.093749999999996","0.99770680672712853","81.119346475071836","99.822380106571941","0"<br />"05/20/2005 08:32:16.417","0","6.7963674560920886","1.37026","0","0","0","17.1875","0.39978632094659344","81.119325097755379","99.843847595252967","0"<br />"05/20/2005 08:32:21.417","0","4.6110707997331373","0.94267999999999996","0","0","0","18.671875999999997","2.0048133911883208","81.119338927786302","99.859204505455821","0"<br />"05/20/2005 08:32:26.417","0","10.79197290026476","1.12236","0","0","0","20.3125","2.3982162000588354","81.119581851965108","99.871216999356079","0"<br />"05/20/2005 08:32:31.417","0","5.8003755783211526","1.1999","0","0","0","19.999999999999996","0.60003885292977432","81.119696993902807","99.859005992245329","0"<br />"05/20/2005 08:32:36.417","1","7.5974143468726849","1.27274","0","0","0","22.812500000000004","2.9989793474497444","81.119770248286216","99.833333333333329","0"<br />"05/20/2005 08:32:41.417","0","11.017779379096122","0.78559999999999997","0","0","0","33.203123999999995","1.201939568628668","81.119720001270551","99.848885530789573","0"<br />"05/20/2005 08:32:46.417","0","5.1870925040008817","1.0046600000000001","0","0","0","11.093750000000002","0.99751778923093881","81.119856970372439","99.875583203732504","0"<br />"05/20/2005 08:32:51.417","0","4.4019456798053964","0.48049999999999998","0","0","0","14.218750000000002","1.8007959599203895","81.11970360568381","99.847931873479325","0"<br />"05/20/2005 08:32:56.417","0","8.01135197545476","0.021219999999999999","0","0","0","9.6093760000000028","0.40056759877273795","81.119886353399252","99.837067209775967","0"<br />"05/20/2005 08:33:01.417","0","6.9880873439125697","0.0068199999999999997","0","0","0","11.953124000000004","0.99829819198750991","81.119808257455674","99.842890809112333","0"<br />"05/20/2005 08:33:06.417","0","3.2032854796119619","0.0054999999999999997","0","0","0","6.25","2.0020534247574764","81.1199085872301","99.856424982053127","0"<br />"05/20/2005 08:33:11.417","0","6.8056692465856017","0.016799999999999999","0","0","0","10.234376000000001","1.2010004552798121","81.120029167793845","99.881058578650013","0"<br />"05/20/2005 08:33:16.417","0","6.8030084136593318","0.0081799999999999998","0","0","0","8.9062500000000036","0.80035393101874486","81.120079612331935","99.881971082915314","0"<br />"05/20/2005 08:33:21.417","0","4.7918204710457912","0.0065199999999999998","0","0","0","6.25","1.7969326766421716","81.120170649510086","99.871465295629818","0"<br />"05/20/2005 08:33:26.417","0","5.0061185768292615","0.013860000000000001","0","0","0","6.0937499999999982","0.40048948614634089","81.120364934370031","99.859303552585303","0"<br />"05/20/2005 08:33:31.417","0","11.981792262724612","0.0070000000000000001","0","0","0","7.1875000000000018","2.1966619148328457","81.120555685820221","99.864176570458412","0"<br />"05/20/2005 08:33:36.417","0","5.6014296150912832","0.0037399999999999998","0","0","0","15.937500000000004","1.8004595191364838","81.120570016821731","99.763406940063092","0"<br />"05/20/2005 08:33:41.417","0","7.6107959891599792","0.0044400000000000004","0","0","0","14.296874000000004","2.002841049778942","81.120649733628113","99.831309041835354","0"<br />"05/20/2005 08:33:46.417","0","8.1876097789205833","0.00198","0","0","0","11.875000000000002","0.19969779948586788","81.120642097774947","99.812382739211998","0"<br />"05/20/2005 08:33:51.417","0","6.8109722290842036","0.0043800000000000002","0","0","0","5.6250000000000018","1.0016135631006182","81.120745201095602","99.830966869506426","0"<br />"05/20/2005 08:33:56.417","0","7.8065260381457495","0.00192","0","0","0","5.8593760000000046","0.40033466862285894","81.120798095870043","99.874253379440432","0"<br />"05/20/2005 08:34:01.417","0","7.1848816751915505","0.0041399999999999996","0","0","0","9.4531240000000025","1.7962204187978876","81.120762848782917","99.848622464426285","0"<br />"05/20/2005 08:34:06.417","0","2.00207016534684","0.0035999999999999999","0","0","0","7.109376000000001","1.2012420992081041","81.120809850968229","99.848484848484858","0"<br />"05/20/2005 08:34:11.417","0","2.2031229658332574","0.00164","0","0","0","7.1875000000000018","0.40056781196968316","81.120868411268958","99.815583218072845","0"<br />"05/20/2005 08:34:16.417","1","1.3978841669704396","0.0023400000000000001","0","0","0","5.0000000000000044","2.1966751195249765","81.12081859012666","99.848999622499051","0"<br />"05/20/2005 08:34:21.417","0","15.218607380805187","0.0040800000000000003","0","0","0","15.625","1.401713837705741","81.121054878024438","99.880382775119614","0"<br />"05/20/2005 08:34:26.417","0","6.7883986626569657","0.0039399999999999999","0","0","0","11.484373999999997","0.79863513678317244","81.12104816659145","99.882075471698116","0"<br />"05/20/2005 08:34:31.417","0","4.6065548994302548","0.0080000000000000002","0","0","0","6.8749999999999982","0.2002849956274024","81.121071857293174","99.889776798015987","0"<br />"05/20/2005 08:34:36.417","0","12.578458751355109","0.0046600000000000001","0","0","0","10.234376000000001","1.5972646033466804","81.121286382967071","99.85945186226283","0"<br />"05/20/2005 08:34:41.417","0","3.0042800017574187","0.0053600000000000002","0","0","0","9.4531240000000025","1.001426667252473","81.121291035741848","99.853854585312391","0"<br />"05/20/2005 08:34:46.417","0","5.6035648201177812","0.00316","0","0","0","4.9218760000000028","0.80050926001682599","81.121250307891174","99.860675722744688","0"<br />"05/20/2005 08:34:51.417","0","11.979560957427244","0.01264","0","0","0","10.312500000000002","0.19965934929045409","81.121473999540058","99.849624060150376","0"<br />"05/20/2005 08:34:56.417","0","7.4119369048713208","0.0041000000000000003","0","0","0","9.9999999999999982","1.0016130952528812","81.121503049343758","99.850567842199638","0"<br />"05/20/2005 08:35:01.417","0","6.2051709929286414","0.0071599999999999997","0","0","0","11.484373999999997","0.40033361244700916","81.121337571220991","99.870340356564029","0"<br />"05/20/2005 08:35:06.417","0","10.374191904628967","0.0077999999999999996","0","0","0","33.75","1.7955332142627058","81.121337367722006","99.864956110735989","0"<br />"05/20/2005 08:35:11.417","0","4.0025568844341768","0.0046800000000000001","0","0","0","12.812500000000004","1.6010227537736705","81.121238117420887","99.813142323263776","0"<br />"05/20/2005 08:35:16.417","0","2.2035492784763862","0.00726","0","0","0","5.7812500000000044","0.80129064671868599","81.121297152499466","99.781386633354145","0"<br />"05/20/2005 08:35:21.417","0","8.9864367452522256","0.0043","0","0","0","9.7656260000000046","1.19819156603363","81.121482886168891","99.770992366412216","0"<br />"05/20/2005 08:35:26.417","0","9.6155144063012568","0.0022000000000000001","0","0","0","6.953123999999999","1.2019393007876571","81.121529456748291","99.808612440191396","0"<br />"05/20/2005 08:35:31.417","0","3.1950502085407955","0.0063200000000000001","0","0","0","9.2968759999999975","0.39938127606759943","81.121594349095446","99.827188940092171","0"<br />"05/20/2005 08:35:36.417","0","9.6139816288061457","0.0024599999999999999","0","0","0","6.5625000000000044","0.40058256786692276","81.121720676684532","99.799465240641723","0"<br />"05/20/2005 08:35:41.417","0","7.5870662034409015","0.0022000000000000001","0","0","0","8.8281240000000043","0.59897891079796595","81.121858784079947","99.813722446445212","0"<br />"05/20/2005 08:35:46.417","0","5.4076697616488341","0.0054599999999999996","0","0","0","6.7968759999999957","2.2031247177087843","81.121865233223772","99.815781393920787","0"<br />"05/20/2005 08:35:51.417","0","7.0085416370369407","0.0041799999999999997","0","0","0","4.4531239999999972","0.80097618708993612","81.12200305495881","99.838813668600906","0"<br />"05/20/2005 08:35:56.417","0","3.5931495674230383","0.00248","0","0","0","4.6093759999999984","0.79847768164956412","81.122008080246275","99.838969404186798","0"<br />"05/20/2005 08:36:01.417","0","4.202700053281629","0.0087399999999999995","0","0","0","9.9218739999999972","1.6010285917263347","81.121931369758983","99.805321219987022","0"<br />"05/20/2005 08:36:06.417","0","9.4133582967986769","0.0045399999999999998","0","0","0","7.3437500000000044","2.4034106289698749","81.12208462326555","99.80537173997665","0"<br />"05/20/2005 08:36:11.417","0","8.3873405202119713","0.0019599999999999999","0","0","0","10.390626000000003","1.1981915028874246","81.122181091245466","99.824499824499824","0"<br />"05/20/2005 08:36:16.417","0","5.4076666284127155","0.0023999999999999998","0","0","0","6.3281240000000016","2.8039752888065932","81.122177022383894","99.829234972677597","0"<br />"05/20/2005 08:36:21.417","0","8.9864214283260928","0.0055199999999999997","0","0","0","6.8749999999999982","0.99849126981401037","81.122336609840801","99.828178694158083","0"<br />"05/20/2005 08:36:26.417","0","3.6051095322581905","0.00264","0","0","0","7.3437500000000044","1.0014193145161641","81.122351953441168","99.840255591054316","0"<br />"05/20/2005 08:36:31.417","0","4.999281253821998","0.00232","0","0","0","8.3593759999999957","0.99985625076439966","81.122410481818122","99.8455359901143","0"<br />"05/20/2005 08:36:36.417","0","9.1861187293706568","0.0016199999999999999","0","0","0","6.4843740000000043","0.5990946997415646","81.122646531664444","99.783883914788518","0"<br />"05/20/2005 08:36:41.417","0","6.4040771091974902","0.0040400000000000002","0","0","0","10.234376000000001","1.8011466869617943","81.122705338758536","99.830623306233051","0"<br />"05/20/2005 08:36:46.417","0","3.8053859874857543","0.0035000000000000001","0","0","0","7.3437500000000044","1.6022677842045281","81.122740469908763","99.877675840978597","0"<br />"05/20/2005 08:36:51.417","0","6.5900500961828055","0.0042199999999999998","0","0","0","6.8749999999999982","0.39939697552623066","81.122888009663711","99.829176631363168","0"<br />"05/20/2005 08:36:56.417","0","5.8092748863473149","0.0039399999999999999","0","0","0","10.859373999999999","0.60095947100144631","81.123062290048651","99.806255189593145","0"<br />"05/20/2005 08:37:01.417","0","5.9887150872622072","0.0033","0","0","0","13.437500000000002","0.59887150872622064","81.122953278906607","99.82870846180198","0"<br />"05/20/2005 08:37:06.417","0","6.2087389860757769","0.0053200000000000001","0","0","0","7.7343759999999984","0.80112761110655184","81.123157472744893","99.859845830413448","0"<br />"05/20/2005 08:37:11.417","0","5.6047209948959553","0.036420000000000001","0","0","0","8.59375","0.60050582088170956","81.123299218880931","99.872326843281201","0"<br />"05/20/2005 08:37:16.417","0","3.792023919202816","0.0032399999999999998","0","0","0","12.187499999999996","0.59874061882149721","81.123259667149668","99.880845993446528","0"<br />"05/20/2005 08:37:21.417","0","7.4076335289083177","0.010500000000000001","0","0","0","13.359374000000003","0.80082524636846675","81.123425930642995","99.865455768583928","0"<br />"05/20/2005 08:37:26.417","0","11.814300222255717","0.011900000000000001","0","0","0","10.390626000000003","1.601939013187216","81.123591939874757","99.858607281724986","0"<br />"05/20/2005 08:37:31.417","0","6.184713239835367","0.0065599999999999999","0","0","0","18.984374000000003","1.3965481509305668","81.123628285031288","99.718837863167764","0"<br />"05/20/2005 08:37:36.417","5","4.0056796359291589","0.04462","0","0","0","20.3125","2.2031237997610371","81.123659416053783","99.82014388489209","0"<br />"05/20/2005 08:37:41.417","0","13.216140683586223","0.0055399999999999998","0","0","0","25.468749999999996","0.80097822324764989","81.12373958800174","99.731092436974791","0"<br />"05/20/2005 08:37:46.417","0","4.7908961885464301","0.0046600000000000001","0","0","0","10.234376000000001","1.1977240471366075","81.123754056646064","99.694749694749703","0"<br />"05/20/2005 08:37:51.417","0","3.8061392763812063","0.00362","0","0","0","9.8437499999999964","0.60096935942861152","81.12384252568765","99.780380673499266","0"<br />"05/20/2005 08:37:56.417","0","10.581912912159821","0.0054400000000000004","0","0","0","14.140624000000003","0.5989762025750841","81.124066118196154","99.877450980392155","0"<br />"05/20/2005 08:38:01.417","0","3.4055052894454407","0.0043800000000000002","0","0","0","13.359376000000001","0.80129536222245668","81.123563251184095","99.804534792806876","0"<br />"05/20/2005 08:38:06.417","0","4.1936549516040937","0.0045399999999999998","0","0","0","5.46875","0.39939570967658039","81.123610287820227","99.786019971469329","0"<br />"05/20/2005 08:38:11.417","0","7.8110822342204154","0.01158","0","0","0","12.734374000000004","0.80113663940722213","81.123799618587086","99.80909958638243","0"<br />"05/20/2005 08:38:16.417","0","8.9863697678066554","0.0065199999999999998","0","0","0","9.9218759999999957","0.79878842380503612","81.123392545847409","99.612152553329025","0"<br />"05/20/2005 08:38:21.417","0","3.6058263019712919","0.0055399999999999998","0","0","0","5.1562499999999956","1.6025894675427963","81.123288682855431","99.617224880382764","0"<br />"05/20/2005 08:38:26.417","0","8.1844461913917019","0.0043400000000000001","0","0","0","9.1406239999999972","1.5969651105154541","81.123360468329878","99.569274946159368","0"<br />"05/20/2005 08:38:31.417","0","5.208401530683668","0.00166","0","0","0","7.5781259999999957","0.60096940738657711","81.1234916641626","99.587061252580867","0"<br />"05/20/2005 08:38:36.417","0","9.011036173435123","0.021659999999999999","0","0","0","8.59375","0.40049049659711655","81.123527043964955","99.792346484722643","0"<br />"05/20/2005 08:38:41.417","0","7.9832327690220737","0.0090399999999999994","0","0","0","5.7031240000000043","1.1974849153533109","81.123700073166333","99.806362378976488","0"<br />"05/20/2005 08:38:46.417","0","6.2087878476088934","0.0024199999999999998","0","0","0","8.671876000000001","0.60085043686537676","81.123822585322387","99.81610886355277","0"<br />"05/20/2005 08:38:51.417","0","6.3878812348270149","0.0048199999999999996","0","0","0","20.234373999999999","1.1977277315300652","81.12293644633165","99.834093737038572","0"<br />"05/20/2005 08:38:56.417","0","5.4065348523817498","0.0043200000000000001","0","0","0","11.640625999999997","1.8021782841272498","81.122810213612382","99.837464445347422","0"<br />"05/20/2005 08:39:01.417","0","9.8159263633755707","0.0089800000000000001","0","0","0","16.328123999999999","1.2019501669439474","81.122230968594394","99.85890652557319","0"<br />"05/20/2005 08:39:06.417","0","8.9812196475821526","0.00696","0","0","0","10.703125999999996","0.19958265883515897","81.122068820067625","99.838917525773198","0"<br />"05/20/2005 08:39:11.417","0","9.6154688510341888","0.00596","0","0","0","17.734373999999995","1.0016113386493948","81.122152209122277","99.863247863247864","0"<br />"05/20/2005 08:39:16.417","0","8.7816018801632882","0.0044400000000000004","0","0","0","14.375000000000004","0.798327443651208","81.122125775771252","99.862353750860294","0"<br />"05/20/2005 08:39:21.417","0","5.0041753345685756","0.0049800000000000001","0","0","0","16.328125999999997","0.20016701338274304","81.121726568055962","99.300699300699307","0"<br />"05/20/2005 08:39:26.417","0","14.022577783047835","0.0093799999999999994","0","0","0","10.234374000000003","1.4022577783047834","81.12154559089781","99.867285998672855","0"<br />"05/20/2005 08:39:31.417","0","8.9811954084884533","0.01924","0","0","0","15.234376000000005","0.99791060094316153","81.121514218515941","99.877899877899878","0"<br />"05/20/2005 08:39:36.417","0","3.2045428398744393","0.0080999999999999996","0","0","0","10.312500000000002","0.20028392749215246","81.121277199809299","99.821746880570402","0"<br />"05/20/2005 08:39:41.417","0","14.577968128991181","0.0054400000000000004","0","0","0","17.421874000000003","0.79879277419129757","81.120623986613282","99.590403744880049","0"<br />"05/20/2005 08:39:46.417","0","10.016147612083842","0.0045199999999999997","0","0","0","12.187499999999996","1.0016147612083841","81.120603432514727","99.690189328743557","0"<br />"05/20/2005 08:39:51.417","0","7.4090653812045373","0.0068399999999999997","0","0","0","29.374999999999996","0.80098004121130129","81.120475955306972","99.881901387658701","0"<br />"05/20/2005 08:39:56.417","1","7.187696713518287","0.0068599999999999998","0","0","0","19.609376000000001","0.79863296816869855","81.120517818409439","99.846342962507677","0"<br />"05/20/2005 08:40:01.417","0","9.007545268853093","0.13388","0","0","0","31.406250000000004","0.80067069056471929","81.120197598502614","99.860481339379135","0"<br />"05/20/2005 08:40:06.417","2","4.3925036035823002","0.0053200000000000001","0","0","0","23.671874000000003","0.39931850941657271","81.120066589084445","99.860675722744688","0"<br />"05/20/2005 08:40:11.417","1","7.0084999404279991","0.0077400000000000004","0","0","0","20.859375999999997","0.80097142176319991","81.120038275872872","99.803214168579856","0"<br />"05/20/2005 08:40:16.417","2","0.80036086245027804","0.0019599999999999999","0","0","0","5.8593739999999954","0.80036086245027804","81.119840494680034","99.819689866570499","0"<br />"05/20/2005 08:40:21.417","9","0.59909451310128803","0.0023600000000000001","0","0","0","2.5781260000000028","0.39939634206752539","81.119677793550153","99.832607967860724","0"<br />"05/20/2005 08:40:26.417","0","23.638019781850236","0.0054000000000000003","0","0","0","15.781250000000002","1.0016110077055185","81.119934325725637","99.867637326273993","0"<br />"05/20/2005 08:40:31.417","0","8.4070342261742947","0.01008","0","0","0","5.5468740000000016","0.80066992630231371","81.119933273866749","99.790209790209801","0"<br />"05/20/2005 08:40:36.417","0","5.3908023688195001","0.0044999999999999997","0","0","0","11.562499999999998","0.99829673496657412","81.119905071930958","99.870759289176092","0"<br />"05/20/2005 08:40:41.417","0","12.21972544870559","0.01274","0","0","0","8.4374999999999982","0.80129347204626833","81.120140801136372","99.86486486486487","0"<br />"05/20/2005 08:40:46.417","0","5.9909222167173928","0.0067000000000000002","0","0","0","5.2343759999999957","0.59909222167173926","81.120129114931444","99.822064056939496","0"<br />"05/20/2005 08:40:51.417","0","5.0071069108460371","0.0040400000000000002","0","0","0","5.46875","0.8011371057353659","81.119995196144458","99.794026776519047","0"<br />"05/20/2005 08:40:56.417","4","10.584002720584106","0.0081399999999999997","0","0","0","12.421873999999999","0.39939632907864547","81.120115153895739","99.881551673082612","0"<br />"05/20/2005 08:41:01.417","0","6.4065965314754507","0.013220000000000001","0","0","0","23.515626000000001","1.4014429912602548","81.119873213438723","99.866041527126598","0"<br />"05/20/2005 08:41:06.417","0","4.9924526688869584","0.0074000000000000003","0","0","0","18.437499999999996","1.9969810675547832","81.119678080043585","99.85734664764621","0"<br />"05/20/2005 08:41:11.417","1","9.2130244199338254","0.0031199999999999999","0","0","0","24.140623999999999","0.4005662791275576","81.119802512162551","99.876998769987708","0"<br />"05/20/2005 08:41:16.417","0","3.6044257045489743","0.0022200000000000002","0","0","0","18.984376000000005","0.80098348989977208","81.119688003979434","99.884626478223254","0"<br />"05/20/2005 08:41:21.417","0","6.9894267167961317","0.0067600000000000004","0","0","0","11.484373999999997","0.79879162477670074","81.119602974357093","99.850467289719631","0"<br />"05/20/2005 08:41:26.417","0","10.41476287081232","0.0057999999999999996","0","0","0","16.718750000000004","0.40056780272355075","81.11961926741661","99.844479004665629","0"<br />"05/20/2005 08:41:31.417","0","3.4021563370082095","0.0033800000000000002","0","0","0","12.968749999999996","0.60038053006027225","81.119527189406782","99.825403753819302","0"<br />"05/20/2005 08:41:36.417","0","3.9932021529784087","0.0038","0","0","0","4.765626000000001","1.9966010764892044","81.119427664665437","99.861111111111114","0"<br />"05/20/2005 08:41:41.417","0","11.416182660231245","0.0057400000000000003","0","0","0","14.0625","1.4019873442389248","81.119441827876244","99.831932773109244","0"<br />"05/20/2005 08:41:46.417","0","4.5930625712111475","0.0023999999999999998","0","0","0","4.6875","0.39939674532270847","81.119362394747043","99.858256555634313","0"<br />"05/20/2005 08:41:51.417","0","7.8110689991744104","0.0038800000000000002","0","0","0","9.2187499999999982","0.80113528196660622","81.119455657299739","99.88541965052994","0"<br />"05/20/2005 08:41:56.417","0","11.183094392352073","0.0012199999999999999","0","0","0","4.0625000000000018","0.99849057074572078","81.119612908364914","99.861303744798889","0"<br />"05/20/2005 08:42:01.417","0","5.0070887184088368","0.021319999999999999","0","0","0","6.5625000000000044","0.60085064620906048","81.119602589901035","99.780976220275335","0"<br />"05/20/2005 08:42:06.417","0","5.5915616113309481","0.0044799999999999996","0","0","0","11.640623999999999","0.59909588692831595","81.11957692049431","99.842121881907161","0"<br />"05/20/2005 08:42:11.417","0","10.41476913513767","0.00248","0","0","0","19.296875999999997","0.80113608731828223","81.119723509235186","99.858256555634313","0"<br />"05/20/2005 08:42:16.417","0","4.3924915955806592","0.0030400000000000002","0","0","0","8.3593739999999972","0.39931741778005991","81.119639293627174","99.863247863247864","0"<br />"05/20/2005 08:42:21.417","0","4.8068186111269595","0.0033800000000000002","0","0","0","21.562499999999996","0.20028410879695663","81.119523399942665","99.849397590361448","0"<br />"05/20/2005 08:42:26.417","0","10.184629327020701","0.0068399999999999997","0","0","0","3.9843760000000006","0","81.119720381053412","99.858206309819209","0"<br />"05/20/2005 08:42:31.417","2","8.213238351509343","0.0071199999999999996","0","0","0","4.9218740000000043","0","81.119673743339575","99.850857568978384","0"<br />"05/20/2005 08:42:36.417","3","6.2088139776808182","0.0049199999999999999","0","0","0","4.2968760000000046","0","81.119643492618891","99.865319865319861","0"<br />"05/20/2005 08:42:41.417","3","11.779848216936198","0.0038","0","0","0","4.9218740000000043","0","81.119754398009263","99.873896595208066","0"<br />"05/20/2005 08:42:46.417","3","5.8071133339775569","0.0024399999999999999","0","0","0","3.6718759999999961","0","81.119730236090646","99.865906805229628","0"<br />"05/20/2005 08:42:51.417","3","6.3903554302289498","0.0035000000000000001","0","0","0","8.3593739999999972","0","81.119787000721601","99.874921826141332","0"<br />"05/20/2005 08:42:56.417","4","14.417624389756362","0.00346","0","0","0","22.812500000000004","0","81.119833526172556","99.874332390826254","0"<br />"05/20/2005 08:43:01.417","5","4.7918137722084806","0.00316","0","0","0","9.453126000000001","0","81.119670660481773","99.875311720698249","0"<br />"05/20/2005 08:43:06.417","6","5.8082445412009172","0.0091400000000000006","0","0","0","3.2812500000000022","0","81.119665791857841","99.850299401197603","0"<br />"05/20/2005 08:43:11.417","7","9.6132866338435843","0.0030200000000000001","0","0","0","18.125000000000004","0","81.119896126607188","99.853318665199851","0"<br />"05/20/2005 08:43:16.417","8","4.7919810481969582","0.0025799999999999998","0","0","0","8.9062500000000036","0","81.119814848607646","99.857142857142861","0"<br />"05/20/2005 08:43:21.417","8","2.2026997712805838","0.0048799999999999998","0","0","0","11.875000000000002","0","81.119876858799515","99.881340848412933","0"<br />"05/20/2005 08:43:26.417","9","6.9894399820964352","0.017559999999999999","0","0","0","5.1562499999999956","0","81.120021656133162","99.881164587046939","0"<br />"05/20/2005 08:43:31.417","9","5.6090323922250525","0.0026800000000000001","0","0","0","8.6718740000000025","0","81.120209832432906","99.854386603567519","0"<br />"05/20/2005 08:43:36.417","9","2.994310956471979","0.00266","0","0","0","17.656249999999996","0","81.120016870757723","99.835796387520531","0"<br />"05/20/2005 08:43:41.417","10","10.815281553279515","0.0035400000000000002","0","0","0","9.1406259999999957","0","81.120275657848268","99.84227129337539","0"<br />"05/20/2005 08:43:46.417","10","5.6046919369823263","0.0076400000000000001","0","0","0","5.5468740000000016","0","81.120237766171044","99.860100727476222","0"<br />"05/20/2005 08:43:51.417","11","8.5853487183352044","0.0060800000000000003","0","0","0","12.5","0","81.120159854097778","99.883483833381888","0"<br />"05/20/2005 08:43:56.417","11","8.0113494642621923","0.0025600000000000002","0","0","0","12.187499999999996","0","81.120087900125611","99.841017488076318","0"<br />"05/20/2005 08:44:01.417","11","6.7884227024015189","0.00282","0","0","0","6.7968759999999957","0","81.120134341996717","99.832705980761176","0"<br />"05/20/2005 08:44:06.417","11","5.8082094433927933","0.0056600000000000001","0","0","0","3.5937499999999956","0","81.120060142625846","99.875699192044749","0"<br />"05/20/2005 08:44:11.417","12","8.5853876895830155","0.0024599999999999999","0","0","0","13.749999999999996","0","81.12013183400903","99.86803035301881","0"<br />"05/20/2005 08:44:16.417","12","5.8093657199730497","0.00298","0","0","0","6.25","0","81.120070773112772","99.730094466936563","0"<br />"05/20/2005 08:44:21.417","14","4.1936626617931969","0.0036600000000000001","0","0","0","4.6875","0","81.120079954143733","99.769408147578787","0"<br />"05/20/2005 08:44:26.417","15","10.412740476541069","0.0058599999999999998","0","0","0","9.375","0","81.120126199514104","99.868334430546412","0"<br />"05/20/2005 08:44:31.417","15","4.4062479938230652","0.0022399999999999998","0","0","0","8.4374999999999982","0","81.120124494269803","99.880987801249631","0"<br />"05/20/2005 08:44:36.417","15","4.5930415718422344","0.00346","0","0","0","5.8593739999999954","0","81.120068680007975","99.842395587076439","0"<br />"05/20/2005 08:44:41.417","15","10.412768662082989","0.0031199999999999999","0","0","0","7.5781259999999957","0","81.120233045700402","99.864910503208364","0"<br />"05/20/2005 08:44:46.417","15","8.5853482802810941","0.02196","0","0","0","7.8125","0","81.12020201936069","99.891037864342138","0"<br />"05/20/2005 08:44:51.417","15","5.0080617830868626","0.0042199999999999998","0","0","0","5.9374999999999956","0","81.12019604957878","99.890620727372152","0"<br />"05/20/2005 08:44:56.417","15","8.7867444639400691","0.0037200000000000002","0","0","0","3.2812500000000022","0","81.120250964586361","99.869918699186982","0"<br />"05/20/2005 08:45:01.417","15","3.6057842524428785","0.0047600000000000003","0","0","0","6.5625000000000044","0","81.120068495394491","99.842395587076439","0"<br />"05/20/2005 08:45:06.417","15","3.403524545004367","0.0074400000000000004","0","0","0","30.625000000000004","0","81.11979829383354","99.877036581616977","0"<br />"05/20/2005 08:45:11.417","15","6.9853595828448212","0.0051799999999999997","0","0","0","17.109373999999999","0","81.119730457023778","99.866977053541746","0"<br />"05/20/2005 08:45:16.417","16","6.6093026932401102","0.0031199999999999999","0","0","0","6.25","0","81.119684106292482","99.857244825124909","0"<br />"05/20/2005 08:45:21.417","17","3.7928274467185354","0.0082000000000000007","0","0","0","5.3124999999999982","0","81.119679311689779","99.845916795069328","0"<br />"05/20/2005 08:45:26.417","17","6.00850974445778","0.0047200000000000002","0","0","0","10.468750000000004","0","81.119657157958358","99.856989631748306","0"<br />"05/20/2005 08:45:31.417","18","1.8025579789635326","0.01908","0","0","0","3.90625","0","81.119658965886416","99.853049228508453","0"<br />"05/20/2005 08:45:36.417","18","5.3907987724007667","0.0033999999999999998","0","0","0","3.0468759999999984","0","81.11959424560709","99.846801991574111","0"<br />"05/20/2005 08:45:41.417","18","7.2088205951338189","0.0037200000000000002","0","0","0","5.1562499999999956","0","81.11970786061903","99.867681111478674","0"<br />"05/20/2005 08:45:46.417","20","2.1966786474950641","0.0016199999999999999","0","0","0","5.0781239999999954","0","81.119629490735747","99.870172022070761","0"<br />"05/20/2005 08:45:51.417","20","2.6036714427756289","0.0049199999999999999","0","0","0","8.1250000000000036","0","81.11963401064385","99.84362783424551","0"<br />"05/20/2005 08:45:56.417","20","6.5926715048583597","0.012319999999999999","0","0","0","3.2031260000000006","0","81.119623966318187","99.868117375535775","0"<br />"05/20/2005 08:46:01.417","20","4.0064630121708085","0.0046800000000000001","0","0","0","5.1562499999999956","0.60096945182562123","81.119555301427994","99.847502859321395","0"<br />"05/20/2005 08:46:06.417","20","1.9965188742893996","0.0049399999999999999","0","0","0","1.7187500000000022","0.99825943714469978","81.119452808346722","99.818971759594504","0"<br />"05/20/2005 08:46:11.417","21","4.0058301694095206","0.02316","0","0","0","1.8750000000000044","0","81.119499060692533","99.844599844599841","0"<br />"05/20/2005 08:46:16.417","21","2.5960745115056207","0.0022200000000000002","0","0","0","2.8124999999999956","0","81.119403426953255","99.84905660377359","0"<br />"05/20/2005 08:46:21.417","21","2.2031255534804206","0.0064799999999999996","0","0","0","3.6718739999999972","0","81.11940769381502","99.874608150470223","0"<br />"05/20/2005 08:46:26.417","21","6.7884026153144461","0.0062599999999999999","0","0","0","2.2656259999999984","0","81.119399726300529","99.855282199710558","0"<br />"05/20/2005 08:46:31.417","21","3.2045490264884688","0.0066400000000000001","0","0","0","2.0312499999999956","0","81.119452384047236","99.847560975609767","0"<br />"05/20/2005 08:46:36.417","22","3.9939628145275989","0.020660000000000001","0","0","0","1.953123999999995","0","81.119327061571951","99.853587115666173","0"<br />"05/20/2005 08:46:41.417","23","5.6079529339049969","0.0041999999999999997","0","0","0","2.8906259999999961","0","81.119409412647826","99.824005631819773","0"<br />"05/20/2005 08:46:46.417","23","2.0032291028272846","0.0031199999999999999","0","0","0","1.0937500000000044","0","81.119358234193001","99.84399375975039","0"<br />"05/20/2005 08:46:51.417","23","4.5930532396666104","0.00382","0","0","0","1.7968740000000039","0","81.119357323372256","99.820466786355482","0"<br />"05/20/2005 08:46:56.417","0","17.027439323750688","0.0029199999999999999","0","0","0","8.2031260000000046","3.2051650491766002","81.119437005800961","99.868334430546412","0"<br />"05/20/2005 08:47:01.417","0","3.1945584480388693","0.051380000000000002","0","0","0","2.734373999999995","0.59897970900728803","81.119264530829611","99.858757062146893","0"<br />"05/20/2005 08:47:06.417","0","2.0028421559676213","0.0047200000000000002","0","0","0","1.0937500000000044","0.60085264679028627","81.119191233727847","99.888205701509222","0"<br />"05/20/2005 08:47:11.417","0","5.5904491249880808","0.0025400000000000002","0","0","0","10.312500000000002","1.1979533839260175","81.119299644512608","99.848427434634331","0"<br />"05/20/2005 08:47:16.417","0","3.4048176176709468","0.0041000000000000003","0","0","0","6.328126000000001","0.20028338927476158","81.119230035625876","99.846684553468762","0"<br />"05/20/2005 08:47:21.417","0","4.1928572904849659","0.0024399999999999999","0","0","0","4.0625000000000018","0","81.119252802858782","99.879699248120303","0"<br />"05/20/2005 08:47:26.417","0","5.6079550575709707","0.02496","0","0","0","2.8906239999999972","1.2017046551937793","81.119277311039411","99.865816839986579","0"<br />"05/20/2005 08:47:31.417","0","4.1936567056975997","0.016240000000000001","0","0","0","3.3593760000000028","0.19969793836655236","81.119324720790402","99.88581216100485","0"<br />"05/20/2005 08:47:36.417","1","5.0080735915552479","0.0045399999999999998","0","0","0","18.203124000000003","0","81.119240950266217","99.849170437405732","0"<br />"05/20/2005 08:47:41.417","0","6.0061484947231696","0.0147","0","0","0","8.9062500000000036","1.0010247491205282","81.119354073088559","99.869621903520212","0"<br />"05/20/2005 08:47:46.417","0","7.9863739263412148","0.0067400000000000003","0","0","0","13.749999999999996","0.79863739263412148","81.119373276608712","99.861159319680667","0"<br />"05/20/2005 08:47:51.417","0","1.2012408129751595","0.0035799999999999998","0","0","0","14.375000000000004","0","81.119331489267012","99.890260631001368","0"<br />"05/20/2005 08:47:56.417","0","7.7882249269232435","0.018519999999999998","0","0","0","18.359376000000005","1.3978865253451975","81.119463753687199","99.876199319096258","0"<br /><br /><br /><br /><br />Copy of Excel spreadsheet<br /><br />TimeASP waiting requestAsp request/sPhysical Disk:Write Queue LengthNetwork Interface<img src='/community/emoticons/emotion-3.gif' alt=':O' />utbound Queue LengthProcessor % useTransact/sCache Manager:Cache Hit RatioBuffer Manager:Buffer cache Hit RatioMemory Grants Outstanding<br />05/20/2005 08:31:21.4020 0 81.11861676683032899.8390212491950990<br />05/20/2005 08:31:26.40208.60996733804915591.7009799999999999011.1718760000000030.2002317985592826981.11884395810903999.6801705756929550<br />05/20/2005 08:31:31.40204.19368325717336352.1958799999999998014.1406240000000030.199699202722541181.11882602790375199.7102499094530970<br />05/20/2005 08:31:36.40207.40037504182683661.04826019.3749999999999961.20006081759354181.11892432068414499.7122762148337640<br />05/20/2005 08:31:41.40209.21846210820448951.5049600000000001011.0156260000000010.2004013501783584781.11906828011534399.8352010547132520<br />05/20/2005 08:31:46.40201.99971609627742082.322820000000000107.81250.1999716096277420881.1191244082731899.8094512195121980<br />05/20/2005 08:31:51.40206.99891826891732023.506180000000000108.75000000000000181.799721840578739481.11913648835911899.7389033942558710<br />05/20/2005 08:31:56.402011.1897515312217171.4431011.0937500000000021.398718941402714681.11938944589573599.8041136141038120<br />05/20/2005 08:32:01.40226.80034743985151022.4722200000000001011.9531240000000041.000051094095810381.11908112867686899.8119122257053280<br />05/20/2005 08:32:06.41704.19447887821793592.217490342679127919.19003115264797010.7989483577557973181.11917830602159599.7592847317744140<br />05/20/2005 08:32:11.417010.1766094286167111.9923200000000001016.0937499999999960.9977068067271285381.11934647507183699.8223801065719410<br />05/20/2005 08:32:16.41706.79636745609208861.37026017.18750.3997863209465934481.11932509775537999.8438475952529670<br />05/20/2005 08:32:21.41704.61107079973313730.94267999999999996018.6718759999999972.004813391188320881.11933892778630299.8592045054558210<br />05/20/2005 08:32:26.417010.791972900264761.12236020.31252.398216200058835481.11958185196510899.8712169993560790<br />05/20/2005 08:32:31.41705.80037557832115261.1999019.9999999999999960.6000388529297743281.11969699390280799.8590059922453290<br />05/20/2005 08:32:36.41717.59741434687268491.27274022.8125000000000042.998979347449744481.11977024828621699.8333333333333290<br />05/20/2005 08:32:41.417011.0177793790961220.78559999999999997033.2031239999999951.20193956862866881.11972000127055199.8488855307895730<br />05/20/2005 08:32:46.41705.18709250400088171.0046600000000001011.0937500000000020.9975177892309388181.11985697037243999.8755832037325040<br />05/20/2005 08:32:51.41704.40194567980539640.48049999999999998014.2187500000000021.800795959920389581.1197036056838199.8479318734793250<br />05/20/2005 08:32:56.41708.011351975454760.02121999999999999909.60937600000000280.4005675987727379581.11988635339925299.8370672097759670<br />05/20/2005 08:33:01.41706.98808734391256970.0068199999999999997011.9531240000000040.9982981919875099181.11980825745567499.8428908091123330<br />05/20/2005 08:33:06.41703.20328547961196190.005499999999999999706.252.002053424757476481.119908587230199.8564249820531270<br />05/20/2005 08:33:11.41706.80566924658560170.016799999999999999010.2343760000000011.201000455279812181.12002916779384599.8810585786500130<br />05/20/2005 08:33:16.41706.80300841365933180.008179999999999999808.90625000000000360.8003539310187448681.12007961233193599.8819710829153140<br />05/20/2005 08:33:21.41704.79182047104579120.006519999999999999806.251.796932676642171681.12017064951008699.8714652956298180<br />05/20/2005 08:33:26.41705.00611857682926150.01386000000000000106.09374999999999820.4004894861463408981.12036493437003199.8593035525853030<br />05/20/2005 08:33:31.417011.9817922627246120.007000000000000000107.18750000000000182.196661914832845781.12055568582022199.8641765704584120<br />05/20/2005 08:33:36.41705.60142961509128320.0037399999999999998015.9375000000000041.800459519136483881.12057001682173199.7634069400630920<br />05/20/2005 08:33:41.41707.61079598915997920.0044400000000000004014.2968740000000042.00284104977894281.12064973362811399.8313090418353540<br />05/20/2005 08:33:46.41708.18760977892058330.00198011.8750000000000020.1996977994858678881.12064209777494799.8123827392119980<br />05/20/2005 08:33:51.41706.81097222908420360.004380000000000000205.62500000000000181.001613563100618281.12074520109560299.8309668695064260<br />05/20/2005 08:33:56.41707.80652603814574950.0019205.85937600000000460.4003346686228589481.12079809587004399.8742533794404320<br />05/20/2005 08:34:01.41707.18488167519155050.004139999999999999609.45312400000000251.796220418797887681.12076284878291799.8486224644262850<br />05/20/2005 08:34:06.41702.002070165346840.003599999999999999907.1093760000000011.201242099208104181.12080985096822999.8484848484848580<br />05/20/2005 08:34:11.41702.20312296583325740.0016407.18750000000000180.4005678119696831681.12086841126895899.8155832180728450<br />05/20/2005 08:34:16.41711.39788416697043960.002340000000000000105.00000000000000442.196675119524976581.1208185901266699.8489996224990510<br />05/20/2005 08:34:21.417015.2186073808051870.0040800000000000003015.6251.40171383770574181.12105487802443899.8803827751196140<br />05/20/2005 08:34:26.41706.78839866265696570.0039399999999999999011.4843739999999970.7986351367831724481.1210481665914599.8820754716981160<br />05/20/2005 08:34:31.41704.60655489943025480.008000000000000000206.87499999999999820.200284995627402481.12107185729317499.8897767980159870<br />05/20/2005 08:34:36.417012.5784587513551090.0046600000000000001010.2343760000000011.597264603346680481.12128638296707199.859451862262830<br />05/20/2005 08:34:41.41703.00428000175741870.005360000000000000209.45312400000000251.00142666725247381.12129103574184899.8538545853123910<br />05/20/2005 08:34:46.41705.60356482011778120.0031604.92187600000000280.8005092600168259981.12125030789117499.8606757227446880<br />05/20/2005 08:34:51.417011.9795609574272440.01264010.3125000000000020.1996593492904540981.12147399954005899.8496240601503760<br />05/20/2005 08:34:56.41707.41193690487132080.004100000000000000309.99999999999999821.001613095252881281.12150304934375899.8505678421996380<br />05/20/2005 08:35:01.41706.20517099292864140.0071599999999999997011.4843739999999970.4003336124470091681.12133757122099199.8703403565640290<br />05/20/2005 08:35:06.417010.3741919046289670.0077999999999999996033.751.795533214262705881.12133736772200699.8649561107359890<br />05/20/2005 08:35:11.41704.00255688443417680.0046800000000000001012.8125000000000041.601022753773670581.12123811742088799.8131423232637760<br />05/20/2005 08:35:16.41702.20354927847638620.0072605.78125000000000440.8012906467186859981.12129715249946699.7813866333541450<br />05/20/2005 08:35:21.41708.98643674525222560.004309.76562600000000461.1981915660336381.12148288616889199.7709923664122160<br />05/20/2005 08:35:26.41709.61551440630125680.002200000000000000106.9531239999999991.201939300787657181.12152945674829199.8086124401913960<br />05/20/2005 08:35:31.41703.19505020854079550.006320000000000000109.29687599999999750.3993812760675994381.12159434909544699.8271889400921710<br />05/20/2005 08:35:36.41709.61398162880614570.002459999999999999906.56250000000000440.4005825678669227681.12172067668453299.7994652406417230<br />05/20/2005 08:35:41.41707.58706620344090150.002200000000000000108.82812400000000430.5989789107979659581.12185878407994799.8137224464452120<br />05/20/2005 08:35:46.41705.40766976164883410.005459999999999999606.79687599999999572.203124717708784381.12186523322377299.8157813939207870<br />05/20/2005 08:35:51.41707.00854163703694070.004179999999999999704.45312399999999720.8009761870899361281.1220030549588199.8388136686009060<br />05/20/2005 08:35:56.41703.59314956742303830.0024804.60937599999999840.7984776816495641281.12200808024627599.8389694041867980<br />05/20/2005 08:36:01.41704.2027000532816290.008739999999999999509.92187399999999721.601028591726334781.12193136975898399.8053212199870220<br />05/20/2005 08:36:06.41709.41335829679867690.004539999999999999807.34375000000000442.403410628969874981.1220846232655599.805371739976650<br />05/20/2005 08:36:11.41708.38734052021197130.0019599999999999999010.3906260000000031.198191502887424681.12218109124546699.8244998244998240<br />05/20/2005 08:36:16.41705.40766662841271550.002399999999999999806.32812400000000162.803975288806593281.12217702238389499.8292349726775970<br />05/20/2005 08:36:21.41708.98642142832609280.005519999999999999706.87499999999999820.9984912698140103781.12233660984080199.8281786941580830<br />05/20/2005 08:36:26.41703.60510953225819050.0026407.34375000000000441.001419314516164181.12235195344116899.8402555910543160<br />05/20/2005 08:36:31.41704.9992812538219980.0023208.35937599999999570.9998562507643996681.12241048181812299.84553599011430<br />05/20/2005 08:36:36.41709.18611872937065680.001619999999999999906.48437400000000430.599094699741564681.12264653166444499.7838839147885180<br />05/20/2005 08:36:41.41706.40407710919749020.0040400000000000002010.2343760000000011.801146686961794381.12270533875853699.8306233062330510<br />05/20/2005 08:36:46.41703.80538598748575430.003500000000000000107.34375000000000441.602267784204528181.12274046990876399.8776758409785970<br />05/20/2005 08:36:51.41706.59005009618280550.004219999999999999806.87499999999999820.3993969755262306681.12288800966371199.8291766313631680<br />05/20/2005 08:36:56.41705.80927488634731490.0039399999999999999010.8593739999999990.6009594710014463181.12306229004865199.8062551895931450<br />05/20/2005 08:37:01.41705.98871508726220720.0033013.4375000000000020.5988715087262206481.12295327890660799.828708461801980<br />05/20/2005 08:37:06.41706.20873898607577690.005320000000000000107.73437599999999840.8011276111065518481.12315747274489399.8598458304134480<br />05/20/2005 08:37:11.41705.60472099489595530.03642000000000000108.593750.6005058208817095681.12329921888093199.8723268432812010<br />05/20/2005 08:37:16.41703.7920239192028160.0032399999999999998012.1874999999999960.5987406188214972181.12325966714966899.8808459934465280<br />05/20/2005 08:37:21.41707.40763352890831770.010500000000000001013.3593740000000030.8008252463684667581.12342593064299599.8654557685839280<br />05/20/2005 08:37:26.417011.8143002222557170.011900000000000001010.3906260000000031.60193901318721681.12359193987475799.8586072817249860<br />05/20/2005 08:37:31.41706.1847132398353670.0065599999999999999018.9843740000000031.396548150930566881.12362828503128899.7188378631677640<br />05/20/2005 08:37:36.41754.00567963592915890.04462020.31252.203123799761037181.12365941605378399.820143884892090<br />05/20/2005 08:37:41.417013.2161406835862230.0055399999999999998025.4687499999999960.8009782232476498981.1237395880017499.7310924369747910<br />05/20/2005 08:37:46.41704.79089618854643010.0046600000000000001010.2343760000000011.197724047136607581.12375405664606499.6947496947497030<br />05/20/2005 08:37:51.41703.80613927638120630.0036209.84374999999999640.6009693594286115281.1238425256876599.7803806734992660<br />05/20/2005 08:37:56.417010.5819129121598210.0054400000000000004014.1406240000000030.598976202575084181.12406611819615499.8774509803921550<br />05/20/2005 08:38:01.41703.40550528944544070.0043800000000000002013.3593760000000010.8012953622224566881.12356325118409599.8045347928068760<br />05/20/2005 08:38:06.41704.19365495160409370.004539999999999999805.468750.3993957096765803981.12361028782022799.7860199714693290<br />05/20/2005 08:38:11.41707.81108223422041540.01158012.7343740000000040.8011366394072221381.12379961858708699.809099586382430<br />05/20/2005 08:38:16.41708.98636976780665540.006519999999999999809.92187599999999570.7987884238050361281.12339254584740999.6121525533290250<br />05/20/2005 08:38:21.41703.60582630197129190.005539999999999999805.15624999999999561.602589467542796381.12328868285543199.6172248803827640<br />05/20/2005 08:38:26.41708.18444619139170190.004340000000000000109.14062399999999721.596965110515454181.12336046832987899.5692749461593680<br />05/20/2005 08:38:31.41705.2084015306836680.0016607.57812599999999570.6009694073865771181.123491664162699.5870612525808670<br />05/20/2005 08:38:36.41709.0110361734351230.02165999999999999908.593750.4004904965971165581.12352704396495599.7923464847226430<br />05/20/2005 08:38:41.41707.98323276902207370.009039999999999999405.70312400000000431.197484915353310981.12370007316633399.8063623789764880<br />05/20/2005 08:38:46.41706.20878784760889340.002419999999999999808.6718760000000010.6008504368653767681.12382258532238799.816108863552770<br />05/20/2005 08:38:51.41706.38788123482701490.0048199999999999996020.2343739999999991.197727731530065281.1229364463316599.8340937370385720<br />05/20/2005 08:38:56.41705.40653485238174980.0043200000000000001011.6406259999999971.802178284127249881.12281021361238299.8374644453474220<br />05/20/2005 08:39:01.41709.81592636337557070.0089800000000000001016.3281239999999991.201950166943947481.12223096859439499.858906525573190<br />05/20/2005 08:39:06.41708.98121964758215260.00696010.7031259999999960.1995826588351589781.12206882006762599.8389175257731980<br />05/20/2005 08:39:11.41709.61546885103418880.00596017.7343739999999951.001611338649394881.12215220912227799.8632478632478640<br />05/20/2005 08:39:16.41708.78160188016328820.0044400000000000004014.3750000000000040.79832744365120881.12212577577125299.8623537508602940<br />05/20/2005 08:39:21.41705.00417533456857560.0049800000000000001016.3281259999999970.2001670133827430481.12172656805596299.3006993006993070<br />05/20/2005 08:39:26.417014.0225777830478350.0093799999999999994010.2343740000000031.402257778304783481.1215455908978199.8672859986728550<br />05/20/2005 08:39:31.41708.98119540848845330.01924015.2343760000000050.9979106009431615381.12151421851594199.8778998778998780<br />05/20/2005 08:39:36.41703.20454283987443930.0080999999999999996010.3125000000000020.2002839274921524681.12127719980929999.8217468805704020<br />05/20/2005 08:39:41.417014.5779681289911810.0054400000000000004017.4218740000000030.7987927741912975781.12062398661328299.5904037448800490<br />05/20/2005 08:39:46.417010.0161476120838420.0045199999999999997012.1874999999999961.001614761208384181.12060343251472799.6901893287435570<br />05/20/2005 08:39:51.41707.40906538120453730.0068399999999999997029.3749999999999960.8009800412113012981.12047595530697299.8819013876587010<br />05/20/2005 08:39:56.41717.1876967135182870.0068599999999999998019.6093760000000010.7986329681686985581.12051781840943999.8463429625076770<br />05/20/2005 08:40:01.41709.0075452688530930.13388031.4062500000000040.8006706905647192981.12019759850261499.8604813393791350<br />05/20/2005 08:40:06.41724.39250360358230020.0053200000000000001023.6718740000000030.3993185094165727181.12006658908444599.8606757227446880<br />05/20/2005 08:40:11.41717.00849994042799910.0077400000000000004020.8593759999999970.8009714217631999181.12003827587287299.8032141685798560<br />05/20/2005 08:40:16.41720.800360862450278040.001959999999999999905.85937399999999540.8003608624502780481.11984049468003499.8196898665704990<br />05/20/2005 08:40:21.41790.599094513101288030.002360000000000000102.57812600000000280.3993963420675253981.11967779355015399.8326079678607240<br />05/20/2005 08:40:26.417023.6380197818502360.0054000000000000003015.7812500000000021.001611007705518581.11993432572563799.8676373262739930<br />05/20/2005 08:40:31.41708.40703422617429470.0100805.54687400000000160.8006699263023137181.11993327386674999.7902097902098010<br />05/20/2005 08:40:36.41705.39080236881950010.0044999999999999997011.5624999999999980.9982967349665741281.11990507193095899.8707592891760920<br />05/20/2005 08:40:41.417012.219725448705590.0127408.43749999999999820.8012934720462683381.12014080113637299.864864864864870<br />05/20/2005 08:40:46.41705.99092221671739280.006700000000000000205.23437599999999570.5990922216717392681.12012911493144499.8220640569394960<br />05/20/2005 08:40:51.41705.00710691084603710.004040000000000000205.468750.801137105735365981.11999519614445899.7940267765190470<br />05/20/2005 08:40:56.417410.5840027205841060.0081399999999999997012.4218739999999990.3993963290786454781.12011515389573999.8815516730826120<br />05/20/2005 08:41:01.41706.40659653147545070.013220000000000001023.5156260000000011.401442991260254881.11987321343872399.8660415271265980<br />05/20/2005 08:41:06.41704.99245266888695840.0074000000000000003018.4374999999999961.996981067554783281.11967808004358599.857346647646210<br />05/20/2005 08:41:11.41719.21302441993382540.0031199999999999999024.1406239999999990.400566279127557681.11980251216255199.8769987699877080<br />05/20/2005 08:41:16.41703.60442570454897430.0022200000000000002018.9843760000000050.8009834898997720881.11968800397943499.8846264782232540<br />05/20/2005 08:41:21.41706.98942671679613170.0067600000000000004011.4843739999999970.7987916247767007481.11960297435709399.8504672897196310<br />05/20/2005 08:41:26.417010.414762870812320.0057999999999999996016.7187500000000040.4005678027235507581.1196192674166199.8444790046656290<br />05/20/2005 08:41:31.41703.40215633700820950.0033800000000000002012.9687499999999960.6003805300602722581.11952718940678299.8254037538193020<br />05/20/2005 08:41:36.41703.99320215297840870.003804.7656260000000011.996601076489204481.11942766466543799.8611111111111140<br />05/20/2005 08:41:41.417011.4161826602312450.0057400000000000003014.06251.401987344238924881.11944182787624499.8319327731092440<br />05/20/2005 08:41:46.41704.59306257121114750.002399999999999999804.68750.3993967453227084781.11936239474704399.8582565556343130<br />05/20/2005 08:41:51.41707.81106899917441040.003880000000000000209.21874999999999820.8011352819666062281.11945565729973999.885419650529940<br />05/20/2005 08:41:56.417011.1830943923520730.001219999999999999904.06250000000000180.9984905707457207881.11961290836491499.8613037447988890<br />05/20/2005 08:42:01.41705.00708871840883680.02131999999999999906.56250000000000440.6008506462090604881.11960258990103599.7809762202753350<br />05/20/2005 08:42:06.41705.59156161133094810.0044799999999999996011.6406239999999990.5990958869283159581.1195769204943199.8421218819071610<br />05/20/2005 08:42:11.417010.414769135137670.00248019.2968759999999970.8011360873182822381.11972350923518699.8582565556343130<br />05/20/2005 08:42:16.41704.39249159558065920.003040000000000000208.35937399999999720.3993174177800599181.11963929362717499.8632478632478640<br />05/20/2005 08:42:21.41704.80681861112695950.0033800000000000002021.5624999999999960.2002841087969566381.11952339994266599.8493975903614480<br />05/20/2005 08:42:26.417010.1846293270207010.006839999999999999703.9843760000000006081.11972038105341299.8582063098192090<br />05/20/2005 08:42:31.41728.2132383515093430.007119999999999999604.9218740000000043081.11967374333957599.8508575689783840<br />05/20/2005 08:42:36.41736.20881397768081820.004919999999999999904.2968760000000046081.11964349261889199.8653198653198610<br />05/20/2005 08:42:41.417311.7798482169361980.003804.9218740000000043081.11975439800926399.8738965952080660<br />05/20/2005 08:42:46.41735.80711333397755690.002439999999999999903.6718759999999961081.11973023609064699.8659068052296280<br />05/20/2005 08:42:51.41736.39035543022894980.003500000000000000108.3593739999999972081.11978700072160199.8749218261413320<br />05/20/2005 08:42:56.417414.4176243897563620.00346022.812500000000004081.11983352617255699.8743323908262540<br />05/20/2005 08:43:01.41754.79181377220848060.0031609.453126000000001081.11967066048177399.8753117206982490<br />05/20/2005 08:43:06.41765.80824454120091720.009140000000000000603.2812500000000022081.11966579185784199.8502994011976030<br />05/20/2005 08:43:11.41779.61328663384358430.0030200000000000001018.125000000000004081.11989612660718899.8533186651998510<br />05/20/2005 08:43:16.41784.79198104819695820.002579999999999999808.9062500000000036081.11981484860764699.8571428571428610<br />05/20/2005 08:43:21.41782.20269977128058380.0048799999999999998011.875000000000002081.11987685879951599.8813408484129330<br />05/20/2005 08:43:26.41796.98943998209643520.01755999999999999905.1562499999999956081.12002165613316299.8811645870469390<br />05/20/2005 08:43:31.41795.60903239222505250.002680000000000000108.6718740000000025081.12020983243290699.8543866035675190<br />05/20/2005 08:43:36.41792.9943109564719790.00266017.656249999999996081.12001687075772399.8357963875205310<br />05/20/2005 08:43:41.4171010.8152815532795150.003540000000000000209.1406259999999957081.12027565784826899.842271293375390<br />05/20/2005 08:43:46.417105.60469193698232630.007640000000000000105.5468740000000016081.12023776617104499.8601007274762220<br />05/20/2005 08:43:51.417118.58534871833520440.0060800000000000003012.5081.12015985409777899.8834838333818880<br />05/20/2005 08:43:56.417118.01134946426219230.0025600000000000002012.187499999999996081.12008790012561199.8410174880763180<br />05/20/2005 08:44:01.417116.78842270240151890.0028206.7968759999999957081.12013434199671799.8327059807611760<br />05/20/2005 08:44:06.417115.80820944339279330.005660000000000000103.5937499999999956081.12006014262584699.8756991920447490<br />05/20/2005 08:44:11.417128.58538768958301550.0024599999999999999013.749999999999996081.1201318340090399.868030353018810<br />05/20/2005 08:44:16.417125.80936571997304970.0029806.25081.12007077311277299.7300944669365630<br />05/20/2005 08:44:21.417144.19366266179319690.003660000000000000104.6875081.12007995414373399.7694081475787870<br />05/20/2005 08:44:26.4171510.4127404765410690.005859999999999999809.375081.12012619951410499.8683344305464120<br />05/20/2005 08:44:31.417154.40624799382306520.002239999999999999808.4374999999999982081.12012449426980399.8809878012496310<br />05/20/2005 08:44:36.417154.59304157184223440.0034605.8593739999999954081.12006868000797599.8423955870764390<br />05/20/2005 08:44:41.4171510.4127686620829890.003119999999999999907.5781259999999957081.12023304570040299.8649105032083640<br />05/20/2005 08:44:46.417158.58534828028109410.0219607.8125081.1202020193606999.8910378643421380<br />05/20/2005 08:44:51.417155.00806178308686260.004219999999999999805.9374999999999956081.1201960495787899.8906207273721520<br />05/20/2005 08:44:56.417158.78674446394006910.003720000000000000203.2812500000000022081.12025096458636199.8699186991869820<br />05/20/2005 08:45:01.417153.60578425244287850.004760000000000000306.5625000000000044081.12006849539449199.8423955870764390<br />05/20/2005 08:45:06.417153.4035245450043670.0074400000000000004030.625000000000004081.1197982938335499.8770365816169770<br />05/20/2005 08:45:11.417156.98535958284482120.0051799999999999997017.109373999999999081.11973045702377899.8669770535417460<br />05/20/2005 08:45:16.417166.60930269324011020.003119999999999999906.25081.11968410629248299.8572448251249090<br />05/20/2005 08:45:21.417173.79282744671853540.008200000000000000705.3124999999999982081.11967931168977999.8459167950693280<br />05/20/2005 08:45:26.417176.008509744457780.0047200000000000002010.468750000000004081.11965715795835899.8569896317483060<br />05/20/2005 08:45:31.417181.80255797896353260.0190803.90625081.11965896588641699.8530492285084530<br />05/20/2005 08:45:36.417185.39079877240076670.003399999999999999803.0468759999999984081.1195942456070999.8468019915741110<br />05/20/2005 08:45:41.417187.20882059513381890.003720000000000000205.1562499999999956081.1197078606190399.8676811114786740<br />05/20/2005 08:45:46.417202.19667864749506410.001619999999999999905.0781239999999954081.11962949073574799.8701720220707610<br />05/20/2005 08:45:51.417202.60367144277562890.004919999999999999908.1250000000000036081.1196340106438599.843627834245510<br />05/20/2005 08:45:56.417206.59267150485835970.01231999999999999903.2031260000000006081.11962396631818799.8681173755357750<br />05/20/2005 08:46:01.417204.00646301217080850.004680000000000000105.15624999999999560.6009694518256212381.11955530142799499.8475028593213950<br />05/20/2005 08:46:06.417201.99651887428939960.004939999999999999901.71875000000000220.9982594371446997881.11945280834672299.8189717595945040<br />05/20/2005 08:46:11.417214.00583016940952060.0231601.8750000000000044081.11949906069253399.8445998445998410<br />05/20/2005 08:46:16.417212.59607451150562070.002220000000000000202.8124999999999956081.11940342695325599.849056603773590<br />05/20/2005 08:46:21.417212.20312555348042060.006479999999999999603.6718739999999972081.1194076938150299.8746081504702230<br />05/20/2005 08:46:26.417216.78840261531444610.006259999999999999902.2656259999999984081.11939972630052999.8552821997105580<br />05/20/2005 08:46:31.417213.20454902648846880.006640000000000000102.0312499999999956081.11945238404723699.8475609756097670<br />05/20/2005 08:46:36.417223.99396281452759890.02066000000000000101.953123999999995081.11932706157195199.8535871156661730<br />05/20/2005 08:46:41.417235.60795293390499690.004199999999999999702.8906259999999961081.11940941264782699.8240056318197730<br />05/20/2005 08:46:46.417232.00322910282728460.003119999999999999901.0937500000000044081.11935823419300199.843993759750390<br />05/20/2005 08:46:51.417234.59305323966661040.0038201.7968740000000039081.11935732337225699.8204667863554820<br />05/20/2005 08:46:56.417017.0274393237506880.002919999999999999908.20312600000000463.205165049176600281.11943700580096199.8683344305464120<br />05/20/2005 08:47:01.41703.19455844803886930.05138000000000000202.7343739999999950.5989797090072880381.11926453082961199.8587570621468930<br />05/20/2005 08:47:06.41702.00284215596762130.004720000000000000201.09375000000000440.6008526467902862781.11919123372784799.8882057015092220<br />05/20/2005 08:47:11.41705.59044912498808080.0025400000000000002010.3125000000000021.197953383926017581.11929964451260899.8484274346343310<br />05/20/2005 08:47:16.41703.40481761767094680.004100000000000000306.3281260000000010.2002833892747615881.11923003562587699.8466845534687620<br />05/20/2005 08:47:21.41704.19285729048496590.002439999999999999904.0625000000000018081.11925280285878299.8796992481203030<br />05/20/2005 08:47:26.41705.60795505757097070.0249602.89062399999999721.201704655193779381.11927731103941199.8658168399865790<br />05/20/2005 08:47:31.41704.19365670569759970.01624000000000000103.35937600000000280.1996979383665523681.11932472079040299.885812161004850<br />05/20/2005 08:47:36.41715.00807359155524790.0045399999999999998018.203124000000003081.11924095026621799.8491704374057320<br />05/20/2005 08:47:41.41706.00614849472316960.014708.90625000000000361.001024749120528281.11935407308855999.8696219035202120<br />05/20/2005 08:47:46.41707.98637392634121480.0067400000000000003013.7499999999999960.7986373926341214881.11937327660871299.8611593196806670<br />05/20/2005 08:47:51.41701.20124081297515950.0035799999999999998014.375000000000004081.11933148926701299.8902606310013680<br />05/20/2005 08:47:56.41707.78822492692324350.018519999999999998018.3593760000000051.397886525345197581.11946375368719999.8761993190962580<br />
  20. roryg New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Ctricaud</i><br /><br />Hi,<br /><br />I am using sql server 2000 standard edition with several databases on it.<br /><br />Since few weeks, it appears that one of the database stop delivering response for 10s to 2 minutes from time to time during the day. Meanwhile, the other databases work fine, and there is no alert on the server of anykind.<br /><br />I am a trace to find out what's happening, and found that during the time the database is unavalaible, a lot of audit login and audit logout event are recorded. In the same time, it appears on the log of our firewall (blakice) that there is some attack on sql probe access.<br /><br />Has anyone had the same problem and have fixed it? I am not sure that the problem comes from the attacks since only one database is involved, and since the firewall makes its job blocking the inbound packets.<br /><br />I am becoming crazy with this issue, and my users too... Any help will be very help full...<br /><br />Here is a sample of the trace, not very readable...<br /><br /><b>Audit Logout</b>Internet Information Servicessa52840X235x235782005-05-17 19:29:52.233<br /><b>RPC<img src='/community/emoticons/emotion-7.gif' alt=':S' />tarting</b>exec sp_cursor 180150000, 40, 22Internet Information Servicessa52840X235x235722005-05-17 19:29:52.250<br /><b>Audit Login</b>-- network protocol: LPC<br />set quoted_identifier on<br />set implicit_transactions off<br />set cursor_close_on_commit off<br />set ansi_warnings on<br />set ansi_padding on<br />set ansi_nulls on<br />set concat_null_yields_null on<br />set language Français<br />set dateformat dmy<br />set datefirst 1<br />Internet Information Servicessa52840X235x2350X20002838F410782005-05-17 19:29:52.250<br /><b>SQL:BatchStarting</b>SELECT thread_id,id,thread_parent,pseudo,subject,mesdate2,forumID,mesbody,lu FROM ForumMesTbl WHERE (thread_parent&lt;&gt;0) AND (forumID=4) AND (thread_id = 30315) AND Valide&lt;&gt;0Internet Information Servicessa52840X235x235782005-05-17 19:29:52.250<br /><b>Audit Logout</b>Internet Information Servicessa52840X235x235782005-05-17 19:29:52.250<br />RPC<img src='/community/emoticons/emotion-7.gif' alt=':S' />tartingexec sp_cursor 180150000, 40, 23Internet Information Servicessa52840X235x235722005-05-17 19:29:52.250<br />Audit Login-- network protocol: LPC<br />set quoted_identifier on<br />set implicit_transactions off<br />set cursor_close_on_commit off<br />set ansi_warnings on<br />set ansi_padding on<br />set ansi_nulls on<br />set concat_null_yields_null on<br />set language Français<br />set dateformat dmy<br />set datefirst 1<br />Internet Information Servicessa52840X235x2350X20002838F410782005-05-17 19:29:52.267<br /><b>SQL:BatchStarting</b>SELECT thread_id,id,thread_parent,pseudo,subject,mesdate2,forumID,mesbody,lu FROM ForumMesTbl WHERE (thread_parent&lt;&gt;0) AND (forumID=4) AND (thread_id = 27043) AND Valide&lt;&gt;0Internet Information Servicessa52840X235x235782005-05-17 19:29:52.267<br /><b>Audit Logout</b>Internet Information Servicessa52840X235x235782005-05-17 19:29:52.267<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  21. roryg New Member

    Hi Ctricaud,

    I read your post with great interest. I am experiencing the same problem. Did you ever find a solution.

    Regards

    Rory
  22. viksar New Member

    I had the same issues, Just install sql server service pack 4 and monitor your tempdb usage. This would resolve the issue.
  23. reddogs77 New Member

    I too am experiencing the issue you had in 2006. Did you ever figure out what the resolution was?
  24. Adriaan New Member

    @ reddogs77 - check the last post before yours, from viksar, from 2006. There's a second page to this thread!
  25. reddogs77 New Member

    Yes.. I know.. (thank you for replying).. I read the thread all the way thru -- including the information about the server maintenance. Nothing changed. Still have same issue. Was wondering if anyone had a resolution beyond what was written.Thanks!

Share This Page