1
kudos
spam Kudos Remove

TSQL script to obtain I/O utilization characteristics of each filegroup and the databases
published 874 days, 8 hours, 29 minutes ago posted by sasa 883 days, 20 hours, 36 minutes ago
Thursday, December 31, 2009 9:35:27 PM GMT Tuesday, December 22, 2009 9:28:10 AM GMT
TSQL script to obtain I/O utilization characteristics of each filegroup and the databases
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. SQL Server builds a buffer pool in memory to hold pages read from the database. Much of the code in SQL Server is dedicated to minimizing the number of physical reads and writes between the disk and the buffer pool. On the same line if we talk about I/O, then the primary purpose of a SQL Server database is to store and retrieve data, so intensive...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: Best Practices, configuration, disk, DMV, i/o, reads, Scheduler, SQL Server, TSQL, writes

1 comment posted.

To post your comment please login or signup