SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

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

published 591 days, 15 hours, 19 minutes ago posted by

sa 600 days, 17 hours, 15 minutes ago

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

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...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: alignment, benchmarking, Best Practices, core, cpu, DBA, disk, raid, SQL Server, storage, tempdb

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

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

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

Open ID Login

Standard Login

Forgot Password?

Sign up