Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-16 : 08:11:53
|
Dan Pitluk writes "I have a table that is accessed pretty much 24 hours/day. Inserts and Selects, no updates and almost no deletes. I'm not sure of the longest idle time the table gets, but it's probably no more than 10 minutes at the most. Very often no idle time at all. (FYI, the database is on the internet, so people all over the world are hitting it).
I host this database at an ISP (HostDepot). I don't know what's going on over there, but my table size is HUGE. I've read the SQL Server manual and I calculate the table size to be approximately 8 MB. Their size is about 300 MB. The table has 4 columns. Two 5 byte char, one 4 byte int and one 4 byte smalldatetime. That's 18 bytes. This isn't the correct calucation, but a very rough estimate in size would be 300,000 rows * 18 bytes. That's 5.5 MB. Even doubling this for some overhead is WAY short of their 300 MB. I also have 5 indexes on the table which take up more than 40MB of disk space.
What sort of settings could the folks at HostDepot be missing? Can you recommend an ISP who knows what their doing? Is HostDepot doing all they can? Does SQL Server need some idle time to do housekeeping?
Thanks!" |
|
|
|
|
|
Table Size