April 29, 2015 at 8:46 am
Hi,
How can we monitor the all tables in all databases and send notifications to the team.
Is there a way to check to find the no of rows and size of a table last month and find out growth % now
April 29, 2015 at 9:10 am
ramana3327 (4/29/2015)
Hi,How can we monitor the all tables in all databases and send notifications to the team.
Is there a way to check to find the no of rows and size of a table last month and find out growth % now
Quick thought, probably the only place you are going to find last months numbers are in your backup, if you start monitoring now that will become your earliest reference point.
😎
April 29, 2015 at 9:11 am
Unless you have some field in a table that has a date stamp of some sort, you can't go back and look at sizes directly. If you have old backups, you can use that.
Ideally, the best thing is to have a monitoring tool, like SQL Monitor[/url]. You could set up graphs/metrics for specific tables if you wanted them. Likely it's not worth setting them up for every table.
http://monitor.red-gate.com/Analysis/Graphs
If you really want to know how different tables are growing, you can run a SELECT COUNT(*) for all tables and store the results. You can use something like this: http://www.sqlservercentral.com/blogs/sqlandme/2011/12/28/sql-server-row-count-for-all-views-tables/. If you do that, I'd run this daily at best, maybe weekly, and store the results in a table in your database. Have a job add the results (with the date) on a regular basis and you can look at how tables are changing.
Disclosure, I work for Redgate Software
April 29, 2015 at 9:56 am
We are using the third party tool (Sql Sentry) to monitor the Sql server
April 29, 2015 at 9:58 am
I don't know if they can capture table row counts. I'm sure they have data size over time.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply