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 |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-05-28 : 06:48:51
|
| Hi Guys.Could some please assist.We have a SQL 2005 Standard Edition Server This server holds 1 DB call it MyDB.Some background on our custom App.We have several 100 devices in the field that sends data (+/-) 3KB every 5 min's per device) over a specific port on our SQL server.This data is then inserted into SQL in a table call it messages.The amount of rows in this table now sits at 2874276The MDF file is about 1.88 GBThe LDF file is about 15.2 GB (Why is this so big?)Memory usage on SQL = 1.4 GBIs there anything i could do to get some stat for this DB or even a table?Like how long a read or write takes or anything that can tell me how the DB is performing.On top of that is ther anything that can tell me or indicate growth for this DB?Like by how much space it used 2 weeks ago?Any help would be appreciated. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-28 : 07:55:39
|
I have posted the following in a thread (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119142)1. Calculate needed space for a complete row in your table (simple addition of size of all columns)-- for example it results in 384 byte2. A page can hold 8064 byte of data (8192 - 128 for administrate the page)3. 8064 / 384 = 21 rows fit to one page4. 100 mb = 104857600 / 8192 = 12800 pages5. 12800 available pages * 21 rows = 268800 rowsThat may help youWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-28 : 07:57:29
|
And size of logfile depends on- used recovery model and- backupsi.e. Recovery model FULL and no backup log = growingWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Log File