|
Home > Archive > MS SQL Server > February 2006 > Number of Objects and Performance
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Number of Objects and Performance
|
|
| Sierra 2006-02-28, 8:23 pm |
| How does the number of objects (specifically tables) affect overall
performance of SQL Server?
Does SQL Server slow down as more objects are added - even if the overall
data size remains relatively the same?
How significant is this slowdown? Is it noticible after thousands of
objects, millions, etc?
| |
| Adam Machanic 2006-02-28, 8:23 pm |
| No, there's no direct correlation between number of tables and server
performance. There may be a correlation between number of tables used per
query and performance, however -- generally speaking, the more joins in a
query, the worse it tends to perform (again, generalizing a bit here -- that
is certainly not always the case.)
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Sierra" <Sierra@discussions.microsoft.com> wrote in message
news:89C2D762-17D5-482D-A719- 9A077C64392B@microso
ft.com...
> How does the number of objects (specifically tables) affect overall
> performance of SQL Server?
>
> Does SQL Server slow down as more objects are added - even if the overall
> data size remains relatively the same?
>
> How significant is this slowdown? Is it noticible after thousands of
> objects, millions, etc?
|
|
|
|
|