1
kudos
spam Kudos Remove

SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
published 968 days, 15 hours, 34 minutes ago posted by sasa 971 days, 7 hours, 23 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 10:07:43 PM GMT
SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
Do you consider the I/O whenever a database design project is assigned? It is one of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Over the time it may be one of the criteria that extensive usage of data and defautl behaviour on SQL Server builds a buffer pool in memory to hold pages read from the database. While queries are getting designed the code must be optimized and dedicated to minimizing...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: capacity, disk, i/o, input, Memory, Monitoring, Performance, SQL Server, statistics, Tools

No comments yet, be the first one to post comment.

To post your comment please login or signup