 | |
Performance of SQL query for reading from trace file
microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Performance of SQL query for reading from trace file -
02-21-2008
, 08:35 AM
#2
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#3
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#4
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#5
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#6
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#7
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#8
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#9
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
#10
| |||
| |||
|
|
I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from fn_trace_gettable('c:\traces\trace.trc', 1); This query takes around 133 sec to fetch records and the time taken to run the query increases as the size of the file increases. Please let me know how can i tune the query so that the query becomes faster. Note: I cannot use a where clause for fetching data, I have to fetch all the records at once. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.