Skip to content

조회 수 18425 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

SQL Server Maximum Capacity

 

 

SQLLeader.com

Object

Maximum sizes/numbers

Maximum sizes/numbers

Maximum sizes/numbers

SQL Server 7 (32-bit)

SQL Server 2000 (32-bit)

SQL Server 2005 (32-bit)

Batch size

65,536 * Network Packet Size

65,536 * Network Packet Size

65,536 * Network Packet Size

Bytes per short string column

8,000

8,000

8,000

Bytes per text, ntext, image, varchar(max), nvarchar(max), varbinary(max), or XML column

231 -2 bytes

231 -2 bytes

231 -1 bytes

Bytes per GROUP BY, ORDER BY

8,060

8,060

8,060

Bytes per index

900

900

9001

Bytes per foreign key

900

900

??2

Bytes per primary key

900

900

900 - Not listed, but since this will be an index, the index guidelines should apply.

Bytes per row

8,060

8,060

8,060

Bytes in source text of a stored procedure

Lesser of batch size or 250 MB or 128MB3

Lesser of batch size or 250 MB or 128MB3

128MB

Clustered indexes per table

1

1

1

Columns in GROUP BY, ORDER BY

Limited only by number of bytes

Limited only by number of bytes

Limited only by number of bytes

Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement

10

10

10

Columns per index

16

16

164 5

Columns per foreign key

16

16

164

Columns per primary key

16

16

164

Columns per base table

1,024

1,024

1,024

Columns per SELECT statement

4,096

4,096

4,096

Columns per INSERT statement

1,024

1,024

1,024

Connections per client

Maximum value of configured connections (32,767 max)

Maximum value of configured connections (32,767 max)

Maximum value of configured connections (32,767 max)

Database size

1,048,516 terabytes

1,048,516 terabytes

1,048,516 terabytes

Databases per instance of SQL Server

32,767

32,767

32,767

Filegroups per database

256

256

32,767

Files per database

32,767

32,767

32,767

File size (data)

32 terabytes

32 terabytes

32 terabytes

File size (log)

32 terabytes

32 terabytes

32 terabytes

Foreign key table references per table

253

253

253

Identifier length (in characters)

128

128

128

Instances per computer

16

16

50

Length of a string containing SQL statements (batch size)

65,536 * Network packet size

65,536 * Network packet size

65,536 * Network packet size

Locks per connection

Maximum locks per server

Maximum locks per server

Maximum locks per server

Locks per instance of SQL Server

Up to 2,147,483,647

Limited only by memory

Limited to 60% of memory

Nested stored procedure levels

32

32

32

Nested subqueries

32

32

no limit, at least according to Beta 2 BOL

Nested trigger levels

32

32

32

Nonclustered indexes per table

249

249

249

Objects concurrently open in an instance of SQL Server

2,147,483,647 per database (depending on available memory)

2,147,483,647 per database (depending on available memory)

2,147,483,647 per database (depending on available memory)

Objects in a database

2,147,483,647

2,147,483,647

2,147,483,647

Parameters per stored procedure

2,100

2,100

2,100

Parameters per user-defined function

2,100

2,100

2,100

REFERENCES per table

253

253

253

Rows per table

Limited by available storage

Limited by available storage

Limited by available storage

Tables per database

Limited by number of objects in a database

Limited by number of objects in a database

Limited by number of objects in a database

Tables per SELECT statement

256

256

256

Triggers per table

Limited by number of objects in a database

Limited by number of objects in a database

Limited by number of objects in a database

UNIQUE indexes or constraints per table

249 nonclustered and 1 clustered

249 nonclustered and 1 clustered

249 nonclustered and 1 clustered

 

Footnotes

 

 

 

1 - By including nonkey columns in the index, you can exceed the 900 byte limit as these columns (used in covering queries) are not computed as part of the 900 byte limit.

2 - I could not find this listed in the SQL Server 2005 Beta 2 BOL.

3 - The Maximum Capacity Specifications shows the less or the batch size or 250MB, however Books Online shows 128MB in the entry for

4 - The 16 column limit is for key columns. Additional columns can be included (as in footnote 1) beyond the 15.

5 - Not valid for XML indexes.

TAG •

List of Articles
번호 제목 글쓴이 날짜 조회 수
39 [MS-SQL] MS-SQL 2000 이하에서 지원되던 오래된 쿼리 2008 이... ADMINPLAY 2014.09.28 4086
38 MicroSoft SQL Server 2008 1433 port 원격(외부)접속 허용하기 ADMINPLAY 2014.09.20 4138
37 SET LOCK_TIMEOUT ADMINPLAY 2012.01.16 13829
36 SQL Server 2008 R2 버전에서 지원하는 기능 ADMINPLAY 2011.03.30 15948
35 Fatal error: Call to undefined function: mssql_connect() ADMINPLAY 2010.06.03 22271
34 DBCC SHRINKFILE 트랜잭션 로그파일 축소 l2zeo 2010.05.29 21360
33 마소제공 mssql 관리툴 ADMINPLAY 2010.04.23 19547
32 SQL Server 데이터 파일 축소 l2zeo 2010.03.28 20419
31 [FAQ]join을 하다가 막혔어요.. l2zeo 2010.02.25 16415
30 [FAQ]mssql2005 디버깅 어떻게 해야 하나요? file l2zeo 2010.02.25 20687
29 [FAQ]하나의 서버에 두개의 database를 설치하려고 합니다. l2zeo 2010.02.25 19287
28 데이터 원본에 저장 프로시저 사용하기 file l2zeo 2010.02.25 18360
» MSSQL 버전별 최대 용량 비교표 l2zeo 2010.02.24 18425
26 SQL Server 2008의 새로운 기능 - Parameter Embedding Optimi... l2zeo 2010.02.24 17008
25 SQL서버 성능카운터 활용을 위한 팁 file l2zeo 2010.02.24 19802
24 SQL Server 2005 백업 설정 방법 file l2zeo 2010.02.24 17672
23 SQL Agent 작업 실행 상태 확인하기 l2zeo 2010.02.23 17782
22 DB 서버에 특정 IP 접근 차단 방법 file l2zeo 2010.02.21 20949
21 [MSSQL 2000] 성능 모니터링 file l2zeo 2010.02.21 14741
20 [SQL Server] Build Number of Each Version of SQL Server - ... ADMINPLAY 2009.12.20 16623
Board Pagination Prev 1 2 Next
/ 2

Copyright ADMINPLAY corp. All rights reserved.

abcXYZ, 세종대왕,1234

abcXYZ, 세종대왕,1234