Geek Answers Handbook

LDF is not updated, ok?

I have a problem with a site that went very slowly, so just check the database, etc.

So, at the moment, my

The MDF file is 320 MB and the LDF file is 18 MB

The only thing I noticed was strange was that the LDF file was not updated for 4 days by date Modified when I know that there were database transactions, just wondering if this is possible?

If not, how can I solve it

+4
source share
3 answers

The date modified for the LDF file is probably not a good metric to check. I have several databases that I know are available every day, and some log files are reported as not being changed by the file system for several months.

It is better to check if you expect database performance to be a problem, try to identify any parts of the site that are particularly slow and use SQL Profiler to find out which database operations take longer than usual.

+2
source

I believe that while the file remains open (what will happen until the database is online), the last modified date will not be updated.

I think that it is updated only when the file is first opened for modifications and / or when it is closed. You should not rely on file system-based tools to check the status of SQL Server — use tools built into SQL Server (such as performance counters, SQL logs) or Management Studio (such as Activity Monitor).

For sluggishness, you can see if excessive resource expectations occur, and if so, what types (for example, a lock is waiting or waiting for input / output).

+3
source

StevieB,

SQL has MDF files, they are used to store data, and LDF log files mainly store the list of changes in the database over time, LDF can be changed depending on the recovery mode of the database, if in full mode it will write everything, if just not at all.

Do not worry that this does not change. SQL Server knows what to do.

Greetings

Yane

0
source

More articles:


All Articles