Skip to content

[레벨:19]id: id: l2zeo
댓글 0 조회 수 18257 추천 수 0
?

단축키

이전 문서

다음 문서

+ - Up Down Comment Print
?

단축키

이전 문서

다음 문서

+ - Up Down Comment Print

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 •

?Who's l2zeo

profile

I see no changes, wake up in the morning and I ask myself

Is life worth living should I blast myself

Things would never be the same.


번호 제목 글쓴이 날짜 조회 수
39 [MS-SQL] MS-SQL 2000 이하에서 지원되던 오래된 쿼...   [레벨:30]id: ADMINPLAY 2014.09.28 3903
38 MicroSoft SQL Server 2008 1433 port 원격(외부)접...   [레벨:30]id: ADMINPLAY 2014.09.20 3972
37 SET LOCK_TIMEOUT   [레벨:30]id: ADMINPLAY 2012.01.16 13682
36 SQL Server 2008 R2 버전에서 지원하는 기능  image [레벨:30]id: ADMINPLAY 2011.03.30 15717
35 Fatal error: Call to undefined function: mssql_co...   [레벨:30]id: ADMINPLAY 2010.06.03 22093
34 DBCC SHRINKFILE 트랜잭션 로그파일 축소   [레벨:19]id: id: l2zeo 2010.05.29 21183
33 마소제공 mssql 관리툴   [레벨:30]id: ADMINPLAY 2010.04.23 19373
32 SQL Server 데이터 파일 축소   [레벨:19]id: id: l2zeo 2010.03.28 20254
31 [FAQ]join을 하다가 막혔어요..   [레벨:19]id: id: l2zeo 2010.02.25 16259
30 [FAQ]mssql2005 디버깅 어떻게 해야 하나요?  fileimage [레벨:19]id: id: l2zeo 2010.02.25 20514
29 [FAQ]하나의 서버에 두개의 database를 설치하려고 합니...   [레벨:19]id: id: l2zeo 2010.02.25 19112
28 데이터 원본에 저장 프로시저 사용하기  fileimage [레벨:19]id: id: l2zeo 2010.02.25 18178
» MSSQL 버전별 최대 용량 비교표   [레벨:19]id: id: l2zeo 2010.02.24 18257
26 SQL Server 2008의 새로운 기능 - Parameter Embedd...   [레벨:19]id: id: l2zeo 2010.02.24 16846
25 SQL서버 성능카운터 활용을 위한 팁  file [레벨:19]id: id: l2zeo 2010.02.24 19645
24 SQL Server 2005 백업 설정 방법  fileimage [레벨:19]id: id: l2zeo 2010.02.24 17528
23 SQL Agent 작업 실행 상태 확인하기   [레벨:19]id: id: l2zeo 2010.02.23 17626
22 DB 서버에 특정 IP 접근 차단 방법  fileimage [레벨:19]id: id: l2zeo 2010.02.21 20788
21 [MSSQL 2000] 성능 모니터링  fileimage [레벨:19]id: id: l2zeo 2010.02.21 14580
20 [SQL Server] Build Number of Each Version of ...   [레벨:30]id: ADMINPLAY 2009.12.20 16406
Board Pagination ‹ Prev 1 2 Next ›
/ 2
Designed by hikaru100

나눔글꼴 설치 안내


이 PC에는 나눔글꼴이 설치되어 있지 않습니다.

이 사이트를 나눔글꼴로 보기 위해서는
나눔글꼴을 설치해야 합니다.

설치 취소

SketchBook5,스케치북5

SketchBook5,스케치북5

SketchBook5,스케치북5

SketchBook5,스케치북5

Copyright ADMINPLAY corp. All rights reserved.

abcXYZ, 세종대왕,1234

abcXYZ, 세종대왕,1234