?
Solved

Optimum Block Size for SQL Server 2003 Enterprise

Posted on 2004-09-17
2
Medium Priority
?
319 Views
Last Modified: 2006-11-17
Hello Techies:

We're building a IBM X445 SQL server. It has a 256 Meg Cache.  We will be using SQL Server 2003 Enterprise.  My question is:  What is the optimum block size for SQL Server 2003 enterprise?
0
Comment
Question by:sprysurfer
2 Comments
 
LVL 6

Expert Comment

by:mcp111
ID: 12086916
There is no SQL Server 2003. Is it SQL 2000?
0
 
LVL 8

Accepted Solution

by:
MartinCMS earned 2000 total points
ID: 12087257
Check out this site.... might be useful info for you concern...

http://www.ftponline.com/wss/2003_08/magazine/columns/sqlconnection/default_pf.aspx
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question