I guess I can't complain too much, it's been running pretty much flawlessly for a couple years now. My Concern is this.
I have 10 pc's on the shop floor collecting data and replicating back to the server. Each db on each pc is anywhere from 850mb to 960mb, but the main DB where everything is replicated back to is only 1.1gb. Not what I was expecting, but OK, I can live with it.
On our 10 pc's, there is a table that is just collecting locally that does not get replicated back. It is just a maint table that we can look at if there is a problem. Now, this particular table gets written to every second that the application is collecting data. SO there are about 1 million rows in the table at any given time, with about 7 columns...not a huge table, but still.
So, why would each individual DB be 900 mb...could this one table with 7 columns and 1 million rows be taking up that much space to where the DB's on the 10 pc's would be that big.
If someone could shed some light on the subject that would be great. Thanks in advance.