MSSQL Server 2005数据库表容量 [英] MSSQL server 2005 database tables capacity

问题描述

请告诉我，如果我经常在每天大约25000条记录的MSsql表中插入数据，并且表中的总行为25,00,000.因此，在这种情况下，是否有丢失或无法在sql表/数据库中插入数据的机会????

please tell me if frequently I am inserting data in table of MSsql approx 25000 records per day, and total rows in a table are 25,00,000. So in this case is any chance of loss or fail to insert data in sql table/database ????

推荐答案

Sql服务器不受行数的限制，尽管如果您正在使用int 主键，在无法访问前，主行限制为40亿行.

主要限制是当您使用Sql Express时，该数据库限制为4gb数据库文件(2008已将其升级为10gb).

Sql server is unlimited by row count, although if you are using int primary keys you are limited to 4 billion rows before you can''t access them.

The main limit is when you are using Sql Express which is limited to 4gb database file (2008 has up''ed it to 10gb).

正如Mehdi指出的那样，空间，至少如果使用Standard Edition或Enterprise Edition.

注意事项:
-数据丢失的风险不取决于数据量.您总是有风险，为此做好准备
-创建良好的备份计划并实施
-即使在高工作负载下也要确保性能足够，请专注于合理的索引编制
-如果要查询很多行，请确保您有足够的内存
-照顾SQL重用

As Mehdi pointed out, there''s plenty of room, at least if you use Standard or Enterprise Edition.

Few things to note:
- the risk of data loss isn''t dependent on the amount of data. You always have the risk, prepare for it
- create a good backup plan and implement it
- ensure that the performance is adequate even with high workload, concentrate on reasonable indexing
- if lots of rows are queried, ensure that you have enough memory
- take care of sql reusing

这篇关于MSSQL Server 2005数据库表容量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！