Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2002-03-11 : 05:48:16
|
| Salute..how do I empty the sql.log file,that is, ODBC tracing file!..does shrink file work here?Thanks------------------If I am to do it,I will, and NOW ..Edited by - Da_Retina on 03/11/2002 05:52:25Edited by - Da_Retina on 03/11/2002 08:42:00 |
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-11 : 08:43:01
|
Salute..I found my way guys..the rightoues way! ------------------If I am to do it,I will, and NOW .. |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-11 : 08:56:26
|
| Retina , its always good to update your post with the final solution you come up with.it helps lot of people.-------------------------------------------------------------- |
|
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-11 : 09:14:22
|
I guess U r RIGHT!.This file is the ODBC tracing log file,located in the root directory.I stopped the tracing..restarted cuz the file was still couldnt be deleted as it was being used by the system..when restarted I stopped SQL server..deleted the file manually and kept the ODBC tracing off!..I dont need it right away!..I can tell U that i had procedures talking to Linked Servers used to take 20 minutes ,TOOK ONLY 2 MINUTES when I turned the tracing off!IT IS A PERFORMANCE KILLER..and a HARDDISK SUCKER!!! ------------------If I am to do it,I will, and NOW .. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-11 : 10:16:10
|
| the file Retina is referrign to is Stats.log i think. that is used when Log ODBC driver statistics to the log file option is set.therez a another log file Query.Log this is used when Save long running queries to the log filei have never used them. wondering the best possible use of these options? .-------------------------------------------------------------- |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-11 : 10:22:50
|
| Query Logging and ODBC trace logging is mostly intended for troubleshooting. If you're not having any problems you should turn them off; as you noticed they're performance killers. |
|
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-12 : 01:21:53
|
| well No Nazim..it is sql.log ! not stats.log nor query.log.If u go to the control panel in Win NT and then to the ODBC data sources applet then go to tracing U will find the file I mean..It is sql.log that is used to trace calls to ODBC drivers that can be used by Visual Stodio Analyzer to debug ODBC problems!Yes, Dear ROB..it is a PERFORMANACE SLAYER!!..Salute..------------------If I am to do it,I will, and NOW .. |
|
|
|
|
|
|
|
|
SQL.LOG