June 18, 2002 at 11:54 am
I am supporting a web application written in ASP that connects to a SQL 6.5 database. The application is hosted on a WINNT 4.0 Server. I can run all of the reports without a problem except for one. This report is generated after the 3rd or sometimes 2nd attempt. (After every attempt I log out of the application.) Any suggestions will be very helpful, I have been trying to figure out why it will not run the first time through. For a few weeks I have exhausted every idea I had.
Please help.
Thanks,
Scott
June 18, 2002 at 3:32 pm
Either run a trace, use Queyr Analyzer to see the execution plan, or run PerfMon for cache hits and see if this query is constantly having to hit the actual data instead of any cached plans and data thus slowing you down until the later run as the cache has been primed and the plan available. This could be a memory issue regarding that report (can mean need more memory or rewrite the query to optimize it).
May also be the cache is too small.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 06/18/2002 3:32:11 PM
June 18, 2002 at 4:41 pm
Agree with Antares. The server load will vary and it is possible this report is right near the timeout window. No load may run ( or if data cached) and a small load may cause it to fail.
Steve Jones
June 21, 2002 at 8:16 am
I ran a SQLTrace awhile ago and this is what I got. I removed domain, computer and user names. After the third attempt, the report was generated the SQL trace captures every attempt. Please help me to understand where the problem occurs. Thanks.
-- 4/29/02 14:20:39.613 Filter Started (ID=36, SPID=108, User=sa(\), App='SQL Trace Filter', Host='COMPNAME'(190) )
-- 4/29/02 14:20:39.603 Active connections (ID=36, SPID=108, User=sa(\), App='SQL Trace Filter', Host='COMPNAME'(190) )
-- 4/29/02 14:20:39.613 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:20:38.723 Active connections (ID=35, SPID=104, User=sa(\), App='SQL Trace', Host=''(190) )
-- 4/29/02 14:20:39.613 Duration 0, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 11:02:19.913 Active connections (ID=10, SPID=111, User=sa(OURDOMAIN\username), App='MS SQLEW', Host='COMPNAME'(3d4) )
-- 4/29/02 14:20:39.613 Duration 11899, CPU 0.611, Reads 164, Writes 28
-- 4/29/02 14:21:03.210 New connection (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:03.220 SQL (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
exec sp_server_info 500 select 501,NULL,1 where 'a'<>'A' select 504,c.name,c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config=1123 and f.value=c1.id and c1.csid=c.id set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off select 505,convert(smallint,substring(@@version,charindex('6.50.',@@version)+5,3)) set implicit_transactions off
go
-- 4/29/02 14:21:03.230 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:03.230 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_UserLogin "shall", "shall", 2, NULL, NULL, NULL
go
-- 4/29/02 14:21:03.240 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:06.303 New connection (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:06.313 SQL (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
exec sp_server_info 500 select 501,NULL,1 where 'a'<>'A' select 504,c.name,c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config=1123 and f.value=c1.id and c1.csid=c.id set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off select 505,convert(smallint,substring(@@version,charindex('6.50.',@@version)+5,3)) set implicit_transactions off
go
-- 4/29/02 14:21:06.323 Duration 0.010, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:21:06.323 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_ProcessedTransactionCounts NULL, NULL, NULL, NULL, NULL
go
-- 4/29/02 14:21:30.656 Duration 24.333, CPU 1.813, Reads 138, Writes 3
-- 4/29/02 14:21:35.896 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:21:36.096 Duration 0.200, CPU 0.020, Reads 5, Writes 0
-- 4/29/02 14:21:38.830 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:21:38.900 Duration 0.070, CPU 0.030, Reads 0, Writes 0
-- 4/29/02 14:21:40.030 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:21:40.080 Duration 0.050, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:21:43.186 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:21:43.246 Duration 0.060, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:21:44.960 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_DetAllowOverride "TRX200204090000028", "Yes", NULL, NULL, NULL
go
-- 4/29/02 14:21:44.970 Duration 0.010, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:21:44.970 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_DetAllowResubmit "TRX200204090000028", NULL
go
-- 4/29/02 14:21:44.990 Duration 0.020, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:44.990 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranDetails "TRX200204090000028", "Subscriber", NULL
go
-- 4/29/02 14:21:44.990 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:45.000 New connection (ID=39, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.040 SQL (ID=39, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:21:45.040 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:45.040 RPC (ID=39, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMisMatch "CMP200204290000001"
go
-- 4/29/02 14:21:45.040 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:45.120 New connection (ID=40, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.120 Attention signal (ID=39, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.170 Disconnection (ID=39, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.170 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:45.150 SQL (ID=40, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:21:45.180 Duration 0.030, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:45.210 RPC (ID=40, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMisMatch "CMP200204290000001"
go
-- 4/29/02 14:21:45.220 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:45.230 New connection (ID=41, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.240 SQL (ID=41, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:21:45.250 Duration 0.010, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:21:45.260 Attention signal (ID=41, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.250 RPC (ID=41, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMsg "TRX200204090000028"
go
-- 4/29/02 14:21:45.260 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:21:45.260 Disconnection (ID=41, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.260 Duration 0, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:21:45.260 Disconnection (ID=40, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:45.260 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:22.973 Attention signal (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:21:52.930 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_OverrideTranFailure NULL, "TRX200204090000028", "S", 2118, NULL
go
-- 4/29/02 14:22:23.023 Duration 30.093, CPU 0.260, Reads 252, Writes 2
-- 4/29/02 14:22:34.450 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_UserLogin "shall", "shall", 2, NULL, NULL, NULL
go
-- 4/29/02 14:22:34.570 Duration 0.120, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:22:36.733 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_ProcessedTransactionCounts NULL, NULL, NULL, NULL, NULL
go
-- 4/29/02 14:22:42.380 Duration 5.646, CPU 1.953, Reads 3, Writes 3
-- 4/29/02 14:22:46.736 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:22:46.806 Duration 0.070, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:22:49.040 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:22:49.090 Duration 0.050, CPU 0.030, Reads 0, Writes 0
-- 4/29/02 14:22:50.233 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:22:50.303 Duration 0.070, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:22:51.603 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:22:51.653 Duration 0.050, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:22:53.406 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_DetAllowOverride "TRX200204090000028", "Yes", NULL, NULL, NULL
go
-- 4/29/02 14:22:53.426 Duration 0.020, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.426 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_DetAllowResubmit "TRX200204090000028", NULL
go
-- 4/29/02 14:22:53.426 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.436 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranDetails "TRX200204090000028", "Subscriber", NULL
go
-- 4/29/02 14:22:53.436 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.666 New connection (ID=42, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:22:53.736 SQL (ID=42, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:22:53.736 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.736 RPC (ID=42, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMisMatch "CMP200204290000001"
go
-- 4/29/02 14:22:53.736 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.736 Disconnection (ID=42, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:22:53.736 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.786 New connection (ID=43, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:22:53.786 SQL (ID=43, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:22:53.786 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.786 RPC (ID=43, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMisMatch "CMP200204290000001"
go
-- 4/29/02 14:22:53.796 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.796 New connection (ID=44, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:22:53.806 SQL (ID=44, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:22:53.806 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.826 Disconnection (ID=43, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:22:53.826 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.826 Attention signal (ID=44, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:22:53.806 RPC (ID=44, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMsg "TRX200204090000028"
go
-- 4/29/02 14:22:53.826 Duration 0.020, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:53.826 Disconnection (ID=44, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:22:53.826 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:22:59.776 RPC (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_OverrideTranFailure NULL, "TRX200204090000028", "S", 2118, NULL
go
-- 4/29/02 14:23:20.896 Duration 21.120, CPU 12.198, Reads 69, Writes 9
-- 4/29/02 14:24:25.510 Disconnection (ID=38, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:25.510 Duration 199, CPU 16.314, Reads 462, Writes 17
-- 4/29/02 14:23:21.086 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:24:25.590 Duration 64.503, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:24:37.786 New connection (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:37.796 SQL (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
exec sp_server_info 500 select 501,NULL,1 where 'a'<>'A' select 504,c.name,c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config=1123 and f.value=c1.id and c1.csid=c.id set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off select 505,convert(smallint,substring(@@version,charindex('6.50.',@@version)+5,3)) set implicit_transactions off
go
-- 4/29/02 14:24:37.966 Duration 0.170, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:37.986 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_UserLogin "shall", "shall", 2, NULL, NULL, NULL
go
-- 4/29/02 14:24:38.006 Duration 0.020, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:40.450 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_ProcessedTransactionCounts NULL, NULL, NULL, NULL, NULL
go
-- 4/29/02 14:24:42.373 Duration 1.923, CPU 1.863, Reads 3, Writes 3
-- 4/29/02 14:24:44.676 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:24:44.736 Duration 0.060, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:24:46.690 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:24:46.740 Duration 0.050, CPU 0.010, Reads 0, Writes 0
-- 4/29/02 14:24:48.273 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:24:48.343 Duration 0.070, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:24:49.413 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:24:49.463 Duration 0.050, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:24:51.166 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_DetAllowOverride "TRX200204090000028", "Yes", NULL, NULL, NULL
go
-- 4/29/02 14:24:51.176 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.176 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_DetAllowResubmit "TRX200204090000028", NULL
go
-- 4/29/02 14:24:51.176 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.186 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranDetails "TRX200204090000028", "Subscriber", NULL
go
-- 4/29/02 14:24:51.186 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.186 New connection (ID=46, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.196 SQL (ID=46, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:24:51.196 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.206 Attention signal (ID=46, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.196 RPC (ID=46, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMisMatch "CMP200204290000001"
go
-- 4/29/02 14:24:51.206 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.206 Disconnection (ID=46, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.206 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.206 New connection (ID=47, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.216 SQL (ID=47, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:24:51.216 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.216 RPC (ID=47, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMisMatch "CMP200204290000001"
go
-- 4/29/02 14:24:51.226 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.226 New connection (ID=48, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.236 SQL (ID=48, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off set implicit_transactions off
go
-- 4/29/02 14:24:51.236 Duration 0.000, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.246 Disconnection (ID=47, SPID=112, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.246 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.246 Attention signal (ID=48, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.236 RPC (ID=48, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_GetFailedTranMsg "TRX200204090000028"
go
-- 4/29/02 14:24:51.246 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:51.246 Disconnection (ID=48, SPID=113, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
-- 4/29/02 14:24:51.246 Duration 0, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:24:56.163 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_OverrideTranFailure NULL, "TRX200204090000028", "S", 2118, NULL
go
-- 4/29/02 14:25:08.440 Duration 12.276, CPU 12.027, Reads 2, Writes 9
-- 4/29/02 14:25:08.630 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_CreateImportTranReport 2
go
-- 4/29/02 14:25:08.690 Duration 0.060, CPU 0.020, Reads 0, Writes 0
-- 4/29/02 14:25:27.730 RPC (ID=37, SPID=109, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_UserLogin "shall", "shall", 2, NULL, NULL, NULL
go
-- 4/29/02 14:25:27.740 Duration 0.010, CPU 0.000, Reads 0, Writes 0
-- 4/29/02 14:25:29.630 RPC (ID=45, SPID=110, User=user(OURDOMAIN\username), App='Internet Inform', Host='COMPNAME'(10b) )
udp_ProcessedTransactionCounts NULL, NULL, NULL, NULL, NULL
go
-- 4/29/02 14:25:31.503 Duration 1.873, CPU 1.863, Reads 4, Writes 4
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply