Storage area networks are getting larger and more sophisticated. One of the problems I face as SQL consultants is running sqlio on them. One common stumbling block is the size of the cache on some storage area networks can be huge (128GB plus), especially with the use of solid state devices as a tier “zero” … Continue reading SQLIO tip #1 Dealing with large SAN cache
Tag: SQL IO
This is fairly well documented in various books and white papers, but can be tricky to find out on the Internet so I am summarising it here in this blog. The key questions is “what are SQL Server’s I/O Characteristics”. This helps answer questions like why is a 1MB block size bad; why don’t we … Continue reading SQL IO Characteristics