October 2006 - Posts
You can determine the formatted sector size of the database using DBCC FILEHEADER ('<dbname>'). The DBCC command actually returns quite a lot of information but we are only interested in the sector size column.
Read More...
In case you were wondering, Longhorn & Vista will only support SQL Server 2005 Service Pack 2. This should be out as a Community Technology Preview (CTP) build sometime soon (I'll blog about the forthcoming changes once we have publicly announced
Read More...
Well, not what I'd call a big update to MPS reports but still worth noting if you intend gathering diagnostic data for a 64-Bit environment. The download page for MPS report has been updated (following a recent discovery on a x64 PoC) to reflect that
Read More...
Only just seen this via the SQL Server Storage blog here http://blogs.msdn.com/sqlserverstorageengine/archive/2006/10/06/SQLIOSim-available-for-download.aspx SQLIOSim certainly looks interesting and seems a step beyond sqliostress.
Read More...
Is now available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Read More...
