Wah blm ada yg share.
Ini nyari2 di inet, ada beberapa referensi tapi blm lengkap.
Microsoft SQL Server also allows user-defined composite types (UDTs) to be defined and used. It also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). In addition to tables, a database can also contain other objects including views, stored procedures, indexes and constraints, along with a transaction log. A SQL Server database can contain a maximum of 2 objects, and can span multiple OS-level files with a maximum file size of 2 TB. The data in the database are stored in primary data files with an extension .mdf. Secondary data files, identified with a .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension.
File otomax.ndf ada gak ya? Kalau ada letaknya di mana?
SQL Server buffers pages in RAM to minimize disc I/O. Any 8 KB page can be buffered in-memory, and the set of all pages currently buffered is called the buffer cache. The amount of memory available to SQL Server decides how many pages will be cached in memory. The buffer cache is managed by the Buffer Manager. Either reading from or writing to any page copies it to the buffer cache. Subsequent reads or writes are redirected to the in-memory copy, rather than the on-disc version. The page is updated on the disc by the Buffer Manager only if the in-memory cache has not been referenced for some time. While writing pages back to disc, asynchronous I/O is used whereby the I/O operation is done in a background thread so that other operations do not have to wait for the I/O operation to complete. Each page is written along with its checksum when it is written. When reading the page back, its checksum is computed again and matched with the stored version to ensure the page has not been damaged or tampered with in the meantime.
Pantas saja server Otomax memerlukan kapasitas RAM yang besar karena hampir selalu operasi data dilakukan di RAM.
Keuntungannya adalah kalau database replikasi ditaruh di flash disk maka flash disk akan awet. Coba kalau file mdf selalu dibuka tutup tiap kali ada data baru, dijamin sebentar saja flash disk akan hangus. Karena umur flash disk ditentukan oleh jumlah operasi I/O. Kira2 10.000 s/d 100.000 kali baca tulis flash disk akan jebol.
Kerugiannya atau yang masih membingungkan saya:
Kapan file .mdf akan dimodifikasi? Karena kalau tidak diupdate berarti isi file tsb tdk relevan dgn data terkini. Dan kalau sebagian besar proses baca tulis dilakukan di RAM, apa yang terjadi kalau komputer mati mendadak? Herannya sudah beberapa kali komputer saya mati mendadak tapi database selalu aman dan data trx sampai yg terakhir juga tetap ada.
