[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

datagrowth since yesterday?

is there a way to check which databases grew in size since yesterday by autogrowth?
0
25112
Asked:
25112
4 Solutions
 
Anthony PerkinsCommented:
In SQL Server 2005 it is pretty easy to see that in the Report Disk Usage, but it does involve opening each one individually.
0
 
AnujCommented:
Create a job that query the db file space information and save this to a table, you need to schedule this job to run daily. Later you can create custom SSRS reports or Query this table.

The following link will help you Database size Growth chart report
0
 
jogosCommented:
Timestamp off a db-file changes when allocation changes.  

In the result off the script on link by @anujnb see if there is nowhere where the log file is big and recovery model is FULL -> could be your transaction log backup is failing.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
25112Author Commented:
acperkins, the report tell me when the autogrowth happened.. so it must be in a system table?
0
 
Anthony PerkinsCommented:
>>the report tell me when the autogrowth happened.. so it must be in a system table? <<
It is possible.
0
 
Anthony PerkinsCommented:
Actually it is not in a system table.  Since you probably do not have a Profiler session setup to monitor this, your best bet is to use the default trace.  Here is a good article on the subject:
Default trace - A Beginner's Guide
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

Look for a trace event with a name containing the phrase 'Auto Grow'
0
 
Anthony PerkinsCommented:
And I should have mentioned that you have to be using SQL Server 2005 or higher.
0
 
25112Author Commented:
thanks i see it
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now