TSQL to monitor the I/O pending for each database and I/O writes, sizes- DMV

When you think about database design, always think about performance too! The primarydesign goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Every applicaton is a memory hungry and SQL Server is no exceptional to that which builds a buffer pool in memory to hold pages read from the database. This is where the performance is hampered if the specific code or TSQL must be written in minimizing the number of physical...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/09/07/9495.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9495" width="1" height="1">