SQL Server Performance Forum – Threads Archive

SQL Server i/o sizes

Are all SQL server i/o’s 8k? Tradeco wholesalers, drop shippers & trade network

And at the same time, how many threads will be requesting io? Is it a fixed number (the lazy writer, log writer etc) or is it affected by how many user connections there are? Tradeco wholesalers, drop shippers & trade network

Check the following…
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Yeah thanks. Got that earlier today, and saw the io sizes. Anything about threads. Reason I ask is because I’m looking at using sqlio to benchmark a server, and it can vary number of threads and io size Tradeco wholesalers, drop shippers & trade network

]]>