Another benchmark test demonstrated support for 25,200 simulated
concurrent users and performed CRM transactions at the rate of 2,024
business processes per minute. These results were achieved on a
24-processor Unisys ES7000 database server and yielded average response
times between one and two seconds.
How do I convert an .MDB to SQL Server?
For Access 97: The Access Upsizing Wizard Free download:
http://www.microsoft.com/accessdev/prodinfo/aut97dat.htm
It preserves database structure including data, indexes, defaults,
and so on, and automatically converts Access validation rules and
defaults to the appropriate SQL Server equivalents. It also maintains
table relationships and referential integrity after upsizing.
For Access 2000: (Upgrading to an .ADP file) The upsizing
wizard is built in to the Access runtime. You can choose to create an
.MDB with SQL Server tables linked, or to an .ADP file. Provides all the
functionality of the Access 97 upsizing wizard.
These are the general SQL Server 97/2000 characteristics:
SQL
Object |
Maximum
sizes/numbers |
Connections per
client |
Maximum value
of configured connections |
Batch size |
65,536 *
Network Packet Size |
Bytes per short
string column |
8,000 |
Bytes per text,
ntext, or image column |
2 GB-2 |
Bytes per index |
900 |
Bytes per
primary key |
900 |
Bytes per
foreign key |
900 |
Bytes per row |
8,060 |
Clustered
indexes per table |
1 |
Bytes in source
text of a stored procedure |
Lesser of batch
size or 250 MB |
Columns per
index |
16 |
Columns per
primary key |
16 |
Columns per
foreign key |
16 |
Columns per
base table |
1,024 |
Columns per
INSERT statement |
1,024 |
Columns per
SELECT statement |
4,096 |
Database size |
1,048,516 TB |
Databases per
instance of SQL Server |
32,767 |
Filegroups per
database |
256 |
File size
(data) |
32 TB |
Files per
database |
32,767 |
Identifier
length (in characters) |
128 |
Nested stored
procedure levels |
32 |
Locks per
connection |
Max. locks per
server |
Nested
subqueries |
32 |
Nested trigger
levels |
32 |
Objects in a
database |
2,147,483,647 |
Nonclustered
indexes per table |
249 |
Parameters per
stored procedure |
1,024 |
REFERENCES per
table |
253 |
Rows per table |
Limited by
available storage |
Tables per
database |
Limited by
number of objects in a database |
Tables per
SELECT statement |
256 |
UNIQUE indexes
or constraints per table |
249
nonclustered and 1 clustered |
Triggers per
table |
Limited by
number of objects in a database |
|