A critical part of database design and management is index design. Index design involves balancing space requirements and the resource overhead required to keep indexes up-to-date compared to the performance improvements resulting from the indexes. You can either use dynamic management functions (DMFs) and views (DMVs) or Database Engine Tuning Advisor to identify index needs based representative server activity.
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training costs and poor database administrator (DBA) productivity.
To keep up with these new demands of complex enterprise database management solutions, Microsoft ships SQL Server software with a broad group of several graphical management tools that help DBAs and developers efficiently create, manage and maintain SQL Server solutions, and allow them to quickly resolve complex performance and configuration problems.
This article is published on SearchSQLServer.techtarget.com.