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?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@.microsoft.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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment