Understanding SQL Server Query Optimization – Part 3

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.

Click here to read full article on SQL-Server-Performance.com

Advertisements

Six top SQL Server 2012 management tools you should know about

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.

Checkout my article here, in which I gave an overview of the key features of these graphical SQL Server 2012 management tools.

This article is published on SearchSQLServer.techtarget.com.