Solved

how to track a sql database to see the amount of data inserted over a period of time

Posted on 2011-09-20
4
202 Views
Last Modified: 2012-05-12
Hi All,
I want to know the amount of data inserted into database each daty for the last 1 week.
Is there a query to find out this?
Thanks in advance.
0
Comment
Question by:msdba
  • 2
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 36569578
>>I want to know the amount of data inserted into database each daty for the last 1 week. <<
Find the total space used and store it. Next day do the same and record the diference.

>>Is there a query to find out this?<<
Not really.
0
 

Author Comment

by:msdba
ID: 36573618
Thanks for the response.
Is there any other way of doing it if not through query.
pls don't say monitor your disk space or data files growth daily.
ha ha.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36575142
>>Is there any other way of doing it if not through query. <<
No.
0
 

Author Closing Comment

by:msdba
ID: 36581464
ThANKS
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now