• Adam Thurgar

Quick SQL Server checklist


What do you check if you only have a limited amount of time to review a SQL Server. You can''t run your usual set of scripts. All you have is pen, paper and maybe a query window to run some T-SQL.

This is what I would try to gather.

a) Physical server

- Name (fully qualified) and IP address/addresses

- Amount of memory

- Number of CPUs

- Disks, capacity and free space

b) SQL Server

- Version

- Edition

- Build number

- min and max server memory

- CPU affinity

- index fill factor

- backup compression

- cost threshold for parallelism

- maxdop

c) Databases

- ownership

- recovery model

- compatibility level

- autoshrink, autoclose, autocreate stats etc - anything weird?

d) Scheduled jobs

- Backups (full and transaction logs)

- Maintenance

This should give you a sneak peak into the health of the server and any big ticket items that may need immediate attention.


9 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t