File-Sizing

One of the primary areas of responsibility for DBA’s is maintenance, and one of the primary maintenance tasks is file-size management. First I’ll present a list of the file-sizing tasks with short explanations for each one, then some background information, and then some T-SQL to give you the file sizes for all data and log…


Primary DBA Responsibilities

SQL Server is so well-behaved it’s often installed by 3rd party applications in an organization or department without a professional Database administrator (DBA). When such implementations need attention (e.g. backups), system administrators often get involved as acting-DBAs, and some of them discover they enjoy it and start spending more and more time with SQL Server….

10

Defragmenting Indexes

Last update to script 1Nov2011. Maintaining indexes is a primary duty of Database Administrators, because appropriate indexes are critical to maintaining high performance in any relational database, and proper maintenance is required to avoid excessive fragmentation. In case that’s not clear enough, let me emphasize: index fragmentation can dramatically degrade performance. While the Maintenance Plan…


SharePoint User Connections

A long time ago I learned a SQL Server performance guideline: User Connections should be well under 255. I think I learned that while working with SQL Server 6.5 or 7, and if it did go over 255, SQL Server would have to significantly increase the amount of memory used per connection to manage them all. In a…