May 8, 2012 at 12:58 am
dear all
what is production database size generally(500gb or 1tb) and how to monitor the database
what is step for monitoring production database
Thanks
May 8, 2012 at 1:57 am
Size widely depends on what you store, how often you purge and the amount of indexes and other objects are within the database. I have prod DB's which range from 150MB up to 2TB. Size can be monitored via PBM and other custom built methods like quering the DMV's and building your own custom metrics.
May 16, 2012 at 1:25 am
This is a very open ended question.
Monitoring the db size also comes with capacity planning, archiving, storing your transaction log to different drive, transaction log backup.
Just monitoring alone will not help you. You will be caught in surprise when all of sudden your transaction log fills up.
Start preparing more on this topic other than just monitoring.
May 17, 2012 at 4:18 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply