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 |
|
mcrowley
Aged Yak Warrior
771 Posts |
 Posted - 2005-07-29 : 16:09:32
|
| I have what is probably a simple question that I can not really test in order to get an answer. According to Books Online, in the article "Transactions Data Columns", the Integer Data column for the TransactionLog EventClass is listed as (and I quote)[quote=BOL]The length of the log record.[/quote]Does anyone happen to know what units that is in? My old physics professor would have a fit over this. I am assuming it is in bytes, but I just want to be sure. Thanks in advance for any help. |
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-07-29 : 18:04:14
|
| Inches, or in the case of larger, enterprise-sized logs, feet.SQL2K5 has finally made the conversion to metric, so interpret accordingly.(Sorry - I couldn't resist.)Yes, the value of this column indicates the length of the particular log record in bytes. There are tools that let you "see" what log the records look like, and if you are delving in this deep, you may enjoy playing with some of them. |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-08-01 : 09:20:37
|
| Thanks, Klang. I was going to try to pass it off to the business users as rods, just because not many people remember what rods are used for. |
|
|
|
|
|
|
Profiler Transaction Log Event definition