URGENT HELP DATAFILE GROWTH - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

URGENT HELP DATAFILE GROWTH

Author

Topic

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-10-14 : 04:36:48

Guys I really need help..

2 months ago I transfered a database from a sql2000 to SQL 2005 the database then was 400MB and it was a normal size. 2 weeks ago I realised a change on the size and from that time the growth is rising all the time. Yesterday My Datafile was 17 GB and now is 23 please tell me a suggestion..

Soon I will be out of space.

Regards

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-14 : 05:21:34

Is it the database file that grows or the log file that grows?

E 12°55'05.63"
N 56°04'39.26"

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-10-14 : 06:39:20

The data file. But I found the reason Peso. The developers made some changes to the software and a specific table was recording 15 rows of data every ms. as a result to have this growth. I spoked qwith them and they try to fix it. It's a softwrare issue finally.

Thanks for your reply
Panagiotis Lepeniotis

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-14 : 06:43:48

That is not that bad. Only 5 bytes per insert.

5 bytes * 15 * 1000 every second
86400 seconds per day and 1 day equals 6 GB.

E 12°55'05.63"
N 56°04'39.26"

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-10-14 : 08:56:35

Exactly! 6 GB for a DB which 1 week ago was a small one! But I can't spend my disk space for this database because its importance its not the highest. Its not a critical DB. If it was an other DB I would be in a very difficult situation.

Thanks again peso.

By the way if you have time I would appreciate to have a look at my new topic. Any suggestion will be really helpfull
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112519

Regards,
Panagiotis Lepeniotis

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources