Finding the NTFS Sector Size via DBCC

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.  

1

SQL Server 2005 Service Pack 2 required for Longhorn & Vista

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 the CTP details). A more detailed explanation on SQL Support for Longhorn & Vista is posted here: http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

1

Updates to MPS Reports, Support for 64-Bit

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 some of the MPS tool variants support 64-Bit e.g. the…

0

Take a look at SQLIOSim

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.

0

SQL Server 2005 Failover Clustering Whitepaper

Is now available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

0