Describe how you would monitor and control database physical file size and growth.

  • Interview Candidate
  • 3
  • 5360

Showing Answers 1 - 3 of 3 Answers

seemabuchhada

  • Mar 14th, 2014
 

The Disk Usage report is particularly helpful for monitoring and managing database size. It displays total space usage, autogrow and autoshrink events, as well as disk space used by data files. To run this report, you just need to right-click the database in SQL Server Management Studio (SSMS) and select Reports, Standard Reports, Disk Usage.
You can manage growth by using reports, using alerts, and manually resizing a file group or creating a new one when necessary.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions