April 2007 - Posts

• Performance Impact of Frequent Logins (Actually Performance Impact of Frequently Calling SqlConnection.Open() with Connection Reset)

  Recently, a question came up regarding whether frequent logins from .NET applications--as observed with the prefmon counter SQLServer:General Statistics\Logins/sec--would have a significant performance impact. This is obvious an empirical question that Read More... Posted Monday, April 16, 2007 4:25 PM by Linchi Shea | 4 Comments Attachment(s): logins.gif

• How did Random I/Os Outperform Sequential I/Os?

  Recently, when I was doing some I/O performance tests on an I/O path, I found that 8K random reads (and writes) significantly and consistently outperformed 8K sequential reads (and writes) in terms of I/O throughput (megabytes per second). I was puzzled. Read More... Posted Wednesday, April 04, 2007 4:14 PM by Linchi Shea | 6 Comments Filed under: Performance, SAN, Storage, Testing