How Large Can SQL Server 2005 Database Be?
-
Hi Guys, I'm thinking about using SQL2005 for storing various documents, images and binary files. Therefore, the database size will grow quite large. There won't be many rows in the database tables. And let's assume I design my database well ;) The large database size is only due to the binary files. Does anyone know if there will be an impact on performance as the database size grows very large (to, say, 10s of gigabytes). Thanks in advance! Visit Riverside Internet[^] Visit Mike Puddephat Online[^]
-
Hi Guys, I'm thinking about using SQL2005 for storing various documents, images and binary files. Therefore, the database size will grow quite large. There won't be many rows in the database tables. And let's assume I design my database well ;) The large database size is only due to the binary files. Does anyone know if there will be an impact on performance as the database size grows very large (to, say, 10s of gigabytes). Thanks in advance! Visit Riverside Internet[^] Visit Mike Puddephat Online[^]
Mike Puddephat wrote:
How Large Can SQL Server 2005 Database Be?
The maximum size is just over 1 billion terrabytes - Is that large enough? (ref: Enterprise Edition)
Mike Puddephat wrote:
Does anyone know if there will be an impact on performance as the database size grows very large (to, say, 10s of gigabytes).
I don't see a great problem with that. The largest database I use on a day-to-day basis is 150Gb (growing at around 50Gb per year) The only issue is that the hardware that supports it has to be capable as well. As you won't have many rows, just lots of binary data then I guess it won't need to do much processing, just need lots of fast disks. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
-
Mike Puddephat wrote:
How Large Can SQL Server 2005 Database Be?
The maximum size is just over 1 billion terrabytes - Is that large enough? (ref: Enterprise Edition)
Mike Puddephat wrote:
Does anyone know if there will be an impact on performance as the database size grows very large (to, say, 10s of gigabytes).
I don't see a great problem with that. The largest database I use on a day-to-day basis is 150Gb (growing at around 50Gb per year) The only issue is that the hardware that supports it has to be capable as well. As you won't have many rows, just lots of binary data then I guess it won't need to do much processing, just need lots of fast disks. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
Thanks, Colin! I guess that was the answer I was looking for! :) Visit Riverside Internet[^] Visit Mike Puddephat Online[^]