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 |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
 Posted - 2009-07-30 : 19:21:20
|
| We are seeing a wide difference (ordr of magnitude) in the size of the TempDB log file between what is reported in sys.master_files and what is reported by the Windows operating system. Our methodology is to pull the Size out of the sys.master_files table and convert the number of pages by page size and compare this number against what's in file manager. I don't expect an exact match but this seems excessive for round-off error.Also, sometimes Enterprise Manager will report a negative number for the percentage of free space for the file.We do operate in a 24x7 environment so the servers do not get restarted on any regular basis.Any ideas on what might be causing these discrepancies?=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-06-03 : 14:37:50
|
| Sooooo anyway...It appears that the numbers in sys.master_files is not in sync with sys.database_files. The latter seems accurate. The problem is that the sys.database_files table is local to each database. This link has code to work around this: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058=======================================A couple of months in the laboratory can save a couple of hours in the library. -Frank H. Westheimer, chemistry professor (1912-2007) |
 |
|
|
|
|
|
TempDB Log File Size - sys.master_files vs OS