[dba-SQLServer] Block size for SQL Server disk

John W. Colby jwcolby at colbyconsulting.com
Thu Aug 19 15:01:05 CDT 2004


I have purchased new disks to build this new SQL Server database on.  I
believe I have read that SQL Server uses 8k block sizes internally.  Is it
useful to format the hard disk to 8K sectors so that the SQL blocks map to
sectors directly?  Does anyone know if this helps or hinders?

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John
Maxwell @ London City
Sent: Thursday, August 19, 2004 1:58 PM
To: 'dba-sqlserver at databaseadvisors.com'
Subject: RE: [dba-SQLServer] Timeout


I also get this problem using the query builder in EM but fine when use
Query analyser

If in rush for results may be worth switching while waiting for a proper
solution to be posted.


Regards

john

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W.
Colby
Sent: 19 August 2004 18:39
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Timeout


I am trying to run a simple count query on this big db I'm building.  The
SQL is 

SELECT     COUNT(ID) AS Cnt
FROM         dbo.Conduit

Which is built by the query builder in EM.  The query times out.
[Microsoft][ODBC SQL Server Driver]Timeout Expired.  Anyone have a clue
where I go to increase this value so I can get a count.  ID BTW is the
"autonumber" PK.

John W. Colby
www.ColbyConsulting.com 



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


The contents of this email and any attachments are sent for the personal
attention of the addressee(s) only and may be confidential.  If you are not
the intended addressee, any use, disclosure or copying of this email and any
attachments is unauthorised - please notify the sender by return and delete
the message.  Any representations or commitments expressed in this email are
subject to contract. 
 
ntl Group Limited

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com







More information about the dba-SQLServer mailing list