Re: basic tlog question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 07:39:12 +0100

Yes, the log records are written to memory too, to an area called 'log
cache', and SQL Server has a logic to make sure these cached log records are
written to log files, before the associated dirty pages are written to disk. 

-- 
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hassan" <fatima_ja@hotmail.com> wrote in message
news:e3WwGOvaEHA.3524@TK2MSFTNGP12.phx.gbl...
> whenever a transaction or a SQL statement executes, do the changes get
> written to the log file first ? I know they do, but are they also in
> memory.. I understand the part where dirty pages are written to disk.. at
> checkpoints or lazy writers or thru worker threads...what im a bit
confused
> is when it talks about writing to disk, is it referring to the data files
on
> disk or the log files on disk..
>
> Can someone just give me a 2 to 3 liner on the initial part before the
data
> actually gets written to the disk i.e. disk that contains the data files ?
>
>

Relevant Pages

  • Re: SQL Resets
    ... SQL Server Support or from another SQL Server experts provider. ... now but you can be suffering from memory bottleneck or problems ... Disk Read Queue Length ...
    (microsoft.public.sqlserver.connect)
  • Re: Raid
    ... > As the Raid control, controls the writing of data to the disk, ... > keeping data and log files in different disk will not help ... Performance Tuning SQL Server Hardware ... How to Performance Tune Microsoft SQL Server During Setup (File Location ...
    (microsoft.public.sqlserver.setup)
  • Re: Performance Monitor Results
    ... SQL Server MVP ... > drive or the memory? ... > Processor Queue Length 5 ... > Disk Reads per second 173 ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
    ... you can use the stream benchmark to measure the memory ... If the box itself checked out fine, then move on to runnign SQL Server on ... Perfmon, Disk I/O, Pages, Profiler traces, checked locks/blocks, long running ... slow on these boxes to me. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Resets
    ... I don't believe this to be a SQL Server side issue. ... be suffering from memory bottleneck or problems with excesive locking or... ... Disk Read Queue Length ...
    (microsoft.public.sqlserver.connect)