D
dyk
Hello!
I'am trying to run T-SQL query based on stored procedure and I was surprised
by essential diferences in the time of execution of the same query using
..NET application & SQL Query Analizer.
The results of analyzing my query (using SQL Profiler) are bellow:
1.------------------------------------------------
TEXTDATA: EXEC WayBillBrowse @PersonalAccountNumber = NULL, @GarageNumber =
NULL, @RegSign = NULL, @FromDate = 'Jul 1 2003 12:00:00:000AM', @ToDate =
'Sep 1 2003 12:00:00:000AM', @Status1 = 1, @Status2 = 2, @Status3 = 3,
@Status4 = NULL, @Status5 = NULL
APPLICATION NAME: SQL Query Analyzer
CPU: 1252
READS: 133327
WRITES: 0
DURATION: 2683
2.------------------------------------------------
TEXTDATA: the same
APPLICATION NAME: .Net SqlClient Data Provider
CPU: 50843
READS: 1562583
WRITES: 0
DURATION: 53266
---------------------------------------------------
Could you please explain why results so different?
I'm using
Client: .NET Framefork 1.1, Windows XP (SP1), 512 Mb RAM
Server: SQL Server 2000 Dev. (SP3) ,Windows Server 2K SP4 (no other users
connected)
Thank you.
I'am trying to run T-SQL query based on stored procedure and I was surprised
by essential diferences in the time of execution of the same query using
..NET application & SQL Query Analizer.
The results of analyzing my query (using SQL Profiler) are bellow:
1.------------------------------------------------
TEXTDATA: EXEC WayBillBrowse @PersonalAccountNumber = NULL, @GarageNumber =
NULL, @RegSign = NULL, @FromDate = 'Jul 1 2003 12:00:00:000AM', @ToDate =
'Sep 1 2003 12:00:00:000AM', @Status1 = 1, @Status2 = 2, @Status3 = 3,
@Status4 = NULL, @Status5 = NULL
APPLICATION NAME: SQL Query Analyzer
CPU: 1252
READS: 133327
WRITES: 0
DURATION: 2683
2.------------------------------------------------
TEXTDATA: the same
APPLICATION NAME: .Net SqlClient Data Provider
CPU: 50843
READS: 1562583
WRITES: 0
DURATION: 53266
---------------------------------------------------
Could you please explain why results so different?
I'm using
Client: .NET Framefork 1.1, Windows XP (SP1), 512 Mb RAM
Server: SQL Server 2000 Dev. (SP3) ,Windows Server 2K SP4 (no other users
connected)
Thank you.