December 9, 2008 at 7:54 am
Hi All,
I have an issue, I want to know Weather teh datafiles are modified or not, If yes When the datafile is modified ie : who increased the size of the file and how much he increase and when it happened. Its urgent, In One of my server I suspect that some one has increase 1024BM on one of the database, and I wanted to know the details of the person who increase the size, Is it possible to know ?
December 9, 2008 at 1:28 pm
Are you asking to as whether or not a user altered the size of the database by increasing the space allocation or if the database simply grew by it's grow rate due to a data modification?
If it's the latter, no, not unless you have active profiling occurring. If not, I am not sure but that type of event may be recorded in the default SQL server trace (assuming you didn't turn it off).
December 9, 2008 at 2:39 pm
The default trace might help, but not sure if this is recorded.
A 1GB increase isn't much. If it is, you might have other issues. You should also always have free space in your data files unless they are read-only and already indexed. It's not like a Word or Excel or Access file.
December 9, 2008 at 11:53 pm
December 10, 2008 at 2:42 am
who increased the size of the file and how much he increase and when it happened. ... I suspect that some one has increase 1024BM on one of the database
It could be AutoGrowth. Why do you suspect some one did that? Are you sure its not autogrowth?
December 10, 2008 at 12:37 pm
If you have SQL 2005 and have the reporting pack installed, you can right click on your database, select reports->standard reports -> Disk Usage. Below the graphs it has a expandable section called Data/Log Files Autogrow/Autoshrink events that show the last time the file autogrew or shrank how long it took, and how big the change was in MB.
EventLog File Auto GrowthLog File Auto Growth
Logical File NameDatabase_LogFile1Database_LogFile1
Start Time12/5/08 7:08 AM12/4/08 7:30 AM
Duration (ms.)884010280
Change In Size (MB)1,000.001,000.00
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply