Re: database size vs. its performance
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 23 Nov 2008 19:33:03 +0000 (UTC)
aleu@xxxxx (aleu@xxxxx) writes:
If we assume that there are two databases A and B, which have identical
schema but different number of records (say A is 10GB and B is 1TB),
they use 2 identical servers and SAN for their data storage, is it fair
to say that the physical DB size in this case will not play any role on
the performance and both databases will offer similar performance?
Maybe. Maybe not. It depends, as we have said, how well the indexing
aligh with the queries. But if your queries are of the kind that they
have to traverse all rows, then size will matter a whole lot.
I'm afraid that your questions are too simpleminded to yield very good
answers.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- database size vs. its performance
- From: aleu@xxxxx
- Re: database size vs. its performance
- From: aleu@xxxxx
- database size vs. its performance
- Prev by Date: Re: SELECT locking: EXACTLY HOW?
- Next by Date: Re: SELECT locking: EXACTLY HOW?
- Previous by thread: Re: database size vs. its performance
- Next by thread: Want to transfer data to/from SQL Server database?
- Index(es):
Relevant Pages
|
