I asked this question of a couple people a few years ago at Convergence, but I'd like to see what the rest of the community has to say. Is there a recommended size that a company database should stay below? When I asked at Convergence, most databases seemed to be below 10GB; ours is significantly over that.
Thanks
*This post is locked for comments
That's a very cool query Jonathan. Thanks!
Carl you have to remember that the more information you have a table the larger the database. This isn't just one table you are looking at but all of them. You can use the following script that will tell you how large each table is:
SELECT [total size KB], B.rows, O.name
FROM (select sum(convert(decimal(10,0),dpages)*8129/1024)
[total size KB], id
FROM sysindexes group by id)
A INNER JOIN sysindexes B ON A.id = B.id and B.indid in (0,1)
INNER JOIN sysobjects O ON B.id = O.id WHERE B.rows <> 0
ORDER BY [total size KB] desc
Thanks for the input so far. Heather, is there a way to determine the number of records?
I agree that size is not necessarily an issue. I am working with one of my clients currently to archive some of their data. They have been a GP site for 10+ years and have lots of one off customers. This has meant the number of customer records grows and grows. That slows down processes such as statements that query all customer records.
So it is not necessarily about size, but maybe number of records attached to regular processes that can determine that it is time to archive.
There is no recommended size for a GP database. Many of our clients who have an ecommerce component will have a database of hundreds of gigabytes if not a terabyte. The real question is that space being taken up by useful data or not. Sometimes third party or custom triggers can create thousands of useless records. You would really need to analyze what is in your database and what can stay and what can go. Also, there are archiving products out there as well as SQL tuning techniques to keep your system running at optimum speeds.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (