By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Procedure to moniter database

rsrinivasan
100+
P: 221
Hi all,

Is any system procedure is available in sql server 2000 to moniter the database growth?

Thanks,
Jan 30 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
Hi all,

Is any system procedure is available in sql server 2000 to moniter the database growth?

Thanks,
please define monitor

-- ck
Jan 30 '08 #2

rsrinivasan
100+
P: 221
please define monitor

-- ck
I want to know each and every table growth from previous day over some period.
Jan 30 '08 #3

ck9663
Expert 2.5K+
P: 2,878
I want to know each and every table growth from previous day over some period.
create a job that will run every end of the day when there's less server activity to gather all the information you need and store it in the table...am not sure if sys.sysindexes system table is available at SQL 2000.

-- ck
Jan 30 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.