SQL Server Performance

SQL Server Perf: What is the optimal disk or data file placement configuration layout for better performance?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 29, 2010.

  1. Anonymous New Member

    SQL Server manages when and how disk I/O is performed, but the Windows operating system performs the underlying I/O operations. The I/O subsystem includes the system bus, disk controller cards, disks, tape drives, CD-ROM drive, and many other I/O devices. Disk I/O is frequently the cause of bottlenecks in a system. Having said that SQL Server uses the specific storage ages of TEMPDB, Transaction log file and database files, whereever you see the best practice always dictate that seperating TEMPDB...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2010/09/29/9427.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9427" width="1" height="1">

Share This Page