December 22, 2008 at 10:08 pm
Hi,
I have notice that one of the our sql 2000 production server database size is increasing daily, but still there is no transaction last 20 days on server.
this is following sample size of database increasing daily
18-Dec-2008 -264759 MB
19-Dec-2008 268556 MB
20-Dec-2008 272733 MB
22-Dec-2008 277255 MB
23-Dec-2008 285086 MB
could you tell me what should i check database?
thanks
December 22, 2008 at 10:39 pm
Databases don't grow by it self if they don't need the space. Maybe someone increased the size of the database manually or data was modified and the database didn't have enough space it and it had to allocate more space for the files. Another option is that you got the wrong size when you checked for the database's size.
Are you sure that there is no activity on the server? How did you determine that no one modified the data in the past 20 days? How did you determine the database's size?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 22, 2008 at 11:20 pm
thanks for your reply..
As per your Question,
1. Are you sure that there is no activity on the server? How did you determine that no one modified the data in the past 20 days?
Yes, Actually this database have 10 objects, i had check all the tables by select command and last data or records has stored in past 10-Dec-2008,
I don't know could you tell me, how do find out last transaction in database? is there any command plz give me.
2. How did you determine the database's size?
I determine the database size through EM->select DB > then right click, and select properites, it has shows all details.
thanks
December 23, 2008 at 12:03 am
ananda.murugesan (12/22/2008)
1. Are you sure that there is no activity on the server? How did you determine that no one modified the data in the past 20 days?Yes, Actually this database have 10 objects, i had check all the tables by select command and last data or records has stored in past 10-Dec-2008,
I don't know could you tell me, how do find out last transaction in database? is there any command plz give me.
This doesn't mean that there were no modifications. Since I can insert my own value into any column, I can insert a record today with another date. Also I can insert many records that will cause the expansion of the database and then delete them. Another option is updating existing records with variant length columns and changing the record's size so it will be longer then before (and of course will need more space). In order to be sure that no one modifies data in this database, you can run profiler and use the database's ID as a filter (If I remember correctly with SQL Server 2000 filtering by database's name isn't working, but I might be wrong here).
2. How did you determine the database's size?
I determine the database size through EM->select DB > then right click, and select properites, it has shows all details.
thanks
With SQL Server 2000 there might be some problems with those reports. You can run DBCC UPDATEUSAGE before checking the database's size. Notice that if you have a busy server, this could influence performance. Another alternative is to check the size of the database's files in the OS.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 23, 2008 at 1:42 pm
Check for any database maintenance related operations like reindexing or so.
MJ
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply