article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Books Online (BOL) References: ​​ All BOL references cited in this paper are taken from the Microsoft SQL Server 2000 Books Online site (updated to include SP3 functionality), which can be found at: [link] Click the Product Documentation link. SQL Server 2000/7.0 data pages are 8 KB in size.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

The ​​ SQL Server 2000 I/O Basics ​​ document is a prerequisite to ​​ the information contained in this ​​ document. and ​​ 2000. ​​ Read it before you read this paper.

Servers 40
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Different Software Testing Types Explained

Testsigma

However, when a promotion is running, the number of users may increase to 2000, in this case, the application is tested for a load of 2000 users also because this is expected load. How well the application accommodates the changes and updates done on the code or system, comes under maintainability testing.

article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently.

Servers 90
article thumbnail

Stuff The Internet Says On Scalability For September 14th, 2018

High Scalability

Thus, despite both quoting 11 nines of durability against hardware failures, S3 is durable against failures that B2 is not, and is thus better. IBM still dominates mainframes and Microsoft still dominates PC operating systems and productivity software. noahsussman : Complex systems are intrinsically hazardous systems.