January 19, 2015 at 2:56 am
Hello,
Could some one suggest any tool for Monitoring (how size of the tables is increasing,the columns of tables,which table is largest etc.) the tables of SQL Server 2012.
Thanks in advance
KK
January 19, 2015 at 4:31 am
I would use the Data Collector for this.
It has built-in collectors for database size and can be extended to monitor what you're looking for. Do you need help to set it up?
-- Gianluca Sartori
January 19, 2015 at 4:35 am
Its 2012. I am sorry, I guess I posted on 2005 by mistake. Could you suggest for 2012 please.
Regards
KK
January 19, 2015 at 4:40 am
Use the Data Collector.
You can create a custom collection set to capture the size of the tables and whatever you need to capture.
You can use Extended T-SQL Collector to set up the collection set with a GUI.
To capture the size of the tables, this is a good example: http://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply