MSDE files

Hello together,
i'm looking for a documentation about the MSDE 2000 which
can tell me what files will be installed, where they can be
found and what task they have (i need to know what process
stores, reads and changes the data in the .mdf, .ndf and
..ldf files)
Thanks in advance for every help you have.
hi,
hph wrote:
> Hello together,
> i'm looking for a documentation about the MSDE 2000 which
> can tell me what files will be installed, where they can be
> found and what task they have (i need to know what process
> stores, reads and changes the data in the .mdf, .ndf and
> .ldf files)
> Thanks in advance for every help you have.
I really do not know if such a documentation exists at all..
providing the the "Storage Engine" shold be the "beast" you have to care
about, it is built of
Transaction Manager
Row Operation Manager and Index Manager
Lock Manager
Page Manager and Text Manager
File/Device Manager
Buffer Manager/Log Manager
Sort Manager
others..
that communicates with the "I/O Manager" for synchronous and asynchronous
I/O and/or Scatter-Gather I/O when available
the I/O Manager performs it's activities via Win32 APIs
the process should always be sqlservr.exe, if you need to attach a debugger
to it like WinDbg, as all component are ddl that are loaded as required...
what happens is that client requests come to SQL Server via the installed
Net-Libraries, that are then scheduled for precessing to the U(ser) M(mode)
S(cheduler[s]) that replaces standard Windows threads for SQL Server, as SQL
Server creates 1 UMS for each available cpu and all related threads are
managed by each UMS in order to reduce, when possible, kernel mode switches
and thread suspends based on the native Windows scheduler; the L(anguage)
P(rocessing and) E(xecution) component inside SQL Server takes care to for
each request, passing them to the Q(uery) P(rocessor) for optimization
(these 2 components are part of the Relational Engine)... once a request has
been transalated to a query, optimized and the relative execution plan is
produced, LPE executes it calling the Storage Engine via OLE-DB interfaces,
that performs I/O activities;
additionally BPool and MemToLeave Memory Managers are involved, in order to
try accessing large numbers of noncontiguos buffers without concerning about
physical position/proximity to the I/O requirements (again, when
asynchronous and Scatter-Gather I/O access is available; ie not possible on
Win9x installations as these kind of APIs are not supported, or when the
physical database's files are stored on NTFS compressed volumes)
but actually I do not know what exactly is in which dll..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply