In order to improve the performance of SQL Server, SQL Server administrator must evaluate the SQL Server performance. Such act helps in managing SQL server storage capacity and storage issues efficiently. Performance of SQL Server can be improved by performing various tasks such as database defragmentation, shrinking, partitioning, reorganizing indexes, etc.